Connection to sql table

[andyoye]

IP2007
Browser form
Moss 2007

I have a drop-down that recieve data from a sql table's column. If I preview
the form, I do see the entries.

When I publish the form to a sharepoint form library, I get

" The form could not retrieve data from http://server/...... because it
would violate cross-domain restrictions. To allow this connection for
administrator-approved form templates, enable full trust for the form
template, or add the connection to a Data Connection Library. For user form
templates, cross-domain connections must be enabled in SharePoint Central
Administration, and all connections must be in a Data Connection Library.
For more information, please see the security documentation for InfoPath
Forms Services. (User: DOMAIN\User, Form Name: Leave Application...... "

Now when I convert the data connection to a DCL ( data connection library)
or/and full trust the form, I get

" The following query failed: tblUser (User: Domain\user1, Form Name: sql
testing, IP: , Request:
http://server1/_layouts/FormServer....testing/Forms/AllItems.aspx&DefaultItemOpen=1,
Form ID:
urn:schemas-microsoft-comffice:infopath:sql-testing:-myXSD-2008-12-17T16-21-39,
Type: DataAdapterException, Exception Message: The form cannot connect to
the data source. Login failed for user '(null)'. Reason: Not associated with
a trusted SQL Server connection.)"

Any help would be great.

Thanks

 

[Shiva (GGK Tech)]

Hello,

Go through the below link, Not associated with a trusted SQL Server connection

http://forums.asp.net/p/946809/2643822.aspx

 

[andyoye]

Even if I supply user/password while creating the data connection to the
sql server to recieve data, its still not working

 

[Rajitha]

Hi,
Can you verify below links once.
http://www.sharepointblogs.com/ssa/...-fields-with-sql-data-using-managed-code.aspx
http://biztalkwithshashikant.blogspot.com/2008/01/accessing-sql-data-from-infopath-form.html
Hope this helps.

 

[andyoye]

I got it working with centrally managed DCL

thanks everyone