Hi and could anyone help me please with some ADO connection Probl

From: Reza Oskouie <reza.oskouie_at_digital-dispatch.co.uk>
Date: Wed, 15 Nov 2000 17:38:23 -0000
Message-Id: <10681.122135@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04F2A.DA3E7CA0
Content-Type: text/plain

Hi Guys
I am new to this list and quite enjoying to listen at the background and from time to time send a comment if I could be of any help. This is the busiest list I've ever come across with, pretty hard work to keep track.

Well my problem is: one of our customers is trying to connect from an in-house developed application which uses Microsoft ADO to connect to our Oracle 8.0.5. database. He's tried various connect strings. I've set up the security requirements (username/pass, grants..) on the Oracle and you can see that a successful session is created on oracle but no data can be exchanged between server and the client. I know that the problem is a bit vague and depends what exactly your program is doing, but if you have any experience with a reliable way of connecting to Oracle 8.0.5 using ADO, regarding a correct ADO connect string, I really appreciate your help. Two of the example connect string have been used are as follow.
'driver=Oracle73 Ver 2.5;uid=SYSTEM;ASY=OFF;DBQ=primary;pwd=manager'; -- primary is a net8 alias which connects to the server 'driver=Oracle ODBC DRIVER;uid=SYSTEM;ASY=OFF;DBQ=primary;pwd=manager'; -- primary is a net8 alias which connects to the server

As I've noticed from the odbc logs, there could be a driver incompatibility. I've attached the odbc log.
The error happens on a simple select statement such as select job_id from test:
the test table has one single column job_id as number(9) Thanks a lot for any help you can provide. regards
Reza

+++++++++++++++++++++++++++++++++
6a:50	ENTER SQLSetDescField 
		SQLHDESC            0x02ad23c8
		SQLSMALLINT                  1 
		SQLSMALLINT               1010 <SQL_DESC_DATA_PTR>
		SQLPOINTER          0x00000040
		SQLINTEGER                   0 

fin             6a:50	EXIT  SQLSetDescField  with return code -1
(SQL_ERROR)
		SQLHDESC            0x02ad23c8
		SQLSMALLINT                  1 
		SQLSMALLINT               1010 <SQL_DESC_DATA_PTR>
		SQLPOINTER          0x00000040
		SQLINTEGER                   0 

		DIAG [S1004] [Oracle][ODBC]SQL data type out of range <0>.

(0)

DIAG [HY021] [Oracle][ODBC]Inconsistent descriptor information. (0)

fin 6a:50 EXIT SQLSetDescFieldW with return code -1 (SQL_ERROR)

		SQLHDESC            0x02ad23c8
		SQLSMALLINT                  1 
		SQLSMALLINT               1010 <SQL_DESC_DATA_PTR>
		SQLPOINTER          0x00000040
		SQLINTEGER                   0 

		DIAG [S1004] [Oracle][ODBC]SQL data type out of range <0>.

(0)

DIAG [HY021] [Oracle][ODBC]Inconsistent descriptor information. (0)

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

------_=_NextPart_001_01C04F2A.DA3E7CA0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Hi and could anyone help me please with some ADO connection =
Problem</TITLE>
</HEAD>
<BODY>

Hi Guys
 I am new to this list and quite =
enjoying to listen at the background and from time to time send a = comment if I could be of any help. This is the busiest list I've ever = come across with, pretty hard work to keep track.

Well my problem is: one of our =
customers is trying to  connect from an in-house developed = application which uses Microsoft ADO to connect to our Oracle = 8.0.5.  database. He's tried various connect strings. I've set up = the security requirements (username/pass, grants..) on the Oracle and = you can see that a successful session is created on oracle but no data = can be exchanged between server and the client.

I know that the problem is a bit vague =
and depends what exactly your program is doing, but if you have any = experience with a reliable way of connecting to Oracle 8.0.5 using ADO, = regarding a correct ADO connect string, I really appreciate your help. = Two of the example connect string have been used are as = follow.

'driver=3DOracle73 Ver =
2.5;uid=3DSYSTEM;ASY=3DOFF;DBQ=3Dprimary;pwd=3Dmanager'; -- primary is = a net8 alias which connects to the server

'driver=3DOracle ODBC =
DRIVER;uid=3DSYSTEM;ASY=3DOFF;DBQ=3Dprimary;pwd=3Dmanager'; -- primary = is a net8 alias which connects to the server

As I've noticed from the odbc logs, =
there could be a driver incompatibility.
 I've attached the odbc log.
 The error happens on a simple select =
statement such as
 select job_id from test:
  the test table has one single =
column job_id as number(9)
 Thanks a lot for any help you can =
provide.
 regards
 Reza
 <FONT SIZE=3D2 =

FACE=3D"Arial">+++++++++++++++++++++++++++++++++</FONT>

 6a:50   ENTER =
SQLSetDescField 
         =
        SQLHDESC        &= nbsp;   0x02ad23c8
         =
        SQLSMALLINT       &nbs= p;          1 
         =
        SQLSMALLINT       &nbs= p;       1010 = <SQL_DESC_DATA_PTR>
         =
        SQLPOINTER       &nbsp= ;  0x00000040
         =
        SQLINTEGER       &nbsp= ;           0 


fin         =     6a:50   EXIT  SQLSetDescField  = with return code -1 (SQL_ERROR)
         =
        SQLHDESC        &= nbsp;   0x02ad23c8
         =
        SQLSMALLINT       &nbs= p;          1 
         =
        SQLSMALLINT       &nbs= p;       1010 = <SQL_DESC_DATA_PTR>
         =
        SQLPOINTER       &nbsp= ;  0x00000040
         =
        SQLINTEGER       &nbsp= ;           0 


        =
        DIAG [S1004] [Oracle][ODBC]SQL data type out of range = <0>. (0) 


        =
        DIAG [HY021] [Oracle][ODBC]Inconsistent descriptor = information. (0) 


fin         =     6a:50   EXIT  SQLSetDescFieldW  = with return code -1 (SQL_ERROR)
         =
        SQLHDESC        &= nbsp;   0x02ad23c8
         =
        SQLSMALLINT       &nbs= p;          1 
         =
        SQLSMALLINT       &nbs= p;       1010 = <SQL_DESC_DATA_PTR>
         =
        SQLPOINTER       &nbsp= ;  0x00000040
         =
        SQLINTEGER       &nbsp= ;           0 


        =
        DIAG [S1004] [Oracle][ODBC]SQL data type out of range = <0>. (0) 


        =
        DIAG [HY021] [Oracle][ODBC]Inconsistent descriptor = Received on Wed Nov 15 2000 - 11:38:23 CST