Intersolv ODBC Driver

Help me!
I try to import some data from an informix 5.0 table to Sql Server 2000 with
a DTS package.
I use Intersolv ODBC driver version 03.011.0021 to connect to the database.
It works well, but i can't define a parameter in the sql statement. For
example if a try to execute :
select *
from table
where field = ?
The dts environment give me an "unspecified syntax error...."
Where is the problem?
The driver don't support parameters or these must be defined with another
syntax?
Bye
DanieleCan you post a code snippet?
SQL Server T-SQL doesn't support anything close to that syntax so I'm not
sure what you're doing exactly...
From T-SQL, you would need to build dynamic SQL or use sp_exectutesql to do
the parameterization you're talking about.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Nonno Oreste" <dffdfd@.dfd.dfd> wrote in message
news:OSsw2unuDHA.1596@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Help me!
> I try to import some data from an informix 5.0 table to Sql Server 2000

---

with

quote:

---

> a DTS package.
> I use Intersolv ODBC driver version 03.011.0021 to connect to the

---

database.

quote:

---

> It works well, but i can't define a parameter in the sql statement. For
> example if a try to execute :
> select *
> from table
> where field = ?
> The dts environment give me an "unspecified syntax error...."
> Where is the problem?
> The driver don't support parameters or these must be defined with another
> syntax?
> Bye
> Daniele
>

---