Re^3: pass MS SQL server scripts into Win32::ODBC

[mje]

in reply to Re^2: pass MS SQL server scripts into Win32::ODBC
in thread pass MS SQL server scripts into Win32::ODBC

Some of these statements are transact-SQL and cannot be used over ODBC in the way you are doing it. You could create a procedure over ODBC which can use t-sql statements.

Of course, I'm presuming there is more to the script than what you posted as it is effectively just a select statement.

[Anonymous Monk]

Thank You Both.

I didn't realize the limitation of ODBC and transact statements

I appreciate the advise and comments/guidance