var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Linking to MYSQL from MSSQL
I am having problems setting linking to a MYSQL from MSSQL (both installed on same machine).
I can connect to a MySQL database (called 'test') via the command line MYSQL and also with the MySQL Control Centre.
I have MyODBC with the following data:
DSN Name: MYSQLDSN
Description: MySQL ODBC 3.51 Driver DSN
Clicking "test data source" indicates that the datasource works okay.
Now, in MSSQL Enterprise I try to create a linked server. I select:
Microsoft OLE DB Provider for ODBC Drivers
1) I am assuming that this will work with MyODBC
I enter a Provider String of:
2) What am I missing here?
When I click on my linked server I get:
"Error 7399: OLE DB provider 'MSDASQL' reported and error. The provider did not give any information about the error."
Many thanks for any suggestions getting MSSQL to Link with MYSQL