[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

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
0
grouchyfd
Asked:
grouchyfd
1 Solution
 
PaulHewsCommented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now