Home » RDBMS Server » Networking and Gateways » Problem connecting Win2K (oracle 9i) client to 8.0.5 database
Problem connecting Win2K (oracle 9i) client to 8.0.5 database [message #66599] Fri, 23 August 2002 18:38 Go to next message
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 #66602 is a reply to message #66599] Mon, 26 August 2002 10:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it may be a comatibility issue.
did you try 8.0.5 ODBC?
and
are u trying to retreive LOB's?
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 Go to previous message
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.
Previous Topic: ERROR 12560 TNS : Protocol adapter error ::::::Newbie
Next Topic: Re: Problem connecting Win2K (oracle 9i) client to 8.0.5 database
Goto Forum:
  


Current Time: Sat Feb 24 15:28:08 CST 2024