SPUG: MS SQL & ODBC and nested queries (use odbc_cursortype => 2inconnect)

Andrew Sweger andrew at sweger.net
Fri May 14 22:04:46 CDT 2004


On Fri, 14 May 2004, Aaron W. West wrote:

> I installed DBD::Sybase long back, but I thought I found out it has no
> support for ? placeholders with MS-SQL. Am I wrong?

You might be wrong. I seem to recall using placeholders with DBD::Sybase
against both MS-SQL and Sybase servers back in 1999. The prepared
statements might not have been cached at the time (saved optimizer
analysis, etc.) other than the last prepared statement (good for repeated
queries or inserts, for example). But it was so long ago, it might have
been from another life.

-- 
Andrew B. Sweger -- The great thing about multitasking is that several
                                things can go wrong at once.




More information about the spug-list mailing list