Hi, I've been successfully connecting to SQL Server via RODBC. I'd like to start using the package 'pool', and to do so I need to connect using DBI+odbc. I have not been able to have odbc::odbcListDrivers() list the driver that I have been using with RODBC (I get an empty list)
This is what I get by running odbcinst -j
at the command line
unixODBC 2.3.1
DRIVERS............: /export/home/ad.hector.herrada/odbcinst.ini
SYSTEM DATA SOURCES: /export/home/ad.hector.herrada/odbc.ini
FILE DATA SOURCES..: /export/home/ad.hector.herrada/ODBCDataSources
USER DATA SOURCES..: /export/home/ad.hector.herrada/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
I have environment variable ODBCSYSINI = '/export/home/ad.hector.herrada'
/export/home/ad.hector.herrada/odbcinst.ini includes:
[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0
UsageCount=1
Any ideas why I have not been able to set up the driver correctly?
Thanks!