ODBC Connection Issue

oacvb · Post by **oacvb** » 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.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 19, 2007 8:56 am

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.

oacvb · Post by **oacvb** » Sun Oct 21, 2007 6:34 pm

Thanks for your input. Sad part is i am not using Oracle 7, It's Oracle 10. I could able to connect the new oracle db server & Oracle DB from Unix Server(Where DS is installed). I could able to do write select,insert commands from Unix Server.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 21, 2007 7:49 pm

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.

nage_j · Post by **nage_j** » Thu Oct 14, 2010 7:25 pm

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 ...

Hi,

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