New Guy Attemping to Setup ODBC connection to Informix 7.22SE on SCO5 from WinXP with IBM 2.81SDK
NeMacGuy asked how to set up an ODBC connection from WinXP (SDK 2.81) to Informix 7.22 SE on SCO 5 and which protocol to use, reporting an error about creating a database on an NFS mount. scottishpoet noted SE does not work on NFS mounts, so SE must run where the disks are, and asked where the error occurred. No resolution in the thread.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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
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
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