Panic: dynamic SQL (? placehoders) are not supported

Hi,

I'm getting the error in my subject line from a perl script.  I included an 
article from you from some time ago that is similar, below.


ATTEMPT: 1
Panic: dynamic SQL (? placeholders) are not supported by the server you are 
connecting at 
/usr/local/perl-5.8.8/lib/site_perl/5.8.8/x86_64-linux/DBD/Sybase.pm line 
133   Does your suggestion still apply.  The server I'm connecting to is 
11.9.2 but I'm using the latest Sybase client, OCS-15.0.   The funny thing 
is that this script works going to the same server but run from Solaris 
instead of linux with an older Sybase open client and Sybase.pm.  We are 
trying to migrate to linux though.

Thanks,
~DjK




ATTEMPT:2
Panic: dynm...(the same thing again)











From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Unable to use ? placeholders in DBD::Sybase when connecting to 
MS SQL
Date: Nov 16 1999 3:03PM

Hrvoje Niksic writes:
 > I'm in the process of testing DBD::Sybase, and the ? placeholders
 > don't appear to work for me.  I connect to MS SQL 6.5 using CTlib
 > 11.9.2, Sybperl 2.11, and DBD::Sybase 0.21.  The error message printed
 > is:
 >
 > Panic: dynamic SQL (? placeholders) are not supported by the server you 
are connecting to at /usr/local/lib/site_perl/i386-linux/DBD/Sybase.pm line 
95.
 >

Placeholders are supported at the protocol level. Sybase started
supporting placeholders (aka dynamic SQL in Sybase-talk) with TDS
5.0. The common protocol understood by Sybase and MS-SQL is 4.2, so
you're out of luck.

If I may make a suggestion: use stored procedures instead of using SQL
straight in the perl scripts. The stored procs can be easily tuned,
and give you an additional level of abstraction between the script and
the database, and are pre-compiled (so a little bit faster)

Michael
--
Michael Peppler         -||-  Data Migrations Inc.
[email protected]    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: [email protected]

_________________________________________________________________
All-in-one security and maintenance for your PC.  Get a free 90-day trial! 
http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail