Problem in connecting to mysql from MSAccess 2000
Hi, I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS Excel. However, it returned the following error when I tried to link some Mysql tables from Access 2000: ODBC--call failed. [MySQL][ODBC 3.51 Driver][mysql-4.0.4-beta-max-nt]Access denied for user: '@my ip address here' to database 'tradingdata' (#1044). Any help would be much appreciated. Regards, Gilbert Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL and MSAccess
Haven't done a great deal of this but it does work pretty well. Obviously connection speed is a bit of an issue especially where you are dealing with INSERTS into several linked tables from a form. I couldn't find an equivalent field in MySQL for the Yes/No type in Access so it you create an a 2 character INT field and populate it with either 0 (no) or -1 (Yes) then you can get them to work quite well. I'm sure that some guru will have a better idea than that! What sort of stuff are you doing? Craig shepherd -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: 11 March 2002 20:08 To: [EMAIL PROTECTED] Subject: MySQL and MSAccess Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance. Chris _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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 - 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
MySQL and MSAccess
Is anyone out there using MySQL on either Unix or NT, with MSAccess as the front-end? Are you using odbc bound controls on your access forms? Any issues? Suggestions? In-sights? We are planning on migrating a SQLServer back-end to MySQL on Linux as a robust and affordable back office solution. Thanks in advance. Chris _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - 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
MySQL and MSAccess
Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance. Chris _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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
Re: MySQL and MSAccess
Hi Chris, Also interested in exploring how MS products can interact with MySQL since I work in a diverse environment (PC's, some MACs, UNIX clusters-Solaris 8). I found this so far: http://www.mysql.com/doc/M/y/MyODBC_clients.html Also, to check which version of MDAC you have use: Component Checker http://www.microsoft.com/data/download.htm#CCinfo That's all I have I'm fairly new to most of this... I'm hoping other list members have more to say. ;) Regards, -Ryan On Mon, 11 Mar 2002, Chris Becker wrote: Is anyone out there using MySQL on either Unix or NT, with MSAccess as the front-end? Are you using odbc bound controls on your access forms? Any issues? Suggestions? In-sights? We are planning on migrating a SQLServer back-end to MySQL on Linux as a robust and affordable back office solution. Thanks in advance. Chris _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - 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 || | Ryan Russo | | Academic Computing Web Group, (518) 442-4772 | || - 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
