RE: Hi and could anyone help me please with some ADO

From: Reza Oskouie <reza.oskouie_at_digital-dispatch.co.uk>
Date: Wed, 15 Nov 2000 19:22:56 -0000
Message-Id: <10681.122156@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_01C04F39.755E6F30
Content-Type: text/plain;

charset="iso-8859-1"

Hi Regina
First of all Thanks a lot for your kind and rapid respond. If you don't mind and have couple of minutes could you tell me please that what the "dsn" in your connect string refers to? Since as I explained the "primary" is the alias for the net8 service name I have created. Does the "dsn" in your connect parameters refer to ODBC "dsn" or is it simply the Oracle Net8 alias or service name? If it is the ODBC "dsn" then which ODBC driver do you use in the configuration of this "dsn" through Windows "ODBC Administrator" in control panel.
Once again thanks a lot and sorry for this extra disturbance. Best Regards
Reza

> -----Original Message-----
> From: Regina Harter [SMTP:rharter_at_emc-inc.com]
> Sent: 15 November 2000 18:32
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Hi and could anyone help me please with some ADO
>
> We have had a lot of success using just
> dsn=primary;uid=whatever;pwd=whatever;
>
> At 09:36 AM 11/15/00 -0800, you wrote:
>
> >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)
> >+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Regina Harter
> INET: rharter_at_emc-inc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C04F39.755E6F30
Content-Type: text/html;

charset="iso-8859-1"
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>RE: Hi and could anyone help me please with some ADO</TITLE>
</HEAD>
<BODY>

Hi Regina First of all Thanks = a lot for your kind and rapid respond. If you don't mind = and have couple of minutes could you tell me please that what the = "dsn" in your connect string refers to? Since as I explained =

the &quot;primary&quot; is the alias for the net8 service name I have =
created. Does the &quot;dsn&quot; in your connect parameters refer to =
ODBC &quot;dsn&quot; or is it simply the Oracle Net8 alias or service =
name? If it is the ODBC &quot;dsn&quot; then which ODBC driver do you =

use in the configuration of this "dsn" through Windows = "ODBC Administrator" in control panel.

Once again thanks a = lot and sorry for this extra disturbance.

<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Best Regards</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Reza</FONT>
</P>
<BR>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Regina Harter [SMTP:rharter_at_emc-inc.com] Sent:   15 November 2000 18:32 To:     Multiple recipients of list ORACLE-L Subject:       = Re: Hi and could anyone help me = please with some ADO

We have had a lot of success using = just
 dsn=3Dprimary;uid=3Dwhatever;pwd=3Dwhatever;

At 09:36 AM 11/15/00 -0800, you = wrote:

>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

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;'driver=3DOracle ODBC =
DRIVER;uid=3DSYSTEM;ASY=3DOFF;DBQ=3Dprimary;pwd=3Dmanager'; -- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;primary is a net8 alias which =

connects to the server
 > >As I've noticed from the odbc = logs, there could be a driver incompatibility.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;I've attached the odbc =
log.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;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.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;regards</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Reza</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&gt;+++++++++++++++++++++++++++++++++</FONT>

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

SQLINTEGER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>

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

SQLINTEGER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>

>        &nbsp= ;        DIAG [S1004] = [Oracle][ODBC]SQL data type out of range

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &lt;0&gt;. (0)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">>        &nbsp= ;        DIAG [HY021] = [Oracle][ODBC]Inconsistent descriptor

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; information. (0)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">>fin        &n= bsp;    6a:50   EXIT  = SQLSetDescFieldW  with return code -1 >(SQL_ERROR) >        &nbsp= ;        = SQLHDESC          &nbs= p; 0x02ad23c8
 >        &nbsp= ;        = SQLSMALLINT          &= nbsp;       1 >        &nbsp= ;        = SQLSMALLINT          &= nbsp;    1010 <SQL_DESC_DATA_PTR> >        &nbsp= ;        = SQLPOINTER          = 0x00000040
 >        &nbsp= ;        =

SQLINTEGER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>

>        &nbsp= ;        DIAG [S1004] = [Oracle][ODBC]SQL data type out of range

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &lt;0&gt;. (0)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">>        &nbsp= ;        DIAG [HY021] = [Oracle][ODBC]Inconsistent descriptor > information. (0) <FONT SIZE=3D2 =

FACE=3D"Arial">&gt;+++++++++++++++++++++++++++++++++++++++++++++++++++++=
++++++++++++++++++</FONT>

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L FAQ: =
<A HREF=3D"http://www.orafaq.com" =

TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Regina Harter</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

rharter_at_emc-inc.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in
 the message BODY, include a line = Received on Wed Nov 15 2000 - 13:22:56 CST