jwcolby
jwcolby at colbyconsulting.com
Sat Jun 2 09:38:50 CDT 2007
I created the following code, which was tested and working when running on
the machine that the database server resides on. I am now trying to run it
from my laptop, which is my development machine. This class is initialized
in the button click on a form just for troubleshooting purposes. The code
steps in to the new constructor , the mobjCn is set, it drops into the Try
and then steps into the open and hangs, never to return.
StrConnection is:
Provider=SQLOLEDB;Data Source = Azul;Initial Catalog = Infutor;Integrated
Security=SSPI
Azul is both the name of the machine running SQL Server 2005 and the name of
a SQL Server instance on machine Azul, which can be seen and manipulated
from the laptop. Infutor is a specific database which can be seen and
manipulated from the laptop. SSPI I do not understand the definition of, it
was something that I tried and it worked from the SQL Server machine (also
named Azul).
Public Class clsProcessData
Private mobjCn As OleDbConnection
Private mobjDA As New OleDbDataAdapter
Private mobjDS As DataSet
''' <summary>
'''
''' </summary>
''' <param name="strConnection"></param>
''' <remarks></remarks>
Public Sub New(ByVal strConnection As String)
mobjCn = New OleDbConnection(strConnection)
Try
Debug.Print(strConnection)
mobjCn.Open()
Catch ex As OleDbException
MessageBox.Show("Could not open the connection: " +
strConnection)
End Try
mobjDA.SelectCommand = New OleDbCommand
mobjDA.SelectCommand.Connection = mobjCn
mobjDS = New DataSet
End Sub
Any ideas what to try here?
John W. Colby
Colby Consulting
www.ColbyConsulting.com