DB Connect

[Pat Coon]

Hi all

i have created a infopath formular with a dropdown menu,.. as example if
you choose from the dropdown the value value1 this will fill out some other
text tables in the form automaticaly. i have placed a query in the value1
with a external sql db source.

now every time i launch the infopath formular from a other unser i allways
get a popup box with the sql connection credetials....

is there any way to place the sql connet(host, user and pass) in the
formular it self ?


thanx

 

[darko]

Hi Pat,

When you are making the connection to the database in InfoPath, InfoPath
asks for LonOn credentials. If you choose Windows, the credetals used to
connect to the database will be the current user username and password. But
InfoPath can connect to the databse with fixed username and password in the
data source. You can put fixed username and password, or you can create an
database user, and use this account in youre connection string.

Darko Milevski, MCAD