Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't connect to Oracle using MSDAORA OLE DB provider

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

From: Jojo <jojohome_at_gmail.com>
Date: Tue, 18 Sep 2007 10:36:23 -0700
Message-ID: <1190136983.479979.115280@22g2000hsm.googlegroups.com>


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:
>
>
>
>
>
> > On Sep 8, 6:58 pm, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> > > Jojo wrote:
> > > > We use 10.2 client + xp. It works on one 3 years old Dell computer but
> > > > it does not work on a new Lenovo computer. Just do not know which
> > > > change causes this problem.
>
> > > Which version of XP? If anything other than XP Professional, then that
> > > might be the cause of your problem....
>
> > > HTH,
> > > Brian
>
> > > --
> > > ===================================================================
>
> > > Brian Peasland
> > > d...@nospam.peasland.nethttp://www.peasland.net
> > 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.- Hide quoted text -
>
> - Show quoted text -

Thanks. Is there known issue about the OraOLEDB driver? We are worried about the data transfer speed. Received on Tue Sep 18 2007 - 12:36:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US