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
Anyone using Oracle's ODBC Driver?
Moderators: chulett, rschirm, roy
We have several different Oracle sources here and are using DataDirect Oracle Wire Protocol:
Brad.
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
It is not that I am addicted to coffee, it's just that I need it to survive.
I found another entry the designated an alternate server, right after the hostname entry:
Hope this helps.
Brad.
Code: Select all
AlternateServers=(HostName= servername2.ourcompany.com:PortNumber=1523:SID=OUR_ORA_SERVER)
Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.