InfoPath Dev

Can anyone help me in handing Infopath sql exceptions before form Load.

For example, if the datasource object or name is not available in data base,  before Form Load I am gettting the following error.

Failed Connection to Datasource: 

The query cannot be run for the following DataObject: EmployeeLookUp

InfoPath cannot run the specified query.
[0x80040E37][Microsoft OLE DB Provider for SQL Server] Invalid object name 'dbo.vw_EmployeeLookup'.

Instead of getting the above error message, I want to handle it by using my custom Message.

Hi

I use the following VB code to check to see if the Access DB is in use with a Form Load event. It checks for the existence of the lock file (.ldb) then displays a custom message if the DB is in use. I don't know SQL but I'm sure it should have something similar.

Sub XDocument_OnLoad(eventObj)

Dim db As String = ("pathname\access.ldb")

'Check to see if database is in use

If File.Exists(db) Then

Else

Open()

End If

End Sub

Gary