Export Database using OLE DB Provider

Last Post 28 Jun 2006 01:18 PM by wintergrave. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

28 Jun 2006 10:16 AM

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 'C:\Program Files\Common Files\System\Ole db' directory.

I'll appreciate any help.

New Member
New Member

28 Jun 2006 01:18 PM
Thanks for your answer.

It does work on other computers, what I'm trying to do is to set up my computer correctly.

I have uninstalled and installed SQL Server severaltimes, I also tried unregistering and registering the dll using regsvr32.

I need it to work on my computer so I don't have to depend on someone else's computer.

Acceptable Use Policy