Right - in that case, as the message says placeholders are only support for TDS 5.0, and when you connect to an MS-SQL server you are either at TDS 4.x or at TDS 7.
Michael Michael Gargiullo writes: > sorry, Yes, I'm using freeTDS with DBD::Sybase driver. > > > -----Original Message----- > From: Michael Peppler [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 29, 2002 9:58 AM > To: Michael Gargiullo > Cc: Dbi-Users-Help; Dbi Perl > Subject: Re: updating a DB > > > 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 > -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] *or* [EMAIL PROTECTED] http://www.mbay.net/~mpeppler International Sybase User Group: http://www.isug.com
