Re: Connect Oracle 7.3 using ODBC, rdo and ActiveX

I'm not sure if the RDO control will allow a dsn-less connection, but that should be easy enough for you to try out. I developed a VB application and used the new ActiveX Data Object (ADO) against an Oracle 7.3 database using a dsn-less connection and can tell you that it works just fine. The only benefit of the dsn-less connection in my experience was that the user data source name did not have to be defined in the ODBC manager. The dsn-less connection for Oracle still needs the following on the client machine: -Oracle sql*net
-ODBC driver

The Oracle sql*net must be configured on the client's machine. But, the ODBC stuff does not. That's done in code be the developer (that's you).

As far as the ODBC driver goes, most people I've worked with have greated success with the "Microsoft ODBC for Oracle" driver than the "Oralcle ODBC Driver." The MS Oracle driver can be found as part of the ADO download at www.microsoft.com/data/ado

I hope this helps.

Florent Buiret wrote in message <01bd3237$c7c46950$8a8084c0_at_Server_FB>...
>Dear all,
>
>I am facing the following problem:
>
>I am sharing an Oracle 7.3 database between several Intranet users.
>To access the database, I would like to use rdo through an ActiveX control.
>Questions:
>1 - can I have a dsn-less connection to the server via the web ?
>2 - if I must have a dsn, is it possible to have it without having the
>client side of Oracle
> installed on the client workstation ?
>3 - Which files should I take in the downloaded CAB (odbc drivers, sql*net
>files, etc.)
> to build a properly working solution ?
>
> Thank you in advance
> Florent Buiret
Received on Sun Feb 08 1998 - 00:00:00 CST