Jump to content

Remote Mysql W/ Access 2010


Recommended Posts

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

 

Link to post
Share on other sites

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/

Link to post
Share on other sites

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...