November 7, 2005 at 8:34 am
I am trying to link my sql server to a mysql remote server,however when i try to pull up any tables i get the error message "7399 ole db provider 'Msdasql'reported an error.
data source name not found,and no default driver found.
I had it working with the same connection string in a previous link,so at this point i'm just frustrated.any suggestions would be helpful,thanx.
November 7, 2005 at 10:29 am
Take a look at this KB article:
http://support.microsoft.com/kb/306212
Though the error that you are getting seems to indicate that the ODBC DSN connection itself is not working. Did you create it as a SYSTEM DSN ? If the DSN connects fine and if it is a system DSN, then take a look at the KB above and see if that helps.
November 7, 2005 at 2:14 pm
thanks for the help, at this point i may just switch to writing a series of dts and active x scripts
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply