Re: Handling "Failed Connection to Datasource Error" in infopath using custom messages

GazM — Wed, 13 May 2009 12:20:04 GMT

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

MsgBox("your message")

Close()

Else

Open()

End If

End Sub

Gary

Handling "Failed Connection to Datasource Error" in infopath using custom messages

arunk.krish — Tue, 12 May 2009 14:23:51 GMT

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.

General

Re: Handling "Failed Connection to Datasource Error" in infopath using custom messages

Handling "Failed Connection to Datasource Error" in infopath using custom messages