DSXchange

Posted: **Mon Nov 01, 2010 4:38 pm**

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

Posted: **Wed Nov 03, 2010 12:59 pm**

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.

Posted: **Wed Nov 03, 2010 1:01 pm**

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.

Posted: **Wed Nov 03, 2010 2:58 pm**

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

Posted: **Wed Nov 03, 2010 3:08 pm**

Sorry, I don't think we do.

Brad.

DSXchange

Anyone using Oracle's ODBC Driver?

Anyone using Oracle's ODBC Driver?