ODBC Connection Issue
Posted: Fri Oct 19, 2007 2:58 am
Hi,
I wanted to connect to a new DB Server, so i added the entries in UVDOBC.config and .odbc.ini files and got the following error.
ODBC_2: DSD.BCIConnect connecting to ictp, call to SQLConnect failed.
SQLSTATE=08004, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Oracle7 Server is not supported.|
DB Info :- Oracle 10g
The following entries are added to the config file.
.odbc.config file
[Schema Name]
QEWSD=37957
Driver=/datastage/Ascential/DataStage/branded_odbc/lib/VMora19.sl
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=Name of the Oracle Host Server
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=Login Id
Password=Password
PortNumber=Port Number
ProcedureRetResults=0
SID=SID Name
UseCurrentSchema=1
uvodbc.config file
<Schema Name>
DBMSTYPE = ODBC
Please let me know if i need to change any of this details.
I wanted to connect to a new DB Server, so i added the entries in UVDOBC.config and .odbc.ini files and got the following error.
ODBC_2: DSD.BCIConnect connecting to ictp, call to SQLConnect failed.
SQLSTATE=08004, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Oracle7 Server is not supported.|
DB Info :- Oracle 10g
The following entries are added to the config file.
.odbc.config file
[Schema Name]
QEWSD=37957
Driver=/datastage/Ascential/DataStage/branded_odbc/lib/VMora19.sl
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=Name of the Oracle Host Server
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=Login Id
Password=Password
PortNumber=Port Number
ProcedureRetResults=0
SID=SID Name
UseCurrentSchema=1
uvodbc.config file
<Schema Name>
DBMSTYPE = ODBC
Please let me know if i need to change any of this details.