ODBC Error - Database not Found or no system permission. sqlerrm(systab
From
Gustavo Airasca@21:1/5 to
All on Thu Aug 19 09:22:41 2021
Hi everyone, I can't test connection with ODBC.
In the server (debian 5 lenny - Informix 7.24UC5), with informix user, I can connect with database without problem (dbaccess ; connection ; connect ; demo_se ; USER NAME: I don't introduce anything, just press ENTER ; I select the database "prueba", and
the connection is made)
But, when I try to connect with ODBC (Windows 10), it doesn't connect. A windows pop up and says "Test connection was NOT successfull.[Informix][Informix ODBC Driver][Informix] Database not found or no system permission. sqlerrm(systables).
Extra information:
Client Side
Windows 10
Informix user (I created one - desesperated action)
Connection tab:
Server Name: demo_se
Host Name: IP of the server
Service: 1526
Protocol: (tried with sesoctcp and onsoctcp)
Option: blank (also tried s=2)
Database Name: Prueba
User ID: blank
Password: blank
Server side
Debian 5 lenny
Informix 7.24.UC5
/home/informix/etc/sqlhost file: demo_ sesoctcp "IP of client" sqlexecd s=2 /etc/services add: sqlexecd 1526/tcp
/etc/hosts add: "IP of client" Dispenser (I give it a name)
/home/.rhosts add: Dispenser informix (I copied this file also in /home/informix/ and /home/informix/etc/)
After the failure in connection, the /var/log/sqlexecd said:
"date" "time" sqlexecd Dispenser informix -dprueba
Anyone have any clue??
thanks!
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)