Re^4: DBI::Sybase -retrieving BLOB values from ms-sql question


Problems? Is your data what you think it is?
	PerlMonks

Re^4: DBI::Sybase -retrieving BLOB values from ms-sql question

by Anonymous Monk

on Jul 10, 2006 at 02:20 UTC ( [id://560058]=note: print w/replies, xml )

Need Help??

in reply to Re^3: DBI::Sybase -retrieving BLOB values from ms-sql question
in thread DBI::Sybase -retrieving BLOB values from ms-sql question

hello michael i have tried using $source_dbh->do("set textsize 40000"); before the prepare statement and it doesn't work... please help:) thank you. gordon

Comment on Re^4: DBI::Sybase -retrieving BLOB values from ms-sql question

Replies are listed 'Best First'.

Re^5: DBI::Sybase -retrieving BLOB values from ms-sql question
by mpeppler (Vicar) on Jul 11, 2006 at 17:18 UTC

The most likely problem is that you are for some reason opening more than one connection. This can happen if DBD::Sybase thinks that the connection is still active when prepare() is called. You can set the syb_no_child_con connection attribute to TRUE and this will inhibit multiple connections for simultaneous statement handles.

You can also enable the DBI->trace() to see what really happens under the covers.

Michael

[reply]

In Section Seekers of Perl Wisdom