I did find and solve the issue!!!
I needed to add INFORMIXDIR as a system environment variable!:
- Close all setnet32 and Connect Test Demo.
- Look for "edit the system environment variables". You'll need to be an admin or have an admin acct and password to do so. This will bring up the system properties window.
- Click on the "Environment Variables"
- Under the System Variables pane, look for INFORMIXDIR. if present make sure it points to the correct location for your CSDK installation (E.G. C:\Program Files (x86)\Informix Client-SDK). If not present, click on new (again, under the system variables pane) and enter "INFORMIXDIR" for the variable name and the correct path to your installation of your CSDK (again E.G.C:\Program Files (x86)\Informix Client-SDK).
- Click OK where pertinent.
- Open the Connect Test Demo and enter the appropriate entries. choose a table with a small amount of rows for the test.
- Voila!
I'm not sure if adding the INFORMIXDIR environment variable as a user variable would have done the trick. I'd probably try later.
Thank you so much
@Sheshnarayan Agrawal. Your suggestion to look on the environment helped me expand my troubleshooting.
Cheers!
Ramon
------------------------------
Ramon Rey
------------------------------
Original Message:
Sent: Tue November 03, 2020 03:25 PM
From: Ramon Rey
Subject: ODBC error 23101
Greetings and salutations!
I'm trying to setup an ODBC connection from my Windows 10 client to a Linux Informix DB Server. Having setup the appropriate server and host information in the Setnet32 app I'm getting an "Unspecified System Error = -23101" when trying to get the database list from the server (please see attached screenshot). I have changed the DB_LOCALE as per "SELECT site FROM systables WHERE tabid IN ( 90, 91 );" (en_US.819) and the CLIENT_LOCALE as per Window's "Get-WinSystemLocale" on PowerShell (en-US.1033) and nothing.
Please help!!!
Thanks in advance.
Ramon
PS my versions:
Windows 10
Informix CSDK 4.10.TC10 (32-bit)
Informix Server 12.10.FC10WE on Linux.
------------------------------
Ramon Rey
------------------------------
#Informix