How do I keep my server connection open in VB2008?

I'm working on an ADO.Net app in VS 2008. When I'm working on the app, every time I try to look at the data in a specific table in my database using the server explorer it asks me for the password of the database before I can view the data in the table. Before it would stay connected all the time so I could view the table data as needed. I'm using an ODBC connection. How can I set this to stay connected all the time as before?

Thanks
Peter
grouchyfdAsked:
Who is Participating?
 
PaulHewsConnect With a Mentor Commented:
In the data connection editor, if you don't select "Save my Password" checkbox on the connection dialog, it will prompt you each time.  

Right click your connection in Server Explorer and select "Modify Connection..."
Enter the password here, and make sure the checkbox is checked to persist the password.
0
 
grouchyfdAuthor Commented:
Thank you. It works fine now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.