[AccessD] Informix and Access

Don't know how pertinent this is but try
http://www.connectionstrings.com/?carrier=informix 

-----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