How to test that a connection is valid...

Greg McGuffey — Tue, 06 Nov 2007 09:09:38 GMT

I have a method that checks that a DataSource is valid by attempting to connect to it. However, when using ES, the method fails. I've tried two methods, both work if I'm setting a sql data source and both fail if I use ES.

[b]Method 1[/b]
This method gets a DbConnection from the DataSource using the CreateBlankDbConnection method, then attempt to open it:
[codesnippet] Private Function ValidateConnection(ByVal key As String) As Boolean
'-- Establish return var
Dim connOK As Boolean
'-- Validate the connection
Using testConn As Data.Common.DbConnection = DataBasics.DataSources(key).CreateBlankDbConnection
Try
testConn.Open()
connOK = True
Catch ex As Exception
'-- Connection failed
connOK = False
End Try
End Using
'-- Return result
Return connOK
End Function[/codesnippet]

[b]Method 2[/b]
This method attempts to use a BO (typically one that has little data in the underlying table) to attempt to fill it. The idea here is that if the fill method works (no exceptions) then the connection is valid:
[codesnippet] Private Function ValidateAppDbConnection() As Boolean
'-- Establish return var
Dim connOK As Boolean
'-- Try to fill a BO. If there is no exception we have a connection.
Try
Using bo As New MyBO()
bo.FillByPrimaryKey(1)
End Using
connOK = True
Catch ex As Exception
connOK = False
End Try
'-- return results
Return True 'connOK
End Function[/codesnippet]

I'm calling these in the SetDataSources event handler. Again these both work when [b]not[/b] using ES.

So, I'm wondering why they don't work and then I'm wondering how I'd check the connection when connecting to the data via ES.

Thanks!

RE: How to test that a connection is valid...

StrataFrame Team — Tue, 06 Nov 2007 09:09:38 GMT

The first one won't work because it's trying to use the SqlConnection object directly...

However, the second one should work fine... what's the exception that you're getting on the second one when you're using an ES data source?

RE: How to test that a connection is valid...

Greg McGuffey — Mon, 05 Nov 2007 14:46:13 GMT

bump... :blink:

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » How to test that a connection is valid...

How to test that a connection is valid...

RE: How to test that a connection is valid...

RE: How to test that a connection is valid...