Sample Header Ad - 728x90

unixODBC - [IM002][unixODBC][Driver Manager] Data source name not found and no default driver specified

1 vote
1 answer
18258 views
Folks, We installed unixODBC-2.3.7 on Aix 7.1 to connect to Oracle 11g. After setup odbc.ini and odbcinst.ini files and tried to connect with isql, we had the following error: # isql -v ORACLE [IM002][unixODBC][Driver Manager]Data source name not found and no default driver specified [ISQL]ERROR: Could not SQLConnect Before execute the isql command, we ran the following export commands: export ODBCSYSINI=/usr/local/etc export PATH=$PATH:/usr/local/bin export TNS_ADMIN=/u01/app/oracle/product/11.2.0.4/client_1/network/admin export ODBCINI=/usr/local/etc/odbc.ini export LIBPATH=/u01/app/oracle/product/11.2.0.4/client_1/lib:/usr/local/lib:/u01/app/oracle/product/11.2.0.4/client_1 export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.4/client_1/lib:/usr/local/lib:/u01/app/oracle/product/11.2.0.4/client_1 And odbcinst -j command too: unixODBC 2.3.7 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /usr/local/etc/odbc.ini SQLULEN Size.......: 4 SQLLEN Size........: 4 SQLSETPOSIROW Size.: 2 Illegal instruction(coredump) Our /usr/local/etc/odbc.ini file is: [ODBC Data Sources] ORACLE = Oracle ODBC Test [ORACLE] Application Attributes = T Attributes = W BatchAutocommitMode = IfAllSuccessful BindAsFLOAT = F CloseCursor = F DisableDPM = F DisableMTS = T Driver = Oracle11gdriver DSN = ORACLE EXECSchemaOpt = EXECSyntax = T Failover = T FailoverDelay = 10 FailoverRetryCount = 10 FetchBufferSize = 64000 ForceWCHAR = F Lobs = T Longs = T MaxLargeData = 0 MetadataIdDefault = F QueryTimeout = T ResultSets = T ServerName = ORAODBC.customer.com SQLGetData extensions = F Translation DLL = Translation Option = 0 DisableRULEHint = T UserID = user Password = pass StatementCache=F CacheBufferSize=20 UseOCIDescribeAny=F And our /usr/local/etc/odbcinst.ini is [Oracle11gdriver] Description = Oracle ODBC driver for Oracle 11g Driver = /u01/app/oracle/product/11.2.0.4/client_1/lib/libsqora.so Finally, our tnsnames.ora is: ORAODBC = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = customer.com.br)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORAODBC.customer.com) ) ) Any idea what is going on?
Asked by Nati
Sep 17, 2018, 09:55 PM
Last activity: Feb 22, 2025, 02:01 AM