Michael Gargiullo writes: > Hey all.. I'm new to connecting to a DB from Perl. > > I followed the instructions in Linux Journal on how to install DBI, and > Freetds to connect to MS sql sever 2k. I can connect and get data, (It > included a test script), but I want to update rows in a DB. The data is > going to change so I wanted to use variables in the query. I followed some > code on dbi.perl.org, but get a few errors > > Errors: > Couldn't prepare queries; aborting: > No such file or directoryServer message number=10000 severity=7 state=0 > line=1 server=OpenClient text=Dynamic placeholders only supported under > TDS 5.0 at ./zip.pl line 31.
That error message *seems* to point at a Sybase low-level driver. My *guess* is that you are using ODBC, but that the ODBC is using the Sybase client libraries to connect to the server. This will work, but it won't support placeholders because when a Sybase and MS client/server connect they fall back to TDS protocol level 4.2, which doesn't support placeholders. The work-around in that case is to place the variables directly in the SQL statements. Could you give us some more information on which DBD module you are using? If you are using DBD::Sybase, are you using FreeTDS? Thanks. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] *or* [EMAIL PROTECTED] http://www.mbay.net/~mpeppler International Sybase User Group: http://www.isug.com
