This is probably the most common problem people run into with ODBC drivers on bit systems. Stack Overflow works best with JavaScript enabled. Make sure you have installed the correct ODBC version bit or bit , matching the software. Sign up using Email and Password. Depending on whether your philosophy is glass ‘half-full’ or ‘half-empty’, it will stop all errors from occurring, or cause one massive one. I finally downloaded and installed the 32bit version and am now able to connect to MySQL database on a remote server. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies.
| Uploader: | Kazragis |
| Date Added: | 11 January 2017 |
| File Size: | 9.53 Mb |
| Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
| Downloads: | 18757 |
| Price: | Free* [*Free Regsitration Required] |
More likely it’s the other myzql ’round, there are no significant bugs in the 5. I don’t know if it will cause any errors if you get rid of the 5. In a 64 bit environment, in a VBA excel application, i use this string, but it not work:.
Generally they don’t change to the latest thing when there’s no clear benefit, and a plethora of possible Bad Things that could happen. This is probably the most common problem people run into with ODBC drivers on bit systems.
Which connection string for MySql ODBC connector ? – Stack Overflow
Can someone help me? Sign up or log in Sign up using Google. However, the automatically created DSN’s by Sage 50 will likely still be looking for the 5.
52a have use ODBC version 5. Code Animal 91 5. I’ve never tested others so I don’t know if it will cause any errors if you get rid of the 5.
Here is a forum post describing how to do this: For those running web servers and trying to get bit ODBC drivers to work in their bit web app, make sure you enable bit applications on the application pool.
Email Required, but never shown.
Upgrading MySQL Connector/ODBC from version 5.2.4 to 5.3.8
Running side-by-side with 5. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Ridings over 1 year ago in reply to RandyW. By using our site, you acknowledge that you have odbd and understand our Cookie PolicyPrivacy Policyand our Terms of Service.
Post Your Answer Myqsl By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.
MySQL ODBC Driver Installation [Migration by Ispirer SQLWays]
Sage 50 Accounting – Canadian Edition. Make sure you have installed the correct ODBC version bit or bitmatching the software. Because you are running in a bit environment, what you do next depends on whether you are running Excel or whatever the software, web app etc.
Myslq way you can use the current version or the newer one depending on your specific needs.
From what I can tell the installed version of the connector dates ldbc to which is three years older than the installed software which is installed in They share a common code base so a common version number.
Ridings over 1 year ago. Stack Overflow works best with JavaScript enabled.
Quick Answer
In a 64 bit environment, in a VBA excel application, i use this string, but it not work: Post as a guest Name. Connectivity installation upgrade database. This makes me think there are bug fixes in the later versions of the MySQL Connector that break the current version of Sage The 64 bit definitely won’t work.
Sign up using Email and Password. Where the driver name you tried before was 5. I finally downloaded and installed the 32bit version and am now able to connect to MySQL database on a remote server.
