I want to create a DTS to import data from a MySQL db does anybody know how? It looks like SQL server 2000 doesn't support MySQL. At least I can't find any drivers to do so. I do have sp2 installed. I looked on MySQL.com and couldn't find anything either. Can anyone offer any suggestions?
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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access MySQL db
- Thread starter riarc
- Start date
tlbroadbent
MIS
Have you tried the MyODBC driver of MySQL? You should be able to download it from the MySQL website.
Also check the following link from Microsoft Technet.
Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Also check the following link from Microsoft Technet.
Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question