Oninit cdi / Archive
Talk to an expert →

Re: ODBC 2.9 TC5 DSN questions

Posted in 2006

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Transactions, Locking & Isolation, Networking & sqlhosts Configuration, Internationalization & Character Sets

Reece — — source: Usenet: comp.databases.informix

Gary Quiring wrote: > I am trying to setup a DSN for MS Access using ODBC 2.9-TC5 on a IDS > 9.4 engine. I have never used a DSN before. After setting up the DSN > all I get are -7778 errors. I can connect to the DB if I do not use a > DSN. > > My main interest in using a DSN was from reading that you can allow for > dirty reads in MS Access. If anyone knows what options you need to > stuff in there please share!!! > > Thanks > Gary Quiring > > DSN Contents: > [ODBC] > DRIVER={IBM INFORMIX ODBC DRIVER} > UID=gary > PWD=xyz > DATABASE=cdi > HOST=db1 > SERVER=db1_net > SERVICE=1526 > PROTOCOL=onsoctcp > CLIENT_LOCALE=en_US.CP1252 > DB_LOCALE=en_US.CP1252 Hmm... I don't know about the -7778 error. Can you provide the full error message? I need more clues to help out on this one... As for why you're setting up a DSN, I believe you're referring to Informix bug 176910 which requested that a means be established to set isolation level for an ODBC connection other than programmatically... This bug was not included in the 2.90.TC5 release. If you need this functionality, please contact IBM Tech Support and request a patch for bug 176910. The CSDK 2.90.TC5 release is CSDK 2.90.TC4 but built with GLS 4.00.TC8 instead of GLS 4.00.TC6. This CSDK release was needed for the iDS 10.00.TC5 release, in which there is a known problem that archecker fails to execute due to GLS initialization if anything other than CSDK 2.90.TC5 (or more specifically, a CSDK built with GLS 4.00.TC8) is installed.

↪ replying to Reece
Gary Quiring — — source: Usenet: comp.databases.informix

The exact error is "Reserved error -7778. There is no message for this error" That narrows it down!!!<grin>. I had assumed the TC5 release would fix the bug, I am amazed how long it takes IBM for fix things.... Thanks Gary Quiring

↪ replying to Gary Quiring
david@smooth1.co.uk — — source: Usenet: comp.databases.informix

Gary Quiring wrote: > The exact error is "Reserved error -7778. There is no message for this > error" That narrows it down!!!<grin>. > > I had assumed the TC5 release would fix the bug, I am amazed how long > it takes IBM for fix things.... > Well you only posted the problem on here less than an hour ago... What do you expect? Miracles? > Thanks > Gary Quiring

Related threads

Glossary