Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / October 2006

Tip: Looking for answers? Try searching our database.

DB Connect

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pat Coon - 25 Oct 2006 16:29 GMT
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 - 27 Oct 2006 13:45 GMT
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

> Hi all
>
[quoted text clipped - 10 lines]
>
> thanx
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.