connecting to informix database on unix from Microsoft Acess on windows

Posted in 2000

vb_patel@my-deja.com — Wed, 30 Aug 2000 17:50:46 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, We have informix database on Sun Spark server. I was wondering if there is a way to connect to that database from a client machine using Microsoft Access. Vijay Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to vb_patel@my-deja.com

msmith9661@my-deja.com — Wed, 30 Aug 2000 20:40:56 GMT — source: Informix-list mailing list archive (1991-1998)

Yes, you can link Informix tables to your Access database via ODBC. www.merant.com is one vendor that makes ODBC drivers, I think they offer a free evauluation version as well. In article <8ojhhc$sud$1@nnrp1.deja.com>, vb_patel@my-deja.com wrote: > Hi, > > We have informix database on Sun Spark server. I was wondering if > there is a way to connect to that database from a client machine using > Microsoft Access. > > Vijay > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to vb_patel@my-deja.com

James Ferrill — Thu, 31 Aug 2000 07:39:15 -0500 — source: Informix-list mailing list archive (1991-1998)

I don't think I would want to own a computer that had the word "spark" anywhere in it's name :-D vb_patel@my-deja.com wrote: > We have informix database on Sun Spark server. I was wondering if > there is a way to connect to that database from a client machine using > Microsoft Access.

↪ replying to vb_patel@my-deja.com

Ray Canuel — Thu, 31 Aug 2000 13:31:52 -0400 — source: Informix-list mailing list archive (1991-1998)

Informix I-Connect comes with ODBC drivers. I-connect is shipped with every engine product. Its also downloadable from intraware. Install it on your client. Make sure your client can ping the server. Configure Informix setnet32 test ilogin for connectivity run dbaccessdemo(7) on your dbserver first) Once this works, then create an odbc source and you should be good. Ray vb_patel@my-deja.com wrote: > > Hi, > > We have informix database on Sun Spark server. I was wondering if > there is a way to connect to that database from a client machine using > Microsoft Access. > > Vijay > > Sent via Deja.com http://www.deja.com/ > Before you buy.