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

[Scott Buerkley]

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

[Ray at]

Not saying that I'd have an answer for you, but isn't there a description to
go along with that error?

Here are some common 80004005 error reasons:
[url]http://www.aspfaq.com/show.asp?id=2009[/url]

Ray at work


"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
>
>
>

[John Blessing]

"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

[url]http://www.LbeHelpdesk.com[/url] - Help Desk software priced to suit all
businesses
[url]http://www.free-helpdesk.com[/url] - Completely free help desk software !
[url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook

[Scott Buerkley]

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
>
> [url]http://www.LbeHelpdesk.com[/url] - Help Desk software priced to suit all
> businesses
> [url]http://www.free-helpdesk.com[/url] - Completely free help desk software !
> [url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook
>
>

[psilon@aros.net]

We are getting the same thing. Have been battling with this for over a week now. tnsping works... as does sql*net, but connecting through our application does NOT work. same error. researching.

I appreciate hearing any solutions you find, and I will pass along what I find as well.



************************************************** ********************
Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[psilon@aros.net]

We are getting the same thing. Have been battling with this for over a week now. tnsping works... as does sql*net, but connecting through our application does NOT work. same error. researching.

I appreciate hearing any solutions you find, and I will pass along what I find as well.



************************************************** ********************
Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...