in reply to DBD::ODBC and TSQL
First, the use some_database command needs to be run in its own batch (or at least that is true of Sybase - I suspect the same is true of MS-SQL).
Second, you return data from your script with print @c. This will not return a row of data - it will return what is known as out-of-band data that is normally directed at an error/message handler - thus calling fetchrow_array won't work.
You could change the SQL code from print @c to select @c and your script will most likely work.
Michael
|
|---|