ODBC 2.9 TC5 DSN questions
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