Connection problems

[IainK]

Hello there!

I am using ASP script imbedded in an html page to access data from an Oracle database.

As of right now the pages don't seem to load up, and instead I get a pop-up window telling me: "Out of virtual memory" and then one that says "the memory could not be 'read'. click ok to terminate the program". This leads me to believe that there is perhaps a loop in my coding or something (I am new to this).

My connection coding reads as follows:

<%
On Error Resume Next
Set oConn = Server.CreateObject(&quot;ADODB.Connection&quot
oConn.Open &quot;DRIVER={Microsoft ODBC for Oracle}; SERVER=aserver; UID=auser; PWD=apass&quot;
Set oRS=oConn.Execute(&quot;sql statement&quot
%>

My sql statement is correct as I have already tested it. Is there something wrong with my connection coding? I can provide the full content of the page if you think it might help (didn't want to post it all here).

Cheers very much!

- Iain

 

[Geee]

Do you get this error on the client or on the server?

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[shaddow]

&quot;Out of Virtual Memmory&quot; - Try to set manually the virtual memmory of your web server or Oracle Server, usually i put twice of my memmory. I had a w2000 Advance server with 512 MB Ram and i put almost 1 GB of virtual memmory
And try to set memmory dump to nothing...
And if u do not have enought memmory on the server try to put at least 512 MB of virtual memmory.The system will work slowly if u don't have enought memmory but it work... ________

George

 

[Geee]

Only 1 m in memory... -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-