Re: MS Access not sending the username to MySQL

2001-06-22 Thread Howard Lowndes
I get two info boxes. The first says "ODBC-call failed" The second says "[TCX][MyODBC]Access denied for user: '@dhcp85.lannet.com.au' to database 'Treasury' (#1044)" In the TDX mysql Driver default configuration dialog box from Control Panel->ODBC Data Source (32bit) the user name is set as LAN

Re: MS Access not sending the username to MySQL

2001-06-20 Thread Joshua J. Kugler
You say it's not sending the user name. What connect string are you using? Does it include the user name? Can you post the exact connect string you are using when you connect to the database? As I have it set up on my windows side of things: the DSN in the ODBC setup has no username or pass

MS Access not sending the username to MySQL

2001-06-20 Thread Howard Lowndes
I have a situation where the error I am getting in MS Access indicates that the user name that I have set up in the OBC driver is not being sent to MySQL. The irony is that when I set the ODBC driver up initially, it worked, but then after closing MSA and restarting it the damned thing failed