How I can change my connection string in a existing form?

[KssKumar2000]

Hi,

While designing the form, I have not saved the required sql server
username/password with the form. So while using this form in the
enduser system, it popup the SQL server login dialog each time when we
submit the form. To avoid this, I have to save the valid
username/password along with the form.

How I can change my connection string in a existing fully designed
form?

Is any other solutions is there ?

Thanks & regards,

 

[Andrej]

Hi,

open your form in the design view.
go to your dataconnection dialog: tools - dataconnections
update your main connection. while updating your connection you can set the
checkbox for saving your password and user in your form.

the password and username are saved in cleartext!!! it is not save!!!!
all users will be connected through this one user you saved in your form.

if you are using sqlserver you can set the security settings for your user
in the sqlserver enterprise manager. i prefer the second way.

Andrej