[AccessD] Informix and Access

Hi John:

If you go to the DBA web site > Reference Lists > Miscellaneous there is a
link to a site that lists connection strings for various databases, on of
them being Informix:
http://www.databaseadvisors.com/reference/referenceMisc.asp

If an ODBC driver was used to connect to the database the username and
password is in the registry of the host/client computer that was connecting.
Not very secure but if you have access to the original computer check it
out. So go to your client's site and go to a computer that use to connect to
the INFORMIX DB. 

First: Start the ODBC Data Source Administrator (Start > Control Panel >
Administrative Tools > Data Sources (ODBC))
Second: Check the System DNS Sources tab and the name of CONNECTION should
be listed and the particular Driver. The Driver type will let you know you
are on the right track.
Third: With the name in hand, start RegEdit (Start > Run... regedit) and do
a full search (keys/values/Data) for the CONNECTION name. When you find the
Key a couple of the associated values should be the correct username and
password.

Then you can go back home and login.

HTH
Jim    
  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Tuesday, February 27, 2007 5:55 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Informix and Access

Anyone ever have any luck connecting to an Infomix database.

I'm trying to set up an ODBC for Access and can't quite figure out the
configuration. Here are the ODBC settings I'm trying.


Server Name: office-xp  (This is the computer name of my PC)
Host Name:  192.168.1.15  (This is the IP address of my PC)
Service:  1525 
Protocol:  olsoctcp
Options:
Database Name: c:\Test Infomix\InfomixDatabaseFolder\
UserID: ???
Pwd: ???

I was given a User name and password from someone who uses the database but
it didn't work. I'm thinking I need to put in "my" Pc's login info as I'm
the administrator?

The error I'm receiving when trying to 'test the connection' is:

"Test Connection was NOT successful.[Informix][Informix ODBC Driver]Attempt
to connect to database server (office-xp) failed."

Any idea?

Thanks,

John Skolits


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com