freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] Dynamic SQL Placeholders,
Spadea, David NYC, 11/23/2004
- Re: [freetds] Dynamic SQL Placeholders, James K. Lowden, 11/24/2004
Archive powered by MHonArc 2.6.24.