Unable to Connect to Oracle through ODBC...

[MOHAMMAD.ISSAQ]

I tried to connect to the Oracle Database through ODBC stage but it's throwing as error as
"SQLSTATE=78,CODE = 0,[Datastage][SQL Client][ODBC] 523 76"

I configured the uvodbc.config file also, but still the same error.

Please provide pointers to this...


Thanks in advance...

[ray.wurlod]

Please post the pertinent entries from .odbc.ini file and uvodbc.config file, as well as the complete and exact error message. Also include in your post how this error occurred - was it during View Data, a job run, or somewhere else.

Equipped with these facts we will be more likely to be able to provide cogent diagnosis.

[MOHAMMAD.ISSAQ]

First of all thanks for the reply...

The contents of odbc.in file are :-

"[ODBC Data Sources]
DB2 Wire Protocol=DataDirect 4.2 DB2 Wire Protocol Driver
dBase=DataDirect 4.2 dBaseFile(*.dbf)
Informix=DataDirect 4.2 Informix
Informix Wire Protocol=DataDirect 4.2 Informix Wire Protocol
Oracle=DataDirect 4.2 Oracle
Oracle Wire Protocol=DataDirect 4.2 Oracle Wire Protocol
SQLServer Wire Protocol=DataDirect 4.2 SQL Server Wire Protocol
Sybase Wire Protocol=DataDirect 4.2 Sybase Wire Protocol
Text=DataDirect 4.2 TextFile(*.*)"

The contents of odbc.config file are :-
"<aiujapan>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = HOST IP"

The HOST IP is the IP of the server.
Yes you are correct Ray, the error is occurring while viewing the data.
The exact error is
"DSR.MetaGeta(GET.DSNINFO)(SQLConnect('aiujapan','jodsdev')): BCI Error:
SQLSTATE=78,CODE=0,[DataStage][SQL Client][ODBC]523 76"

I didn't made any changes in the "odbc.in" file.
I'm not sure whether to make or not..

Please help me out...

[lstsaur]

The content of your .odbc.ini file should have something like the following:

[aiujapan]
Driver=/shopt/IBM/InformationServer/Server/branded_odbc/lib/VMora22.so
Description=DataDirect Oracle Wire Protocol driver
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=yourHost
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=0
SID=ora10g
UseCurrentSchema=1

Also, did you populate this DSN in your uvodbc.config? Did you install the Oracle client?