Anyone using Oracle's ODBC Driver?

[dougcl]

Hi folks, I am currently using the DataDirect Oracle ODBC driver to import table definitions via the ODBC option in Connector Import Wizard.

For grins, I just tried making a DSN using the Oracle driver (in our case it's called libsqora.so.11.1), but the wizard cannot load it (either my fault in the .odbc.ini file, or this simply can't work).

Has anyone looked at using the Oracle supplied driver for table def import? If so and you have it working, I would like to see the DSN entry in your .odbc.ini file.

If anyone has tried this and failed and or you simply think this is a stupid idea, I am interested in this as well.

Thanks,
Doug

[bcarlson]

We have several different Oracle sources here and are using DataDirect Oracle Wire Protocol:

Code: Select all

[OUR_ORA_SERVER]
Driver=/opt/IBM/dev/InformationServer/Server/branded_odbc/lib/VMora23.so
Description=DataDirect Oracle Wire Protocol
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=servername.ourcompany.com
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=0
SID=rteccs1d
UseCurrentSchema=1

Brad.

[bcarlson]

I found another entry the designated an alternate server, right after the hostname entry:

Code: Select all

AlternateServers=(HostName= servername2.ourcompany.com:PortNumber=1523:SID=OUR_ORA_SERVER)

Hope this helps.

Brad.

[dougcl]

Hi Brad, thanks for the response. I too have this one working. I am wondering if you have tried the Oracle supplied ODBC driver instead.

Thanks,
Doug

[bcarlson]

Sorry, I don't think we do.

Brad.