Re: Intersolv ODBC Driver

[[ This message was both posted and mailed: see the "To," "Cc," and "Newsgroups" headers for details. ]] In article <3fcf1d3b@x-privat.org>, il Fermo <dffdfd@dfd.dfd> 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 Hi, Daniele -- The problem you're experiencing is most likely due to the fact that DTS is actually an OLE DB client application, rather than an ODBC client. DTS uses the Microsoft OLE DB Provider for ODBC, by default, when connecting to an ODBC data source. This Provider has a number of issues with some aspects of the ODBC API, one of which is parameterized queries. You may wish to experiment with the OpenLink ODBC Driver for Informix, and/or the OpenLink OLE DB Provider for ODBC, both of which have been shown to deliver better results with the DTS tools than the DBMS- or Windows-included components. All OpenLink products are available for download, with a free 30-day evaluation license, from our main website -- http://www.openlinksw.com/ Best regards, Ted -- A: Yes. | Q: Are you sure? | | A: Because it reverses the logical flow of conversation. | | | Q: Why is top posting frowned upon? Ted Thibodeau, Jr. // voice 781-273-0900 x32 Evangelism & Support // mailto:tthibodeau@openlinksw.com OpenLink Software, Inc. // http://www.openlinksw.com/ * NEW * OpenLink Blogs // http://www.openlinksw.com/weblogs/ Universal Data Access and Virtual Database Technology Providers