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.
ODBC Connection Issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Nothing changes or needs to be. The ODBC driver you are using does not include support for version 7 of Oracle. End of story. You need to find an ODBC driver that does, if you want to connect to Oracle version 7.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Well it looks like the driver has (falsely or otherwise) detected Oracle 7. This is a mystery and may be a bug - I can't see anything in your configuration that would cause that. Time to involve your support provider.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire P
Hi,ray.wurlod wrote:Well it looks like the driver has (falsely or otherwise) detected Oracle 7. This is a mystery and may be a bug - I can't see anything in your configuration that would cause that. Time to involve you ...
I'm getting the below erro message when I tried to run the jobs in datastage connecting to upgraded 10g source database.
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Oracle7 Server is not supported.|
Can you please help me, with regards to this.
Regards,
-N