I've got a script that runs a query that uses a user defined function. The query looks something like 'SELECT * FROM dbo.f_myfunction(?, ?, ?);'
My problem is that prepare fails with a syntax error indicating that there is a problem near @P1. I'm using DBD::ODBC to connect to MS SQL Server 2000 through DBD::Proxy, but I've also tried it directly from DBD::ODBC with the same results. Any ideas? Thanks! =) --TWH DBD::Proxy::st execute failed: Server returned error: Failed to execute method CallMethod: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '@P1'. (SQL-42000) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at C:/Perl/site/lib/DBI/ProxyServer.pm line 344. DBD::Proxy::st execute failed: Server returned error: Failed to execute method CallMethod: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '@P1'. (SQL-42000) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at C:/Perl/site/lib/DBI/ProxyServer.pm line 344.
