Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC driver for MySQL

Status
Not open for further replies.
lenora2010

lenora2010

Programmer
May 27, 2010
1
US

I just installed SQL Server 2008 R2. I added mysql-connector-odbc-5.1.6-win32.msi to connect to MySQL database. But is not working. Please help – what driver can be used ?
- add/remove tables for DATA Source Views is giving me an error: 42000 MySQL ODBC 5.1 Driver You have an error in your SQL syntax
- add ADO.NET – when select data access mode (table or view) is giving the same error. SQL command mode is OK.
 
Status
Not open for further replies.

Similar threads

RRinTetons
  • Locked
  • Question
Tool for job scheduling
Replies
0
Views
148
RRinTetons
RRinTetons
mrmovie
  • Locked
  • Question
ODBC connection, or other from Linus system using AD account details 2
Replies
2
Views
98
mrmovie
mrmovie
Richard Parry
  • Locked
  • Question
Server to Server VPN for SQL Traffic
Replies
2
Views
80
Richard Parry
Richard Parry
bordway
  • Locked
  • Question
ODBC for remote clients MS SQL
Replies
0
Views
49
bordway
bordway
TheBugSlayer
  • Locked
  • Question
What causer the "[Microsoft][ODBC SQL Server Driver]Communication link failure" error?
Replies
2
Views
220
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top