MS Access connection to Informix Online V7.3 - How?

dear fellow Informix users Can someone explain how to link MS Access to Informix Database Online sitting on a Unix server? Steve

You need ODBC (www.intraware.com - look for Informix SDK) and use the link to external option from Access Steve Farrand wrote: > > dear fellow Informix users > > Can someone explain how to link MS Access to Informix Database Online > sitting on a Unix server? > > Steve -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #

Workstation Install informix client setnet 32 ---- add all the server information eg informix server name , host name ,protocol, service name In services file add Service name port /tcp please replace the above by the service name and the port number In hosts file add entry host ip address Hostname please replace the above with the ip address of the server where informix is running and the host name of the server create a new file in the informix\\etc directory called sqlhosts with the following entry database protocol hostname servicename server How to find the variables on the server database server name can be found in informix onconfig file , protocol for 7.X should be onsoctcp hostname can be found in /etc/hosts file service name can be found in /etc/services after this is done try running I login Demo if it works create a user dsn/system dsn (dont remember which one ) in the odbc links of you workstation the same information will be asked then you can use access to link tables by using the machine data source Regds Stephen be aware the above three files should not be saved as notepad file "Steve Farrand" <s.farrand@videonetworks.com> wrote in message news:39c0b342@news1.homechoice.co.uk... > dear fellow Informix users > > Can someone explain how to link MS Access to Informix Database Online > sitting on a Unix server? > > Steve > > >