Do you get the same issue with a sqlplus session?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"tbrinker" <tim_brinker_at_oakdene.com> wrote in message
news:7dc13640.0201311515.219d31fa_at_posting.google.com...
> I have written a Visual Basic program that connects to Oracle on the
> Unix server. When I first issue the connect command it takes 3 minutes
> to actually open the database. Once I am connected the program
> functions very efficiently. When I run the same program against Oracle
> running under windows NT, it takes 30 seconds to connect to the
> database.
>
> Any suggestions on why it would take 3+ minutes to just connect to the
> database on the Unix server?
>
> Here is the code I use to connect to the database...
>
> Conn = "UID=xxxx;PWD=xxxx;DRIVER={Microsoft ODBC for Oracle};" _
> & "SERVER=" & P_DataBase & ";"
>
> ' Connect to the database
> Set Cn = New ADODB.Connection
>
> ' Open the database
> With Cn
> .ConnectionString = Conn
> .CursorLocation = adUseClient
> .Open Cn
> End With
>
> Thanks for any help you can provide
>
> Tim
Received on Fri Feb 01 2002 - 04:01:33 CST
