Re: Can't connect to Oracle using MSDAORA OLE DB provider

On Sep 18, 1:36 pm, Jojo <jojoh..._at_gmail.com> wrote:
> On Sep 18, 10:53 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> > On Sep 18, 10:07 am, Jojo <jojoh..._at_gmail.com> wrote:
> > > It is XP Professional Ver. 2002 Service Pack 2.
> > > This problem is still unsolved. We are frustrated here. Any new ideas?
>
> > You will want to make certain that you have the latest version of
> > MDAC:
> > http://msdn2.microsoft.com/en-us/data/aa937730.aspx
>
> > Note that Microsoft stopped distributing a wide variety of drivers in
> > the more recent MDAC releases, so I usually install MDAC 1.5 on new
> > client computers in addition to MDAC 2.8. You might want to switch to
> > using the OraOLEDB provider, rather than the Microsoft supplied
> > driver. The ConnectionString changes from:
> > "Provider=MSDAORA.1;User ID=MyUsername;Password=MyPassword;Data
> > Source=MySID"
> > -to-
> > "Provider=OraOLEDB.Oracle;User ID=MyUsername;Password=MyPassword;Data
> > Source=MySID"
>
> > Also, you will need to perform a Custom install of the Oracle 10.2
> > client so that the necessary driver files are copied to the client
> > computer.
>
> > Charles Hooper
> > IT Manager/Oracle DBA
> > K&M Machine-Fabricating, Inc.
>
> Thanks. Is there known issue about the OraOLEDB driver? We are worried
> about the data transfer speed.

I do not have performance statistics to compare the two drivers. I still use MSDAORA is ASP pages, but for compiled programs use either OraOLEDB or the Oracle ODBC client.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Tue Sep 18 2007 - 20:08:49 CDT