DSXchange

Posted: **Wed Feb 19, 2014 10:18 am**

We are setting up ODBC connection to Oracle RAC Database.
The ODBC connection works when SID is used (set to 2nd node of the cluster/db) instead of Service name. We have been told by DBA that this approach will prevent RAC cluster based fail over.

Is there a way to use "Service Name" (instead of SID) in ODBC connection parameters?

.odbc.ini enteries are given below:

[SHTEST_ODBC]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora00.so
Description=DataDirect Oracle Wire Protocol driver
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=MMSRACDV1
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=0
SID=SHTEST2
UseCurrentSchema=1

Posted: **Wed Feb 19, 2014 11:43 am**

Yes, just remove SID and replace with ServiceName=name.

There are actually dozens of options that aren't put in the default odbc file.

Documentation on the server is in IBM/InformationServer/Server/branded_odbc/docs/

Same documentation is on the client in IBM\InformationServer\ODBCDrivers\

Documentation are in Adobe Acrobat files :

odbcdiag.pdf
odbcref.pdf
odbcuser.pdf
progsupp.pdf

The User Guide (odbcuser.pdf) contains the list of relevant options for each driver.

Posted: **Wed Feb 19, 2014 12:03 pm**

Andy, Thanks. :D It works. I am marking this topic as resolved.

Posted: **Fri Nov 14, 2014 10:24 am**

Just wanted to say thank you. I was having the same problem with VMora00.so on Information Server 11.3.1 and once I replaced SID with ServiceName in my .odbc.ini entry it worked perfectly.

DSXchange

ODBC Connection with Service Name.

ODBC Connection with Service Name.