Re: ODBC 2.9 TC5 DSN questions
Gary,
Refer to http://www.synametrics.com/SynametricsWebApp/Tutorials.jsp.
This page has a video tutorial showing how to connect to Informix via
ODBC. Although the tool used is not MS Access, you will get an idea of
how to use it.
Jason.
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>
Jason Brown wrote: Thanks for the link Jason but after reading my initial post I did not mak myself clear enough. We having working ODBC connectivity with MS Access and Informix. It is when we try and use FILE DSN that we get that error code. I was reading a different thread where it was mentioned that a FILE DSN can have the connection string modifed to allow for dirty reads but the current Informix ODBC drivers do not work with it. A patch is required. Here was the thread: http://groups.google.com/group/comp.databases.informix/browse_thread/thread/d6748ec0dcd3e3c5/26a19afc71314975?q=odbc&rnum=6#26a19afc71314975