Re: oracle connection hang, and vbscript

From: Robert Dimitrovski <robert.dimitrovski_at_ht.hr>
Date: Tue, 27 May 2003 09:52:12 +0200
Message-ID: <1054021914.46835@tuxri2.tkcrij.ht.hr>

I could not find in your code Data Source, so I give you example how it works on my engine:

    With connection's name

        .CursorLocation = adUseClient
        .IsolationLevel = adXactReadCommitted
        .Mode = adModeShareDenyNone
        .Open "Provider=MSDAORA.1;Data Source=database;" & _
      "DNS=Create in Data Sources(ODBC) new FileDSN;User Id=" & Text2.Text &

";Password=" & Text3.Text & ";"

"bigbinc" <bigbinc_at_hotmail.com> wrote in message news:d1b33313.0305161634.5909a191_at_posting.google.com...
> I am trying to connect to an oracle database over the internet and my
> page keeps hanging on the connect code. I am using oracle9.0.1 and
> using the default client installs on the iis server. I have also
> installed ole db. Our network config is such that the oracle server
> is a seperate machine from the webserver and this is where I think the
> problem is. I can connect to the oracle server through sql*plus from
> the webserver. When I go to the odbc connection under administrative
> tools and press test connection that works also. But when I run my
> web page which is a simple open connection, the page hangs. My
> tnsnames.ora looks ok, as does my sqlnet.ora, plus the same setup
> works with sql*plus and the odbc connection. So where is the problem,
> why no webpage, no error message, nothing? My guess is my admin
> locked up that port over the internet or something?
>
>
> i.e
> pseudo-code
>
> Dim x
> x = Server.CreateObject("ADODB.Connection")
> Dim b
> b = "Provider=OLEDB.Oracle.1;uid,pwd,blah, blah"
> x.open b <--- hangs at this point.
>
> Berlin Brown
> bigbinc_at_hotmail.com
Received on Tue May 27 2003 - 02:52:12 CDT