[Microsoft][ODBC Microsoft Access Driver] Unknown error duri

Problems with the Windows version of XAMPP, questions, comments, and anything related.

[Microsoft][ODBC Microsoft Access Driver] Unknown error duri

Postby 023481 » 19. December 2007 03:55

Hello everyone,

I am running Access 2007 and MySQL from an XAMPP install and using the MySQL Migration Toolkit and am attempting to import a Access2003 mdb file into MySQL. I have the toolkit set up correctly and am able to go through the whole process without errors, but when I viewed the database on MySQL I found that all of the tables and fields were correct, but no data entries had been ported over. I reviewed the log and found this error whenever a SQL statement like "Select *" was run:

[Microsoft][ODBC Microsoft Access Driver] Unknown

I downloaded the latest MDAC and have the ODBC drivers for Access. Is this my problem and they aren't compatible with older access database files?

Thank you for help in advance before I run out of hair to pull.
023481
 
Posts: 2
Joined: 19. December 2007 02:45

Postby Izzy » 19. December 2007 04:34

Is this thread of any help?

http://community.apachefriends.org/f/viewtopic.php?p=109609


===========================================
1. The new DeskTopXampp Launch Control for XAMPP / XAMPPlite
Posted by Ridgewood available from Ridgewood'sDTX web site

2. Build Rich AJAX Applications - Faster
TIBCO General Interface Pro Edition but FREE and Open Source
Fully working with NO donations required to get a user/password
===========================================
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby 023481 » 19. December 2007 04:53



Thanks for the reply, that thread seems to be geared for having problems with ODBC connecting to MySQL where I seem to be having problems with the Access ODBC driver and unsure if has something to do with having Access 2007.
023481
 
Posts: 2
Joined: 19. December 2007 02:45


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 73 guests