|
|
sybperl-l Archive
Up Prev Next
From: "Mr dot Dan" <bitsandbytes88 at hotmail dot com>
Subject: Panic: dynamic SQL (? placehoders) are not supported
Date: Oct 23 2006 6:21PM
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
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.
mpeppler@peppler.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com
_________________________________________________________________
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
|
