Thanks, I had already used UCI Editor and defined the exact same parameters as on our existing server. I just tried removing the additional line that our server has (MAXFETCHBUFF = 16384) and the test connection now passes on my PC, so there must be an issue with that parameter in the newer driver version.
Cheers, Chris On Tue, Aug 11, 2009 at 9:21 AM, Brutzman, Bill <bi...@hkmetalcraft.com>wrote: > > The UCI Editor on the PC is a necessary first step. > > In Windows it can be found in the \ IBM U2 \ UniVerse ODBC Driver \ > > --Bill > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Lee > Sent: Monday, August 10, 2009 6:22 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] UV ODBC Driver > > We have a UniVerse database running UV Version 10.1.17 on AIX. > I have the IBM UniVerse ODBC Driver version 4.00.03.7251 installed on my > PC, but can't seem to get it to successfully connect to the UniVerse > database... > we already have another server with a UniVerse ODBC driver installed and > connecting successfully, but it's a somewhat older ODBC driver version > (4.00.00.7045). > > Do you have to use a particular ODBC driver with UV 10.1.17 or is there > something else that needs to be configured ? > > When I put in the server details and click Test Connection on my PC I > get the following error message from the ODBC client:- > > [IBM][UVODBC][0301931]Error ID:46 Severity: ERROR Facility: DBCAPERR - > UCI Error. Func: SQLConnect(); State: IM997; uniVerse code: 0; Msg: > [IBM][SQL Client] An illegal configuration option was found. > > Thanks, > Chris > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
