1
response

Good evening!

I have a probem with configuring im_odbc module to connect to the Oracle database from unix.

So...

As I understood (maybe I'm wrong somewhere), this module don't work "from the box" and for correctrly working I need to set up oracle instant client wich provide me a driver, odbc.ini, odbcinst.ini files. Also I created tnsnames.ora file. odbc.ini, odbcinst.ini and tnsnames.ora configured correctly. I trying to test them with isql and it's work fine.

I tried to differently configured ConnectionString parameter in configuration file, but it's did not work for me.

/etc/odbcinst.ini:
------------------------------------------
[libsqora.so.12.1]
Description = Oracle ODBC driver for Oracle 12c
Driver = /usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1
Setup =
FileUsage =
CPTimeout =
CPReuse
------------------------------------------

/etc/odbc.ini:
------------------------------------------
[ODBC Data Sources]
OracleODBC = Oracle ODBC driver for Oracle 12c

[OracleODBC]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = libsqora.so.12.1
DSN = OracleODBC
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 = DB.ETALON
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID = XXXX
Password = XXXX
StatementCache=F
CacheBufferSize=20
UseOCIDescribeAny=F
SQLTranslateErrors=F
MaxTokenSize=8192
AggregateSQLType=FLOAT
------------------------------------------

tnsnames.ora
------------------------------------------
DB.ETALON =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db-etalon.example.com)(PORT = 1530))
)
(CONNECT_DATA =
(SERVICE_NAME = etalon)
)
)
------------------------------------------

I don’t understand how to correctly set ConnectionString. Maybe someone had odbc setup experience.

AskedMarch 4, 2020 - 7:13pm

Answer (1)

Hi,

Something like this should work: ConnectionString Driver={Oracle ODBC driver for Oracle 12c};Dbq=Db;Uid=User;Pwd=password;

MisaZ