Message-Id: <10681.122193@fatcity.com> From: Regina Harter Date: Wed, 15 Nov 2000 14:01:15 -0800 Subject: Re: Hi and could anyone help me please with some ADO --=====================_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@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 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 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.
Best Regards
Reza=20 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