Hello,
I installed RStudio server according to this
on Ubuntu 24.04
When I try to run a simple script to test the configuration, I get this
> library(RODBC)
> # Set up the environment variables
> Sys.setenv(ODBCINI = "/opt/IBM/Informix.4.50.FC11W1/etc/odbc.ini")
> Sys.setenv(ODBCINSTINI = "/opt/IBM/Informix.4.50.FC11W1/etc/odbcinst.ini")
>
> # Open the connection
> conn <- odbcConnect("Infdrv1")
Warning messages:
1: In RODBC::odbcDriverConnect("DSN=Infdrv1") :
[RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver Manager]Can't open lib '/opt/IBM/Informix.4.50.FC11W1/lib/cli/iclit09b.so' : file not found
2: In RODBC::odbcDriverConnect("DSN=Infdrv1") : ODBC connection failed
>
> # Check the available tables
> sqlTables(conn)
Error in sqlTables(conn) : first argument is not an open RODBC channel
'''
***
It says: file not found
*Can't open lib '/opt/IBM/Informix.4.50.FC11W1/lib/cli/iclit09b.so' : file not found*
But the driver is installed
And the file exists
*deploy@r:~$ ll /opt/IBM/Informix.4.50.FC11W1/lib/cli/iclit09b.so*
*-rwxr-xr-x 3 root root 1991472 Oct 16 16:55 /opt/IBM/Informix.4.50.FC11W1/lib/cli/iclit09b.so**
***
Configurations files: odbcinst.ini and odbc.ini
/opt/IBM/Informix.4.50.FC11W1/etc/odbcinst.ini
*;---------------------------------------------------------------------------*
*; IBM Informix Informix ODBC Sample File*
*;*
*; File: odbcinst.ini*
*;*
*;---------------------------------------------------------------------------*
*[ODBC Drivers]*
*#IBM Informix Informix ODBC DRIVER=Installed*
*InformixODBC=Installed*
*#[IBM Informix Informix ODBC DRIVER]*
*[InformixODBC]*
*#Driver=/extra/informix/lib/cli/iclit09b.so*
*Driver=/opt/IBM/Informix.4.50.FC11W1/lib/cli/iclit09b.so*
*#Setup=/extra/informix/lib/cli/iclit09b.so*
*Setup=/opt/IBM/Informix.4.50.FC11W1/lib/cli/iclit09b.so*
*APILevel=1*
*ConnectFunctions=YYY*
*DriverODBCVer=03.51*
*FileUsage=0*
*SQLLevel=1*
*smProcessPerConnect=Y*
***
/opt/IBM/Informix.4.50.FC11W1/etc/odbc.ini
*;---------------------------------------------------------------------------*
*; IBM Informix Informix ODBC Sample File*
*;*
*; File: odbc.ini*
*;*
*;---------------------------------------------------------------------------*
*[ODBC Data Sources]*
*#Infdrv1=IBM Informix Informix ODBC DRIVER*
*Infdrv1=InformixODBC*
*;*
*; Define ODBC Database Driver's Below - Driver Configuration Section*
*;*
*[Infdrv1]*
*Driver= /opt/IBM/Informix.4.50.FC11W1/lib/cli/iclit09b.so*
*Description=IBM Informix Informix ODBC DRIVER*
*Database=prod*
*LogonID=user1*
*Server=10.11.12.13*
*pwd=dbpassword*
*Servername=ids_tcp*
*CursorBehavior=0*
*CLIENT_LOCALE= en_US.CP1252*
*DB_LOCALE= en_US.819*
*Protocol=onsoctcp*
*Service=9088*
*TRANSLATIONDLL=/opt/IBM/Informix.4.50.FC11W1/lib/esql/igo4a304.so*
Any idea ?
Thanks