Re: Intersolv ODBC Driver

You could turn tracing on for ODBC and see exactly where does the call die. Most likely this will be a problem with the ODBC driver. You could also turn a third party tool such as WinSQL (http://www.synametrics.com/winsql) to export data and see if that works. Pete. -- You don't pay to get spam, why pay to clean it? Visit http://www.spammarshall.com to create an account for free <http://www.spammarshall.com>; il Fermo wrote: >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 >Daniele > > > >Posted from X-Privat Free NNTP server - www.x-privat.org > > <http://www.spammarshall.com>;