Hello,

Just recently installed 10g Express and the latest release of ODP.net and
found an issue or more of a nuisance. Everything works fine except for the
connection time to the DB.

Using:
XP Professional
Visual Studio 2003
Oracle 10g Express
9i Client
ODB.net

I tried to figure out all weekend what was causing the delay in the
connection, which takes just over a minute. Decided to give up and just
suffer.
Yet, today when I get home, I open the vb project and run it. It takes about
half a second to connect. It dawned on me that I was not connected to my
wireless network at home. So I tried 5 more times with the same results.
Then I enabled my wireless card and the connection time returned to about a
minute. Also, while at work today (connected to the company wireless
network), the connection time was about a second. I'm sure it has something
to do with my wireless network, just don't know what. Any thoughts would be
appreciated.

Here is my connect code.
Imports Oracle.DataAccess.Client

Public Class ODP

Public cn As New OracleConnection

#Region "-- Connection to Oracle --"

Public Sub New(ByVal User As String, ByVal Password As String, ByVal Source
As String) 'Oracle

Try

Dim cnString As String = "User ID=" & User & _

";Data Source=" & Source & _

";Password=" & Password

cn.ConnectionString = cnString

cn.Open()

Catch ex As Exception

MsgBox(ex.Message, MsgBoxStyle.Critical, "Open DB Error")

End Try

End Sub

#End Region

End Class

SQL connection timeout -- is it pretty useless or what?
ObjectSpaces is realy good?
Access Lock Remains after Connection Closed - OLE DB / Jet
Index column in Dataset (or Datareader) !!!!
Enterprise Library (what should I use...)