Anyone know how to connect to a mysql database? I'd like to be able to just
link to it or import several hundred Gig from this database into SQL Server
2K.
Any ideas?You can create a linked server from SQL Server to any ODBC or OLE DB data
source. But you need to be able to tell SQL Server what various properties
are. You can get that information from:
http://www.connectionstrings.com/
http://www.able-consulting.com/ADO_...TNativeProvider
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment