RE: MySQL with MyODBC Access
Hi I recently upgraded MyODBC as you stated on our terminal server and two PCs. Now I tried running the install.bat file but it didn't seem to work so I just looked at the batch file and did it all manually. I believe for some odd reason the variable %windir% wasn't working. Either way the upgrade seem to go over well. The only issue I noticed since upgrading MyODBC to 2.50.39.00 is that now I have two MySQL drivers installed or so it appears. The first driver is MySQL and the second is MySQL Driver. Both show the version at 2.50.39.00 and company as MySQL AB. Is this a problem? The main reason I ask is for some odd reason on our terminal server the users using MyODBC are prompted with the MyODBC dialog box and seems to be missing the password. I've checked the registry and it's in their perfectly. If you enter the password manually when the dialog box appears it works with no problem. I do not want the users knowing this password (even though they could look it up in the registry, smile). How do I stop this dialog popping up and use the password I providing the System DSN profile? Is this issue maybe related to me having to MySQL drivers? -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 6:17 AM To: Adam Douglas Subject: RE: MySQL with MyODBC Access Just download the driver files and copy them to system directory by ovveriting previous files. - 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 with MyODBC Access
Hi, -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 6:54 AM To: '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail) Subject: RE: MySQL with MyODBC Access Hi I recently upgraded MyODBC as you stated on our terminal server and two PCs. Now I tried running the install.bat file but it didn't seem to work so I just looked at the batch file and did it all manually. I believe for some odd reason the variable %windir% wasn't working. Either way the upgrade seem to go over well. The only issue I noticed since upgrading MyODBC to 2.50.39.00 is that now I have two MySQL drivers installed or so it appears. The first driver is MySQL and the second is MySQL Driver. Both show the version at 2.50.39.00 and company as MySQL AB. Is this a problem? The main reason I ask is for some odd reason on our terminal server the users using MyODBC are prompted with the MyODBC dialog box and seems to be missing the password. I've checked the registry and it's in their perfectly. If you enter the password manually when the dialog box appears it works with no problem. I do not want the users knowing this password (even though they could look it up in the registry, smile). How do I stop this dialog popping up and use the password I providing the System DSN profile? Is this issue maybe related to me having to MySQL drivers? It should be {MySQL} only, might be the .rsp file got the wrong driver name. Any way, that shouldn't cause any problems in the driver behaviour as both of them are listening to the same driver DLL. You can correct it by removing the other one :) PS : Please, don't put everything in a single paragraph, as this is making hard to read. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 6:17 AM To: Adam Douglas Subject: RE: MySQL with MyODBC Access Just download the driver files and copy them to system directory by ovveriting previous files. - 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 with MyODBC Access
I've recently setup MyODBC and MS Access to use a ODBC profile that is global to everyone. What I did was make a new user in MySQL and then create a MyODBC User DSN. I made the links to MySQL in Access using this profile. The problem I'm having is this, when you initially go into MS Access you have to always click on a specific table then close it and begin the task you wish to do. If you do not do this then nothing works. For some odd reason if you try to open a form or a link it will come up with the ODBC dialog box and always seems to have the database name wrong. The database name seems to match the DSN name. Any ideas why this is not working properly for me? If you need any more information please let me know. Oh yeah the part that makes this really odd is that I have a User DSN setup for myself and one other person for administration purposes only. This User DSN seems to work fine on both our machines. Really odd. Also I've noticed that using Access as a front end to MySQL it seems to not bring through data that is using a type of bigint. Is this a limitation of using Access as a front end? If so what other column types would MS Access not support? - 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 with MyODBC Access
Hi -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 12:55 PM To: 'David Turner'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail); '[EMAIL PROTECTED]' Subject: MySQL with MyODBC Access I've recently setup MyODBC and MS Access to use a ODBC profile that is global to everyone. What I did was make a new user in MySQL and then create a MyODBC User DSN. I made the links to MySQL in Access using this profile. The problem I'm having is this, when you initially go into MS Access you have to always click on a specific table then close it and begin the task you wish to do. If you do not do this then nothing works. For some odd reason if you try to open a form or a link it will come up with the ODBC dialog box and always seems to have the database name wrong. The database name seems to match the DSN name. Any ideas why this is not working properly for me? If you need any more information please let me know. Oh yeah the part that makes this really odd is that I have a User DSN setup for myself and one other person for administration purposes only. This User DSN seems to work fine on both our machines. Really odd. This is due to invalid connection parameters supplied in the DSN entries. for a particular MyODBC DSN, you might have specified only the valid DSN and other fields you left it as blank, and that's why driver behaves as you explained above. Please refer to the following link, for more information on how to setup a DSN for MyODBC with different connection parameters. http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#ODBC_adm inistrator Also I've noticed that using Access as a front end to MySQL it seems to not bring through data that is using a type of bigint. Is this a limitation of using Access as a front end? If so what other column types would MS Access not support? As per the ODBC spec, BIGINT is not a privileged data type with 2.x specifications, so MyODBC doesn't support this. The new MyODBC 3.51 which is going to be released shortly supports BIGINT. For more information about Access--MySQL data types, refer to the following thread: http://lists.mysql.com/cgi-ez/ezmlm-cgi?4:mss:7537:200110:nbhnfhhlmikphfjkncdh Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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