How do I connect to a SQL database using InfoPath

[n2infopath]

I have created a form that runs a query to retrieve data from a SQL database.
I am trying to figure out the best way to connect to a SQL database. I have
used the Data Connection Wizard to connect via Microsoft SQL Server
<servername> <SQLdatabasename> The problem using this method I get a
connection failed message Login failed for user, SQL Server Error: 18456.
(for those users who are not administrators) I have also used an ODBC
connection, but cannot figure out how to connect without having to type a
username and password. The scenerio I am looking for is the form to open
without using a username and password. Your help is appreciated.

Thanks,
Cindy

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Please read this link , I hope it might help you
http://support.microsoft.com/kb/889646

 

[Clay Fox]

For connecting your InfoPathform to SQL - check out the Database Accelerator
http://www.qdabra.com
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com