Re: database connection problem in VB.net

Agni Jonnalagadda — Wed, 13 Jul 2005 06:52:05 GMT

Hi Ger Eielts, Welcome to the Forum!
Did you give Full trust to your form? When you are connecting to a DB through code you need to give Full trust to your InfoPath project, that is the reason that the exception is raised in the line where you are taking a DB connection.
There are many posts about giving full trust to your InfoPath project.

Agni
InfoPathDev India

database connection problem in VB.net

GerEielts — Tue, 12 Jul 2005 23:16:13 GMT

Hi all,

When I open an infopathproject in Visual Studio and want to add some code to a button on a InfoPath-form, like this:

Public Sub CTRL11_5_OnClick(ByVal e As DocActionEvent)
Dim ConnectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Ontwikkel\G\Ger\Nummers.mdb;"
Dim Conn1 As OleDbConnection = New
OleDbConnection(ConnectionString)
Dim Comm1 As OleDbCommand = New OleDbCommand("UPDATE
Opdrachtnummers SET Opdrachtnummer = Opdrachtnummer + 1")
End Sub

I got the following error:

System.Security.SecurityException
Request failed.
at InfoPathProject4.InfoPathProject4.CTRL11_5_OnClick(DocActionEvent e)
at
Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

This happens on the dimensions of Conn1 and/or Comm1. What can be wrong ?
Help is appreciated.

Regards, Ger.

Carpe diem

SQL Database Integration

Re: database connection problem in VB.net

database connection problem in VB.net