Re: ADO 2.0/Informix 2.8 ODBC Driver Problems (from VB 6)

Can't give you any specifics however we found that the 2.80 driver is v buggy and so moved to Intersolv's 3.11 driver which is fine. I would recommend this (bear in mind that the 2.5 driver you already have is written by intersolv!, the 2.80 driver is not [as far as I know]) I wasted too much time with the 2.80 driver - I'd advise you to ditch it now. eichmtim@pentamation.com wrote in message <73v8a5$2i8$1@nnrp1.dejanews.com>... >Ok, I'm working on a VB app that runs on a WindowsNT 4.0 Server and is to talk >to an Informix SE 7.22 database on a UNIX box. The app is to use ADO 2.0 >Connection/RecordSet objects to talk to the INFORMIX 2.80 32-bit ODBC driver >(which is MTS compliant--since we're also adding MTS into the mix). > >The problem we're running into is this: when the ADODB Connection object >attempts to Open the connection we get the following error back: > > >[Informix][ODBC Informix Driver][Informix]Syntax disallowed in this database >server. > > >The first strange thing is this: we have the Informix-CLI 2.5 driver left over >from the 2.02 CLI, and that WORKS using the exact same code, SetNet and ODBC >settings! > >Now, we checked our connection calls and we're not doing anything strange in >our call, in fact here's the code: > > >strConn = "DSN=" & Trim(pstrDSN) > >If (pstrUID <> vbNullString) Then _ > strConn = Trim(strConn) & _ > ";UID=" & Trim(pstrUID) & _ > ";PWD=" & Trim(pstrPWD) & ";" > >cnn1.Open strConn > > >The connection string (strConn) gets assembled correctly: >"DSN=gfms;UID=eichmtim;PWD=notreal;" > >The DSN works through other ODBC applications (ODBC-ISQL/w by Fernando Felix, >MS-Query from SQL-Server, etc.), just not from our VB code that uses ADO 2.0. > >Any ideas what my generate this problem? Thanks! > > >And just a rehash of our setup: > >NT 4.0 Server (Enterprise Edition) >ADO 2.0 >ODBC 3.51 >INFORMIX-SE 7.22 (on a SCO/UNIX box) >INFORMIX-CLI 2.10 (Informix 2.80 ODBC Driver) >MS-Transaction Server (MTS) 2.0 >Visual Basic 6.0 > > >Thanks again! > > > >Tim Eichman, Associate Programmer/Analyst >Product Development Department >Pentamation Enterprises, Inc. > >Email: eichmtim@pentamation.com > >------------------------------------------------------- Confidentiality >Notice: This email transmission may contain confidential or legally >privileged information that is intended only for the individual or entity >named in the e-mail address. If you are not the intended recipient, you are >hereby notified that any disclosure, copying, distribution, or reliance upon >the contents of this e-mail is strictly prohibited. If you have received >this e-mail transmission in error, please reply to the sender, so that >arrangements can be made for proper delivery, and then please delete the >message from your inbox. > >Thank you. > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own