sql server import using odbc driver and mysql database

in Here is your first Forum Sat Nov 25, 2017 4:39 pm
by breckjensen • 155 Posts

im trying to import my mysql database into sql server. i use the odbc driver to access the odbc dns i have in windows.

i am using the native client of sql server as the destinateion.

both source and destinate are on my localhost.

i get some errors regarding the datatype date. in my source it puts the value 23 as the datatype so i edit the mapping to be of type date.

once i do this for all columns of type date in the database i hit continue and i get errors that look like this:

TITLE: SQL Server Import and Export Wizard

The preview data could not be retrieved.


ERROR [42000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.20-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"district"' at line 1 (myodbc5w.dll)



i do not know how to fix this. it comes up for all tables.

Please help....

I didn't find the right solution from the Internet.
product marketing ads

Scroll up

0 Members and 4 Guests are online.

We welcome our newest member: breckjensen
Board Statistics
The forum has 168 topics and 859 posts.