RE: MDAC 2.8 win 2003 x64 Ole Db Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Word from Microsoft is that they will NOT be releasing an x^$ version of
MSDAORA and are planning to even drop the 32 bit version as well.

Andy

"Andy" wrote:

> Steve,
>
> I checked the Oracle web site as well, with no joy. I have the EM64T 10g
> Server and Client, but no Ole DB. From the info on the MS MDAC web pages it
> sounds as if the MSADORA for x64 will be released, but no info when - trying
> to get more info. I would be like to hear what Oracle have planned, so
> please do pass info on, and I'll do likewise.
>
> Thanks,
> Andy
>
> "SMoss" wrote:
>
> > Andy,
> >
> > Thanks for info.
> > This is consistent with what our regional MS SQL Server tech rep advised:
> > that the msdaora.dll for x64 is not available yet. He was encouraging us to
> > switch to the Oracle Ole DB driver for Oracle, as MS is no longer updating or
> > supporting msdaora.dll for new Oracle versions and we are on 10g. It wasn't
> > clear if they were going to release the x64 driver at all, but if they've
> > released it for Itanium, guessing they will for x64.
> >
> > But Oracle's site advises that they don't have a 64-bit driver for AMD/x64
> > yet (they have one for 64-bit Itanium). We're contacting them asking them
> > when it will come out. I'll post on this thread if I hear something. Or if
> > you get any info, please advise.
> >
> > thanks--
> > SMoss
> >
> >
> > "Andy" wrote:
> >
> > > Steve,
> > >
> > > Sounds like you are using the x86 version of the DLL in the x64 directory.
> > > I ma also looking for an x64 version of the MSDAORA provider but all I have
> > > found so far is that MDAC 2.8 for x64 doesn't provide one. It is available
> > > for 32 bit programs running on the x64 platform as it does appear in the
> > > C:\Program Files (x86)... directory, but x64 64-bit programs can't use it.
> > >
> > > If anyone knows of an x64 bit version I would be happy to try it out.
> > >
> > > Andy
> > >
> > > "SMoss" wrote:
> > >
> > > > It doesn't appear to be a corrupt .dll. I copied an MSDAORA.dll thats in one
> > > > of our production servers and tried to register it with regsvr32.exe and it
> > > > threw the same error.
> > > >
> > > > So my current thinking (since I don't have anything left to test) that this
> > > > must be a 64-bit issue or the edition of SQL Server 2005 (April . Have others
> > > > been able to install and run this .dll to connect to Oracle when using x64
> > > > Windows 2003 Enterprise x64 edition?
> > > >
> > > > tks, -Steve
> > > >
> > > >
> > > > "Anton Klimov [MS]" wrote:
> > > >
> > > > > It could be that your msdaora.dll is corrupt.
> > > > > Could you try running depends.exe against it?
> > > > > http://www.dependencywalker.com/
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > > >
> > > > >
> > > > > "SMoss" wrote:
> > > > >
> > > > > > Thanks for your prompt reply.
> > > > > > I tried running regsvr32 on the msdaora.dll, and it wouldn't register it.
> > > > > > The error message is "msdaora.dll is not an executable file and no
> > > > > > registration helper is registered for this type of file".
> > > > > >
> > > > > > I've got the Oracle 10g client installed.
> > > > > >
> > > > > > Do you know if others have been able to install the MS OLE DB Provider for
> > > > > > Oracle successfully on
> > > > > > SQL 2005 64-bit (we're using the April CTP)?
> > > > > >
> > > > > > I'd try reinstalling the Oracle client and SQL Server 2005 if I knew that it
> > > > > > was only our problem, that it has worked for other people.
> > > > > > steve
> > > > > >
> > > > >
.

Relevant Pages