Newbie Questions

Re: InfoPath Stored Procedure Execute Error -- Help!

henscola — Thu, 24 Aug 2006 19:15:33 GMT

In our shop, we use SQL through views for security. Here is how we call SP's in our code...

Dim Rs 'Main Recordset object
Dim Rs2 'Dropdown Box Object
Dim Cnn 'Connection Obj
Dim strUId 'User NT Id
Dim strCnn 'Conn str
Dim strText

Set lstCntPinTries = XDocument.DOM.selectSingleNode("//my:lstCntPinTries")
Set txtSearch = XDocument.DOM.selectSingleNode("//my:txtSearch")

TrimUserId()
TrimCnnStr()
OpenDbConnection()
InitializeForm()
DetermineRecNbrAndCount RecNbr2, RecCnt2

Public Sub InitializeForm()
GetRecordSet()
txtCreate_Record = "N"

Public Sub InitializeForm()
GetRecordSet()
txtCreate_Record = "N"

If Not Rs.EOF Then
PopulateFields()
'Set Navigation Button status
DisplayRecNbrAndRecCnt()
End If

End Sub

Public Sub GetRecordSet()

Dim Sp
Dim cmd
Dim j

Set cmd = CreateObject("ADODB.Command")

cmd.ActiveConnection = Cnn
cmd.CommandText = "usp_On_the_DOT_AwardList"
cmd.Prepared = True

Set Rs = cmd.Execute(j,strUId,adCmdStoredProc)

End Sub

I hope this helps.

Re: InfoPath Stored Procedure Execute Error -- Help!

sam1996 — Wed, 23 Aug 2006 12:02:51 GMT

Hi Agni,

That worked....Thanks so much...

SAM

Re: InfoPath Stored Procedure Execute Error -- Help!

Agni Jonnalagadda — Tue, 22 Aug 2006 19:04:34 GMT

Hi SAM,
If you are trying to connect to a secondary datasource why are you setting command value to XDocument.QueryAdapter?
You have to set it to XDocument.QueryAdapters["ConnectionName"].Command = "query";
and do a query on XDocument.QueryAdapters["ConnectionName"].Query();

Re: InfoPath Stored Procedure Execute Error -- Help!

sam1996 — Tue, 22 Aug 2006 11:15:19 GMT

Re: InfoPath Stored Procedure Execute Error -- Help!

Agni Jonnalagadda — Mon, 21 Aug 2006 18:52:07 GMT

Hi,
Error message clearly says that
"This discrepancy might be caused by the data source returning multiple rows when InfoPath expects only one." This means that the schema of the InfoPath form and the data that is returned by the database is different.

You can try out the same thing using a secondary data connection, that will work. Now check the difference between your main schema and the new schema that is returned by the DB.

InfoPath Stored Procedure Execute Error -- Help!

sam1996 — Fri, 18 Aug 2006 11:21:42 GMT