in reply to DBD::ODBC and TSQL

You can certainly execute T-SQL code via DBI. However, you should be aware of certain limitations.

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