ODBC Connection with Service Name.

[rkashyap]

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

[asorrell]

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.

[rkashyap]

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

[EII]

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.