Installation guide

4. Accessing Popular Databases

Driver = /opt/oracle/instantclient_11_2/libsqora.so.11.1

ServerName = oracle11gr2

# DSN driver options

Application Attributes = T

Attributes = W

BatchAutocommitMode = IfAllSuccessful

BindAsFLOAT = F

CloseCursor = F

DisableDPM = F

DisableMTS = T

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

#SQLGetData extensions = F

SQLGetData extensions = T

Translation DLL =

Translation Option = 0

DisableRULEHint = T

#UserID =

StatementCache=F

CacheBufferSize=20

UseOCIDescribeAny=F

• Using these settings, you can then connect to Oracle using a simple

connection string such as:

"DSN=oracle11gr2;UID=username;PWD=password"

EasySoft ODBC Driver for Oracle

Homepage: http://www.easysoft.com/

OpenLink ODBC Driver for Oracle

Homepage: http://www.openlinksw.com/

DataDirect ODBC Driver for Oracle

Homepage: http://www.datadirect.com/

Actual Technologies Mac OS X ODBC Driver for Oracle

Homepage: http://www.actualtech.com/

When using the driver on Mac OS X 10.6 (Snow Leopard), be sure to use version

3.0.9 or higher, since earlier versions had a problem with fetching data.