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

When testing the odbc connection in ODBC setup. My one thought is that
the database name may be wrong ? But I do see the name I am using in
the ODBC connection log on the SCO box, and the user name I am using is
the same.

Any idea would be helpful.

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

I suspect that the most likely problem is that you have a database in
a directory, let's call it /some/where/my.dbs, and either /some or
/some/where is NFS mounted from another machine. SE won't play on NFS
mounted file systems (certainly not an SE as old as yours - more
recent versions might).

The next most likely problem is that SE has misidentified /some or
/some/where (or /some/where/my.dbs) as an NFS-mounted file system.
That happens if the inode number is unexectedly large. Relatively
unlikely, but not impossible.

> Any ideas ?
> Whick protocol sould I be setting on the client ?
>
> THANKS FOR ANY HELP!!!
>
> Backgroud :
> Informix on SCO 5 server
> Informix 7.22SE

Antique - pre-Y2K and not officially Y2K-compliant.
You'll probably be OK, but you were warned.

> 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
>


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/