New Guy Attemping to Setup ODBC connection to Informix 7.22SE on SCO5 from WinXP with IBM 2.81SDK

Posted in 2005

Topics: Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration

NeMacGuy — 8 Feb 2005 18:47:13 -0800 — source: Usenet: comp.databases.informix

I am receiving the following error. This is on a system that approx 1 year ago had 1 pc setup for ODBC access and it did work. Cannot create/access database on NFS mount Any ideas ? Whick protocol sould I be setting on the client ? THANKS FOR ANY HELP!!! Backgroud : Informix on SCO 5 server Informix 7.22SE server_odbc.log 2005-01-20 09:33:47.880000 Starting Daemon INFORMIX-SQL Version 7.22.UC3 Command Line = /usr/informix/lib/sqlexecd server_odbc -l /usr/informix/server_odbc.log INFORMIXDIR = /usr/informix dbservername = server_odbc nettype = setlitcp hostname = server servicename = 1610 options = 2005-02-05 10:13:25.260000 sqlexec pc1.work.local root -dfms SQL_HOSTS_FILE server_online seipcpip server sqlexec server_odbc setlitcp server 1610

↪ replying to NeMacGuy

scottishpoet — 9 Feb 2005 01:35:25 -0800 — source: Usenet: comp.databases.informix

Can I confirm you have SE binary installed on one machibne and you are now trying to create the database on a filesustem that is NFS mounted? seem to recall see doesn't work on an NFS mount. You would need to put SE on the machine that the disks reside on and connect via the network from your application on the current host machine - this is what your ODBC connection did. NeMacGuy wrote: > I am receiving the following error. This is on a system that approx 1 > year ago had 1 pc setup for ODBC access and it did work. > > Cannot create/access database on NFS mount > > Any ideas ? > Whick protocol sould I be setting on the client ? > > THANKS FOR ANY HELP!!! > > Backgroud : > Informix on SCO 5 server > Informix 7.22SE > > server_odbc.log > 2005-01-20 09:33:47.880000 Starting Daemon INFORMIX-SQL Version > 7.22.UC3 > Command Line = /usr/informix/lib/sqlexecd server_odbc -l > /usr/informix/server_odbc.log > INFORMIXDIR = /usr/informix > dbservername = server_odbc > nettype = setlitcp > hostname = server > servicename = 1610 > options = > 2005-02-05 10:13:25.260000 sqlexec pc1.work.local root -dfms > > SQL_HOSTS_FILE > server_online seipcpip server sqlexec > server_odbc setlitcp server 1610

↪ replying to scottishpoet

NeMacGuy — 9 Feb 2005 07:07:09 -0800 — source: Usenet: comp.databases.informix

Thank you for the reply. The Informix is installed on a SC0 5 server with one hard driver. About a year ago one machine was able to connect via odbc. Nothing has changed except we lost the PC that worked, so I hope we just need to get our settings right. I am note sure what protocol to use, etc... Thanks

↪ replying to NeMacGuy

scottishpoet — 9 Feb 2005 08:27:23 -0800 — source: Usenet: comp.databases.informix

where and when do you get the error about NFS? NeMacGuy wrote: > Thank you for the reply. > > The Informix is installed on a SC0 5 server with one hard driver. > About a year ago one machine was able to connect via odbc. Nothing has > changed except we lost the PC that worked, so I hope we just need to > get our settings right. I am note sure what protocol to use, etc... > > Thanks