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

From: Regina Harter <rharter_at_emc-inc.com>
Date: Wed, 15 Nov 2000 14:01:15 -0800
Message-Id: <10681.122193@fatcity.com>

--=====================_190203172==_.ALT

Content-Type: text/plain; charset="us-ascii"; format=flowed

Hi Reza,

I tried to send this offline but my mail server objected to your domain name, so...

dsn is the net8 alias name, which is why I used "primary" in there. I don't believe we have ever tried it with ODBC.

HTH,
Regina

At 07:26 PM 11/15/00 +0000, you wrote:

>My appology, I sent this message to the List rather than only you
>
>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
>Reza Oskouie
>Application Development Engineer
>Oracle Certified DBA
>DDS Intl Ltd.
>Bar Hill Business Park
>Saxon Way
>Bar Hill, Cambs, CB3 8SL
>01954-780888 Ext. 273
>0385-341095

--=====================_190203172==_.ALT

Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

<html>
Hi Reza, 
 
I tried to send this offline but my mail server objected to your domain name, so... 
 
dsn is the net8 alias name, which is why I used "primary" in there.  I don't believe we have ever tried it with ODBC. 
HTH, 
Regina 
 
At 07:26 PM 11/15/00 +0000, you wrote: 
<blockquote type=3Dcite cite>My appology, I sent this message to the List rather than only you

<br>
<font size=3D2 color=3D"#0000FF">Hi Regina</font> <br>
<font size=3D2 color=3D"#0000FF">First of all Thanks a lot for your kind and

rapid respond. 
If you don't mind and have couple of minute= s
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.

<font size=3D2 color=3D"#0000FF">Best Regards</font> <br>
<font size=3D2 color=3D"#0000FF">Reza</font>=20
<ul><font size=3D1>

-----Original Message----- From:  Regina Harter [SMTP:rharter_at_emc-inc.com] Sent:

</b>15 November 2000 18:32</font> <font size=3D1><b>To:&nbsp;&nbsp;&nbsp;
</b>Multiple recipients of list ORACLE-L</font>
<font size=3D1><b>Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </b>Re: Hi

and could anyone help me please with some ADO 

We have had a lot of success using just

<font size=3D2>dsn=3Dprimary;uid=3Dwhatever;pwd=3Dwhatever;</font> <br>
<br>
<font size=3D2>

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 > >'driver=3DOracle ODBC DRIVER;uid=3DSYSTEM;ASY=3DOFF;DBQ=3Dprimary;pwd=3Dmanager'; -- >primary= is a
net8 alias which connects to the server=20

</ul><font face=3D"Tahoma" size=3D2>Reza Oskouie</font> <br>
<font face=3D"Tahoma" size=3D2>Application Development Engineer</font> <br>
<font face=3D"Tahoma" size=3D2>Oracle Certified DBA</font> <br>
<font face=3D"Tahoma" size=3D2>DDS Intl&nbsp; Ltd.</font> <br>
<font face=3D"Tahoma" size=3D2>Bar Hill Business Park</font> <br>
<font face=3D"Tahoma" size=3D2>Saxon Way</font> <br>
<font face=3D"Tahoma" size=3D2>Bar Hill, Cambs, CB3 8SL</font> <br>
<font face=3D"Tahoma" size=3D2>01954-780888 Ext. 273</font> <br>

Received on Wed Nov 15 2000 - 16:01:15 CST