Re: "Microsoft ODBC for Oracle" Failing when connecting to a 9i server

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

From: Scott Buerkley (Scott_Buerkley_at_Yahoo.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 07:04:20 -0500

Thank you. That is what I was starting to think.

I installed ODBC drivers from Oracle and could not get that to work at 1st
either. I had to give the 2 IIS user accounts full rights to the Oracle
home folder, C:\Oracle\Ora92home. Then it worked.

Thx,
Scott Buerkley

"John Blessing" <jb@**REMOVE**THIS**LbeHelpdesk.com> wrote in message
news:Oefjc.197$tq1.36@newsfe2-gui.server.ntli.net...
> "Scott Buerkley" <Scott_Buerkley@yahoo.com> wrote in message
> news:%23erGm38KEHA.3216@tk2msftngp13.phx.gbl...
> > We just upgrade our oracle server from 8i up to 9i and now our asp pages
> are
> > failing. We were using the Microsoft ODBC drivers for Oracle V
> > 2.573.7926.00 to connect othe 8i server and it worked great. We are
using
> > an ADO connection on as ASP page to display data.
> >
> > This is the error we are getting:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [Microsoft][ODBC driver for Oracle][Oracle]
> >
> > When I try to link to the Oracle 9i server with Access on the same
server,
> I
> > get the following error:
> > Driver's SQLSetConnectAttr failed IM006 0
> >
> > Is anyone else having this issue?
> >
> > Thx,
> > Scott Buerkley
>
> IIRC the MS drivers don't support Oracle 9. You need to use Oracle's OLEDB
> driver.
>
> --
> John Blessing
>
> http://www.LbeHelpdesk.com - Help Desk software priced to suit all
> businesses
> http://www.free-helpdesk.com - Completely free help desk software !
> http://www.lbetoolbox.com - Remove Duplicates from MS Outlook
>
>

Relevant Pages

  • Re: "Microsoft ODBC for Oracle" Failing when connecting to a 9i server
    ... "Scott Buerkley" wrote in message ... We were using the Microsoft ODBC drivers for Oracle V ...
    (microsoft.public.inetserver.asp.db)
  • Re: Import problems on Windows Server
    ... your OWN research the Mickeysoft ODBC drivers do NOT support ANY ... Oracle feature beyond 7.3? ... There are plenty of non MS ODBC drivers that will connect with the various editions of non-MS databases, some of the drivers are actually better. ... Free speech - I'm here to stay dude - get used to it; when you see a post relating to SQL Server or Windows I'll be there with an answer to any myth you might want to TRY and spread. ...
    (comp.databases.oracle.server)
  • Re: Dynamically generating a word document from oracle data
    ... way for the user to set up the Word document and indicate where the data ... coming from Oracle should go. ... Since you have Oracle ODBC drivers, I'd say mail merge ought to be able to ... > some "blanks" using data coming from an oracle database. ...
    (microsoft.public.office.developer.automation)
  • Re: Import problems on Windows Server
    ... "Care to remember how Microsofts ODBC driver for Oracle doesn't support ... You stated MS ODBC didn't support ANY feature after 7.3, the KB article states otherwise - if you cannot accept that, it's not my problem, it's a fact there crystal clear on the MS website. ... Then in another post you or Deniel Again Morgan stated Oracle have their own ODBC drivers - great, use them, they are probably better because they will no the hooks into Oracle better and so long as they follow the ODBC standard then everybody is happy. ...
    (comp.databases.oracle.server)
  • Re: 64 Bits ODBC Drivers for SYBASE and ORACLE
    ... How to make them available for the IMPORT/EXPORT Data Wizard in SQL SERVER ... drivers.......on linux/unix they do not necessarily have ODBC drivers. ... I use easysoft drivers for Oracle on linux/unix.... ...
    (microsoft.public.data.odbc)