Oracle 10g Express, 9i Client & Wireless Enet
- From: "Brian Pruitt" <b.pruitt@xxxxxxxxxxxxxx>
- Date: Mon, 10 Jul 2006 23:34:03 GMT
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
.
- Prev by Date: Re: Access Lock Remains after Connection Closed - OLE DB / Jet
- Next by Date: Event: ADO.NET Provider Writer Tech Preview, July 31 - August 2, 2006
- Previous by thread: Filling from inside a transaction?
- Next by thread: Event: ADO.NET Provider Writer Tech Preview, July 31 - August 2, 2006
- Index(es):
Relevant Pages
|
