| Problem connecting Win2K (oracle 9i) client to 8.0.5 database [message #66599] |
Fri, 23 August 2002 18:38  |
Madhavi
Messages: 23
Registered: November 1999
|
Junior Member |
|
|
Hello,
Here is the situation am having problem with:
Am connecting to a 8.0.5 database via VB6.0 application installed on a Windows 2000 client/with 9i ODBC driver. The application also connects to a mainframe (DB2) via an APPC/DRDA gateway.
1.) The data from Oracle server is getting truncated, when a query is run from within the VB code.
2.) To access data from mainframe, a Stored Procedure
on the oracle server, makes a call to the APPC gateway. When this Stored Procedure is run at the SQL*Plus prompt it returns data, but when executed from within the VB application, the Stored procedure does not return any information.
Can anyone give some inputs to resolve this?
Thanks.
|
|
|
|
|
|
| Re: Problem connecting Win2K (oracle 9i) client to 8.0.5 database [message #66604 is a reply to message #66599] |
Tue, 27 August 2002 12:37  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
My guess is you can't do it with that big of a gap with ODBC versions. You might be able to if the DB was 9i and the client used 8 because 9i should be backward compatible from the DB perspective. I would say you need the client to match the server version in this case. I have used ODBC for years and this configuration would never work. The client had to be equal or lower than the server.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
