Go Premium for a chance to win a PS4. Enter to Win

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

Connector ODBC Password Prompt

I'm using MS Access 2002 as a front-end to MySQL.  I don't want to be prompted for the password by the Connector/ODBC Window everytime I use open my Access database. I don't know why it doesn't it retain my password.  Is there an Expert here that knows how to get this connector window to stop prompting me?  Yes the password is stored in my system dns.

What do I need to do on the MySQL Server to prevent this prompt from occurring? Many kind thanks in advance!
0
John Account
Asked:
John Account
  • 2
1 Solution
 
UmeshCommented:
Hi,

Check this..
While doing DSN configuration you have a option , just click on that..then  you would see something like   " DOn't prompt on connect" in the miscellaneous optons [Rarely Used]  just make sure that the checkbox is checked.

just check out this url for more..
http://www.sourcekeg.co.uk/www.mysql.com/doc/connector/odbc/en/faq_3.html

Hope this helps!
0
 
John AccountAuthor Commented:
Have tried that myriad times--it never retains its value.  That "Don't Prompt On Connect" option is useless, or it means something else.
At any rate, it doesn't work. Thanks.
0
 
John AccountAuthor Commented:
I had to delete all the linked tables and relink 'em. That worked.
0
 
CetusMODCommented:
Closed, 250 points refunded.
CetusMOD
Community Support Moderator
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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