I am going to assume that you are on a windows platform and tell you about what I did. I developed a large ERP system using MSAccess for the front end and MySQL for the backend. Because MSAccess doesn't notice changes to the table structure of a MySQL (ODBC) table, I wrote a routine that deleted all of the MySQL connections during startup, and then relinked them. Because ODBC stores the user names and passwords in the registry (anyone with access to the registry can read a users password for MySQL unencrypted) I added a function that rewrote the necessary registry keys before and after the tables were linked. These keys control the user name, password, and MySQL options. After the tables are linked, I rewrite the keys with a bogus password to prevent a registry editor from compromising the password. I leave the password as a global variable and use it for Pass through queries and the like. I know this isn't full proof but its better then the defaults, at least IMHO. Hope that helps, [EMAIL PROTECTED] I apologize for the HTML but this mailer won't let me turn it off. -----Original Message----- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 05, 2001 1:16 PM To: mysql Cc: warren Subject: myODBC Hi there I have an ODBC connection to my database, but I want the ability to specify the username and password with my code when the connection is made. At the moment I just use the values entered when I setup the ODBC connection but this is most definatelly not what I want. Thanks Warren ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
