Skip to Content.
Sympa Menu

freetds - [freetds] Dynamic SQL Placeholders

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Spadea, David NYC" <DBSpadea AT citco.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Dynamic SQL Placeholders
  • Date: Tue, 23 Nov 2004 16:08:31 -0500

Hello,

I am running a FreeTDS-linked DBD::Sybase against a Sybase 12.5.3 database.
When I try to use a prepared statement using placeholders ("?"), I receive
the following error:

Panic: dynamic SQL (? Placeholders) are not supported by the server you are
connecting to at ...

The SQL was a simple insert into a temp table...

insert into #blarg (test) values (?)

...where the 'test' column is an int.

Linking DBD::Sybase against the Sybase libraries allows this prepared
statement to work, but then I lose my ability to talk to SQL Server.
Unfortunately, I need to be able to connect to both from the same program.

Is this a problem with FreeTDS? If so, has it been fixed in more recent
versions? Current versions are libct 1.0, libsybdb 3.0, libtds 2.0, and
libtdssrv 1.0 (from the lib/ directory filenames).

I know this isn't much information to go on, but if you can provide any
insight or let me know what type of additional information I should provide,
I'd appreciate it. The ultimate goal is to exec stored procedures on both
SQL server and Sybase.

Thanks for your time,

Dave Spadea





Archive powered by MHonArc 2.6.24.

Top of Page