jnull Posted July 13, 2013 Share Posted July 13, 2013 HI have had TCH support looking this over and they confirm that my remote mysql ip settings are ok but cannot provide any help as to why I cannot connect via Access 2010. Here are my steps - any help appreciated. 1. Create a new blank database 2. Select External Data 3. Select ODBC database 4. Link to the data source 5. Select Machine Data Source tab 6. Select New 7. Select SQL driver 8. Name = Authuser MySQL 9. Description = Online Login Credentials 10. Server = serverIP 11. Next 12. Select With SQL Authentication 13. Login Id = usernameof dB 14. Password = passwordof dB Quote Link to comment Share on other sites More sharing options...
TCH-Dick Posted July 13, 2013 Share Posted July 13, 2013 It has been a long time since I have used Access and I may be reading your post wrong, however one thing does stand out to me that needs to be checked. You stated in step 7 to select "SQL" driver, but you should be selecting the "MySQL" driver. If you haven't installed the OBDC driver for MySQL, you can get the last connector at http://dev.mysql.com/downloads/connector/odbc/ Quote Link to comment Share on other sites More sharing options...
jnull Posted July 13, 2013 Author Share Posted July 13, 2013 Thanx Dick ... I've used the connector that comes w/ Access and the one that you reference in your link and both have failed with same error. And, this is also with firewall turned off. Quote Link to comment Share on other sites More sharing options...
jnull Posted July 15, 2013 Author Share Posted July 15, 2013 My client is pretty set on leaving TCH hosting without a resolution to this issue. So far no responses on this ... any help appreciated. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.