Re: Informix Data To Access 97?
Posted in 2005
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Server Administration
Hi Bill! You need to download and install the Informix Client SDK for Windows on the client machine. Look for Informix CSDK in the downloads section of the IBM website. This includes the ODBC and OLEDB drivers for Informix. Arka no-spam@wmanning wrote: > Problem connecting via ODBC. Situation is as follows: > Running a Windows 95 Desktop, Pentium with 64 mb ram. Server is NT. > From Access 97, I am attempting to connect to an Informix 7 > database. Informix is acting as a repository for data processed > through Elite. When I attempt to connect from Access ("Get External > Data. . .Link Tables. . .Files of Type . . .ODBC Databases") I get a > listing of Dbase, Foxpro, etc. All of these databases have a file > with a "DSN" extension under C:\\Program Files\\Common Files\\Odbc\\Data > Sources. There is nothing there for Informix. When I go to the > C:\\Elitwin directory and run "OdbcAdm", I get a listing of the Dbase, > Foxpro, etc, in addition to EliteInformix and EliteMultilink. What do > I need to do to get Access to recognize the Informix database? Thanks > in advance. > Bill Manning