Accessing databases on Linux and Windows

Hi all, I need to access from my linux machine a database on a Windows 2003 machine. Where can I find the information to do this? Can anybody help me in configuring this on my machines. Thanks! Danny

Not sure that Win2003 is still supported, but, in general, you need to install the IBM Informix iConnect or cSDK product on the windows box and run the setnet32 utility to configure the native Informix connection. The windows ODBC configuration tool will find the Informix drivers once iConnect or cSDK is installed if you need an ODBC connection defined. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Oct 6, 2009 at 4:46 AM, DANNY DE KOSTER <ddk@fidelity-soft.be>wrote: > Hi all, > > I need to access from my linux machine a database on a Windows 2003 > machine. > Where can I find the information to do this? Can anybody help me in > configuring this on my machines. > > Thanks! > Danny > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747beea0adef7047541c078

Art, thanks for your answer but I don't know if a made myself clear. One day a read about some config in $INFORMIXDIR/etc/sqlhosts so that programs made in 4GL can reach also the database on another system. In our case we are working on SuSe and we want to access a database running on Windows. Thanks. Danny

OK, same answer really, just different details. You still need the iConnect or cSDk on the Linux box it you don't have it installed already (though it sounds like you do), then for native connections (like the 4GL apps) you just have to make an entry for the Win2003 server. The details are in the Administrator's Guide and Administrator's Reference manuals, but it will look something like (assuming the windows server has been configured to listen for TCP/IP type connections): my_remote_server onsoctcp my_remote_hostname_or_ip_address service_name_or_port_number You can get the servername and port numbers from the win server's setnet32 utility. If that utility is using a service name that you do not know, you will find it in the services file under the windows directory in a sub-folder named something like C:\\\\WINDOWS\\\\system32\\\\drivers\\\\etc If the service name is not known to the Linux host, you can either add it to the /etc/services file or just use the port number in the sqlhosts file. You may have a problem if the Windows server was configured to only present local connections. Then you will have to add a TCP/IP connection to that server first. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Oct 6, 2009 at 6:39 AM, DANNY DE KOSTER <ddk@fidelity-soft.be>wrote: > Art, thanks for your answer but I don't know if a made myself clear. > > One day a read about some config in $INFORMIXDIR/etc/sqlhosts so that > programs > made in 4GL can reach also the database on another system. In our case we > are > working on SuSe and we want to access a database running on Windows. > > Thanks. > Danny > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747360ad9ed09047542063e