SQL Server Performance Forum – Threads Archive
Export database using OLE DB Provider
Hello, I’m trying to export a database using the ‘DTS Import/Export Wizard’, I need to use the ‘Microsoft OLE DB Provider for SQL Server’, but it does not appear on the ‘Data source’ Drop-Down list of that Wizard. What can I do to get that OLE DB Provider installed? I’m running SQL Server 2000 Personal with SP4 on a Windows XP Media Center PC and I have MSDAC 2.8 SP1 installed. I also checked that I have the file sqloledb.dll on the ‘Crogram FilesCommon FilesSystemOle db’ directory. I’ll appreciate any help. Thanks.I don’t think it is enabled in Personal edition. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>