Not connected to Oracle

[Sugith Kumar]

I have a simple SQL Select statement which is called in an
ASP file. But this gives error saying

Microsoft OLE DB Provider for Oracle (0x80004005)
ORA-03114: not connected to ORACLE

If I refresh the page again and again, it will get loaded
successfully..

Any idea why this is happening? Any help/advice would be
greatly appreciated.

thanks
Sugith

[Mark Schupp]

what version of oracle?
what version of oracle network software?
what odbc or oledb driver are you using?
show your connection string
show your code

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"Sugith Kumar" <sugith_kumar@dell.com> wrote in message
news:54ce01c37d36$9a7a5400$a501280a@phx.gbl...

> I have a simple SQL Select statement which is called in an
> ASP file. But this gives error saying
>
> Microsoft OLE DB Provider for Oracle (0x80004005)
> ORA-03114: not connected to ORACLE
>
> If I refresh the page again and again, it will get loaded
> successfully..
>
> Any idea why this is happening? Any help/advice would be
> greatly appreciated.
>
> thanks
> Sugith

[Sugith Kumar]

Version of Oracle is 9i.

Code is as follows

Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=MSDAORA;Data Source=wwpd;User
ID=app_user_sosa;Password=newuser;"
cn.CursorLocation = adUseClient

Thanks
Sugith

>-----Original Message-----
>what version of oracle?
>what version of oracle network software?
>what odbc or oledb driver are you using?
>show your connection string
>show your code
>
>--
>Mark Schupp
>--
>Head of Development
>Integrity eLearning
>Online Learning Solutions Provider
>mschupp@ielearning.com
>[url]http://www.ielearning.com[/url]
>714.637.9480 x17
>
>
>"Sugith Kumar" <sugith_kumar@dell.com> wrote in message
>news:54ce01c37d36$9a7a5400$a501280a@phx.gbl...

>> I have a simple SQL Select statement which is called in

an

>> ASP file. But this gives error saying
>>
>> Microsoft OLE DB Provider for Oracle (0x80004005)
>> ORA-03114: not connected to ORACLE
>>
>> If I refresh the page again and again, it will get

loaded

>> successfully..
>>
>> Any idea why this is happening? Any help/advice would be
>> greatly appreciated.
>>
>> thanks
>> Sugith

>
>
>.
>

[Mark Schupp]

Try loading the Oracle 8 network software instead of the Oracle 9 network
software. IIRC, the MS OLEDB drivers do not support Oracle 9 (have to use
..NET drivers, don't know the details).

Or

Use the Oracle OLEDB provider instead of the Microsoft provider (if your
application can handle it that way).

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"Sugith Kumar" <sugith_kumar@dell.com> wrote in message
news:0a6a01c37d97$7c955140$a101280a@phx.gbl...

> Version of Oracle is 9i.
>
> Code is as follows
>
> Set cn = Server.CreateObject("ADODB.Connection")
> cn.Open "Provider=MSDAORA;Data Source=wwpd;User
> ID=app_user_sosa;Password=newuser;"
> cn.CursorLocation = adUseClient
>
> Thanks
> Sugith
>
>

> >-----Original Message-----
> >what version of oracle?
> >what version of oracle network software?
> >what odbc or oledb driver are you using?
> >show your connection string
> >show your code
> >
> >--
> >Mark Schupp
> >--
> >Head of Development
> >Integrity eLearning
> >Online Learning Solutions Provider
> >mschupp@ielearning.com
> >[url]http://www.ielearning.com[/url]
> >714.637.9480 x17
> >
> >
> >"Sugith Kumar" <sugith_kumar@dell.com> wrote in message
> >news:54ce01c37d36$9a7a5400$a501280a@phx.gbl...

> >> I have a simple SQL Select statement which is called in

> an

> >> ASP file. But this gives error saying
> >>
> >> Microsoft OLE DB Provider for Oracle (0x80004005)
> >> ORA-03114: not connected to ORACLE
> >>
> >> If I refresh the page again and again, it will get

> loaded

> >> successfully..
> >>
> >> Any idea why this is happening? Any help/advice would be
> >> greatly appreciated.
> >>
> >> thanks
> >> Sugith

> >
> >
> >.
> >