Dear All,
Everything was working perfect until i embedded FormEvents_Loading event in the code. I have data sources which get something from SQL and are using windows authentication. As soon as i add this FormEvents_Loading code and publish my form on the server, the datasources with windows authentication are not executing and giving this error
The following query failed: Country (User: , Form Name: RegNewTestForm, IP: , Connection Target: http://portal:1117/Data Connection Library/Country.udcx, Request: , Form ID: urn:schemas-microsoft-com:office:infopath:RegNewTestForm:-myXSD-2011-09-15T14-56-49 Type: DataAdapterException, Exception Message: The database adapter cannot be run because you have no credentials specified.)
Please note that all the connections which are using SA Admin password are working fine. This is the case only with windows authentication datasources. once you comment FormEvents_Loading, everything starts working fine.
UDCX which is not working has this connection string
<udc:ConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=ISQ;Data Source=portal;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=NABEEL;Use Encryption for Data=False;Tag with column collation when possible=False</udc:ConnectionString>
UDCX which is working has this connection string
<
udc:ConnectionString>Provider=SQLOLEDB.1;Password=testing123;Persist Security Info=True;User ID=sa;Initial Catalog=ISQ;Data Source=Portal;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MBS-07;Use Encryption for Data=False;Tag with column collation when possible=False</udc:ConnectionString>
Pleaes help