Re^4: 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
I don't know all that much about the issues with DBD::Sybase & MS-SQL, but I can try to help. 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]

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]