Miscellany

interno:~# isql -v XE
[S1000][unixODBC][Oracle][ODBC][Ora]ORA-12162: TNS:net service name is incorrectly specified
[ISQL]ERROR: Could not SQLConnect


interno:~# export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/


interno:~# isql -v XE
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect
interno:~# find /usr/lib/oracle -name tnsnames.ora
/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/network/admin/tnsnames.ora


interno:~# cat /etc/odbc.ini
[XE]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle
DSN = XE
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName =
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID =


interno:~# cat /etc/odbcinst.ini
[Oracle]
Description             = Oracle
Driver          = /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libsqora.so
Setup           =
FileUsage               =
CPTimeout               =
CPReuse         =
UsageCount              = 2