MySQL Connector/ODBC 3.51 Works with Microsoft Windows Vista & 2007 Office
With both Microsoft Windows Vista and 2007 Office System (yeah, they reversed name/year to year/name) heading to production soon, it is time to start talking about which Freeware and Open Source applications will work with the new Microsoft releases.
Since I work with MySQL everyday, I'm starting with their ODBC connector. The MySQL Connector/ODBC is available for Linux, various UNIX variants, and Microsoft Windows. I installed version 3.51 (there's also a 5.0 beta release) in Windows Vista RC2 Build 5744 and tested it with 2007 Office Systems' Access and Excel. The MySQL database was running on a small Linux server on the same network. Both Access 2007 and Excel 2007 were able to read from a table in MySQL and refreshed correctly when a change was made to the MySQL database table.
Unfortunately I am still
Unfortunately I am still having more troubles with MySQL Connector 3.51 and Excel 2007.
I can connect to my linux database and I can also choose the table, but when I want to retrieve the data the ODBC Connector window pops up and from that point the import comes to an end.
I checked all the settings in the Connector window and the really strange thing was that the last number of my username was cut, but even if I add it again it quits. The connector 5.00 beta does not work at all.
Any ideas?
Thanks,
Michael
Michael: I didn't run into
Michael: I didn't run into any problems. But, here's a couple of questions/thoughts.
1. Is port 3306 on the server MySQL is hosted on open?
2. Is the MySQL server you are working with on the same LAN segment or behind a firewall (say your webhost or on a VLAN in your enterprise WAN)?
3. Do you have a firewall on your Windows PC that may be blocking either outgoing or incoming data on port 3306?
4. Did you try running the "test" when setting up the MySQL ODBC connector to your database server?
i have the same problem,
i have the same problem, when isntalling the myodbc connector i can test and conenct to the database but when trying to open the database up in access 2007 it says ODBC connector failed.
Have you solved the problem?
Have you solved the problem?
I have got the same, i can choose the table to import to execl2007 but just before finishing it says unknown table... or can't open table..
can anybody help?
Anyone got an idea?
Anyone got an idea? connection failed problem too...
Yea same issue here. ODBC
Yea same issue here. ODBC tests fine but 2007 seems to lack the driver even if you want to create it again through Office 2007.
I'll keep Googling for the solution.
I'got an issue for some
I'got an issue for some tables.
I'm testing with Windows Vista Pro and Office 2003.
According to me it cames from a date, time or number format. (Certainly date).
Keep looking for a solution.
I had the same problem. I had
I had the same problem. I had to select the database in the dropdown menu (which I didn't have to do before) for it to work.