Oracle 9.2.0.3.0 ODBC Fails

[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.

At the beginning we were getting and odbc error when it was trying to
connect in the script. After installing the Oracle ODBC drivers V
9.02.00.006 we are not getting any error message at all. It just stops at
Opening Page... and goes no where. Even if I switch back to using the
microsoft odbc connection again it still just hangs now also.

Here is the connection code we are using:

' ***** IQO is using the Oracle ODBC drivers *****

myDSN="DSN=IQO;uid=user;pwd=password"

'myDSN="DSN=IQO"

'myDSN="DSN=IQO;userid=user;password=password"


' ***** IQ is using the Microsoft ODBC for Oracle drivers *****

'myDSN="DSN=IQ;uid=user;pwd=password"

mySQL="select MFGNO from Standard order by MFGNO"


set conntemp=server.createobject("adodb.connection")

conntemp.open myDSN

set rstemp=conntemp.execute(mySQL)


Thx,
Scott Buerkley

[Scott Buerkley]

Just wanted to let everyone know, I started a new post called "Microsoft
ODBC for Oracle" Failing. I am getting error messages now. As it turns out
the, something with my connection string causes the IIS server to go to
100%, so the web pages looked like they were hanging. I can not stop the
www server and restart it. It just hangs. I have to reboot the server each
time while testing :( so I am going back to troubleshooting the microsoft
drivers instead. :)

Thx,
Scott Buerkley


"Scott Buerkley" <Scott_Buerkley@yahoo.com> wrote in message
news:%23LnVzmyKEHA.2556@TK2MSFTNGP11.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.
>
> At the beginning we were getting and odbc error when it was trying to
> connect in the script. After installing the Oracle ODBC drivers V
> 9.02.00.006 we are not getting any error message at all. It just stops at
> Opening Page... and goes no where. Even if I switch back to using the
> microsoft odbc connection again it still just hangs now also.
>
> Here is the connection code we are using:
>
> ' ***** IQO is using the Oracle ODBC drivers *****
>
> myDSN="DSN=IQO;uid=user;pwd=password"
>
> 'myDSN="DSN=IQO"
>
> 'myDSN="DSN=IQO;userid=user;password=password"
>
>
> ' ***** IQ is using the Microsoft ODBC for Oracle drivers *****
>
> 'myDSN="DSN=IQ;uid=user;pwd=password"
>
> mySQL="select MFGNO from Standard order by MFGNO"
>
>
> set conntemp=server.createobject("adodb.connection")
>
> conntemp.open myDSN
>
> set rstemp=conntemp.execute(mySQL)
>
>
> Thx,
> Scott Buerkley
>
>