King, Leon C wrote:
I have a server with the full Oracle 10 instance. I installed the UNIXODBC package from the http://www.unixodbc.org/ website to compile. What else do I need? Do I need to specify a file in the 'oracle/10.1.0/lib' directory. Unfortunately I can't find much documentation.
This is my /etc/odbc.ini
[ORACOLO] Application Attributes = T Attributes = W BatchAutocommitMode = IfAllSuccessful BindAsFLOAT = F CloseCursor = F DisableDPM = F DisableMTS = T Driver = ORACOLODRIVER DSN = ORACOLO EXECSchemaOpt = EXECSyntax = T Failover = T FailoverDelay = 10 FailoverRetryCount = 10 FetchBufferSize = 64000 ForceWCHAR = F Lobs = T Longs = T MetadataIdDefault = F QueryTimeout = T ResultSets = T ServerName = ORACOLODB01 SQLGetData extensions = F Translation DLL = Translation Option = 0 DisableRULEHint = T UserID =
And this is my /etc/odbcinst.ini
[ORACOLODRIVER] Description = Oracle ODBC driver for Oracle 10g Driver = /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1 Setup = FileUsage = CPTimeout = CPReuse = 0
Btw... I don't know what some of these attributes means... Surely "Driver =" in odbc.ini must be the same in odbcinst.ini And "ServerName = ORACOLODB01" must be the name defined in tnsnames.ora
Another useful thing is to add these lines to odbcinst.ini for debugging purposes
[ODBC] # Serve solo per avere un log Trace = Yes TraceFile = /tmp/ODBCsql.log ForceTrace = Yes Pooling = No
At last I can suggest to use isql command
isql -v ORACOLO dbuser dbpassword
Greetings, A