August 1, 2005 at 2:31 pm
In Enterprise Manager in the DTS wizard and also in the DTS package themselves I am missing some of the data sources. For example Microsoft Access and Microsoft Excel. I have recently installed SQL 2000 SP4 server on a Windows XP machine SP2. My MDAC is version 2.8.
When I run the following.
USE MASTER
GO
xp_enum_oledb_providers
GO
I don't have Microsoft.Jet.OLEDB.4.0 - Microsoft Jet 4.0 OLE DB Provider
as an option. I have tried installing the latest Jet driver but it says XP has it already installed.
How do I make the data source connections available? What else can I check?
August 4, 2005 at 8:00 am
This was removed by the editor as SPAM
August 4, 2005 at 10:43 am
You might try, if you can, removing and reinstalling the client tools. I'm sure something got mucked up in the install. My XP SP2 worked fine with SP4, but I have seen workstation installs that sometimes get corrupted.
And let us know if you figure it out, this is a good one.
July 25, 2006 at 8:13 am
I finally found the solution.
Need to re-register the following dll's.
cd /d %windir%\system32
regsvr32 msjetoledb40.dll
regsvr32 msjet40.dll
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply