Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Cannot initialize the data source object of OLE DB provider
Santhakumar Munuswamy
Aug 11 2017 10:48 AM
342
Reply
Hi all,
I am creating linked server from my SQL server 2014 for MySQL database using ODBC driver, but I am getting error
"Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MYSQL".
OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)"
Please let me know any suggestion or solution on it
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
stored procedure for conversion of percentage values
how to find missing sequence or gap in sql