connect informix 6.0 on Solaris with win98 PC problem
Posted in 1999
Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Server Administration, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Platform-Specific Issues, Internationalization & Character Sets
Can Anybody help me?
I try to connect Informix Online 6.0 server on a Solaris host to a windows
98 PC. I want to use Borland C++ builder to create some client software. For
the communication with the Informix server I got thier free SDK from
www.intraware.com/informix. I first tried to connect with ODBC and then the
Native option from Borland BDE but both options won't work.
****************************************************************************
***********************
on the host:
hostname : doorn
In the services file : ontcp_prim 30001/tcp
In the sqlhosts file : tcp_prim ontlitcp doorn ontcp_prim
ONCONFIG : onconfig.doorn
In the onconfig.doorn file : DBSERVERALIASES tcp_prim
on the PC:
C:\\WINDOWS\\Services: ontcp_prim 30001/tcp # Informix Server
C:\\WINDOWS\\hosts: "valid_IP_address" doorn # Solaris
Informix Setnet32:
Enviroment:
INFORMIXDIR=C\\Informix
INFORMIXSERVER=tcp_prim
Server information:
Informix Server: tcp_prim
Hostname: doorn
Protocolname: olsoctcp
Service Name: ontcp_prim
Host Information:
Current Host: doorn
User Name: valid_user_name
Password Option: Password
PassWord: valid_password
ODBC (INTERSOLV 3.11 32-BIT INFORMIX)
Data Source Name: Informix_ODBC
Description: Informix database
Database Name: has (valid database)
****************************************************************************
***********************
When I try to open the database (ODBC) with Borland BDE:
BDE Error: 13058
Server Error: -7203
"[INTERSOLV][ODBC Informix driver][Informix]DBNLS is not set or LC_COLLATE
must be 'C'."
But when I set DBNLS to 0, 1 or 2 and/or set LC_COLLATE to C the error
excists
Wich value do I have to chode for DBNLS?
When I try the native BDE drivers:
BDE Error: 13059
Server Error: -23101
"Unable to load locale categories."
Or whith the ILogin:
Server: tcp_prim
Hostname: doorn
Servicename: ontcp_prim
Protocolname: olsoctcp
Username: valid_user_name
Password: valid_password
Stores Database: has
Database: Sqlcode = -7203 (the DBNLS is not set or LC_COLLATE must be 'C'
error)
****************************************************************************
***********************
Does somebody now the problem?
ODBC:
NATIVE:
Related threads
- RE: Help! 7.14 on HP 10.10 / 7203 ISAM 117
- Communicating between Databases and GLS
- Re: NLS problem 7.13 -> 7.23