#1

sql server import using odbc driver and mysql database

in Here is your first Forum Sat Nov 25, 2017 4:39 pm
by breckjensen • 159 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.

ADDITIONAL INFORMATION:

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)

BUTTONS:

OK

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.
References
https://social.technet.microsoft.com/For...grationservices
product marketing ads

Scroll up


Visitors
0 Members and 6 Guests are online.

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