469,272 Members | 1,560 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,272 developers. It's quick & easy.

Error Linking to MySQL using MyODBC 3.51

Hello,

I am trying to use a MS Access front end application to link to data
tables stored in MySQL Server. I am running MySQL 5.0 Community
Server, MySQL Connector/ODBC 3.51, and MS Access 2003. I have set up
a test database and table in MySQL, but the problem comes when trying
to link to this table through Access. From the Link Tables menu
option, I choose ODBC Databases, but no "Select Data Source" dialogue
window will pop up. All that happens is that the Link Tables window
disappears. Has anyone encountered this problem? Your help is
appreciated.

-Shane

Feb 15 '07 #1
4 2539
Hi, Shane.
Has anyone encountered this problem?
If you have Norton Antivirus installed, disable the Office Plug-in, link to
the MySQL table, then re-enable the Office Plug-in.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Jayhawk" <mc******@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...
Hello,

I am trying to use a MS Access front end application to link to data
tables stored in MySQL Server. I am running MySQL 5.0 Community
Server, MySQL Connector/ODBC 3.51, and MS Access 2003. I have set up
a test database and table in MySQL, but the problem comes when trying
to link to this table through Access. From the Link Tables menu
option, I choose ODBC Databases, but no "Select Data Source" dialogue
window will pop up. All that happens is that the Link Tables window
disappears. Has anyone encountered this problem? Your help is
appreciated.

-Shane

Feb 15 '07 #2
On Feb 15, 3:43 pm, "Jayhawk" <mccal...@gmail.comwrote:
Hello,

I am trying to use a MS Access front end application to link to data
tables stored in MySQL Server. I am running MySQL 5.0 Community
Server, MySQL Connector/ODBC 3.51, and MS Access 2003. I have set up
a test database and table in MySQL, but the problem comes when trying
to link to this table through Access. From the Link Tables menu
option, I choose ODBC Databases, but no "Select Data Source" dialogue
window will pop up. All that happens is that the Link Tables window
disappears. Has anyone encountered this problem? Your help is
appreciated.

-Shane
I don't remember the exact symptoms but I have seen cases where MySQL
ODBC 3.51 does not work on some machines, presumably due to an
incompatibility with some other piece of software. I've never had it
fail on my machines, but it did fail consistently on some client's
workstations.

The on-site IT person for one of my customers even tried to pin it
down by starting with a vanilla OS image and installing their standard
software load one application at a time. Unfortunately they never
found the answer because after they installed all of their standard
applications individually MySQL ODBC 3.51 still worked, but when they
ghosted their departmental standard image onto the same machine it
wouldn't fly. They wound up using the previous version of MySQL ODBC
(v2.50) instead. However, I'm not sure that you can use v2.50 of the
MySQL ODBC driver with MySQL 5.x.

Feb 15 '07 #3
On Feb 15, 4:28 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAMwrote:
Hi, Shane.
Has anyone encountered this problem?

If you have Norton Antivirus installed, disable the Office Plug-in, link to
the MySQL table, then re-enable the Office Plug-in.

HTH.
Gunny
Thanks Gunny,

Norton Antivirus Office Plug-in was the problem. I got the data
source window to pop up after disabling it.

-Shane
Feb 19 '07 #4
Hi, Shane.

You're welcome. Glad it's working now. Don't forget to re-enable the
Office plug-in, because you need it for scanning Office documents
automatically when opening them.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Jayhawk" <mc******@gmail.comwrote in message
news:11**********************@k78g2000cwa.googlegr oups.com...
On Feb 15, 4:28 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAMwrote:
>Hi, Shane.
Has anyone encountered this problem?

If you have Norton Antivirus installed, disable the Office Plug-in, link
to
the MySQL table, then re-enable the Office Plug-in.

HTH.
Gunny

Thanks Gunny,

Norton Antivirus Office Plug-in was the problem. I got the data
source window to pop up after disabling it.

-Shane


Feb 20 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by Mr Dygi | last post: by
2 posts views Thread by Kenneth Foli Jųrgensen | last post: by
reply views Thread by Gary Lundquest | last post: by
reply views Thread by Bill Davidson | last post: by
reply views Thread by redfez | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.