Re: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Great article, thanks for sharing it Russell.

I just tried installing the new driver, and found it doesn't help me import from Access, so I guess something is still missing like the asam driver issue in the article. I guess I'm really confused about the 64 bit OLEDB driver I just downloaded and installed. If it doesn't allow me to import from an Access db, what does it do? I'm no better off before I downloaded it.

I got my import to work, but using what I consider a kludge (thanks MS) approach. I created a new SSIS project and changed the Run64BitRuntime property to false. I then saved my SSIS package to SQL and changed the job step from SSIS to Operating System type. I then used the dtexecui to capture the command line exec. In the job step, I then had to reference the 32 bit ssis executable prior to the command line exec - like this:
C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe /SQL "\MySSISPackage" /SERVER "MyServer" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING N

IMHO, this is a huge freaking kludge, and I'm very disappointed that I have a brand new quad-core box with gobs of ram and HD space on it, running a 64 bit OS and 64 bit SQL...and I have to junk up my server with a kludge such as this just to get it to do what it used to do with a 32 bit OS/SQL no problem. Something seems wrong there. If MS wants us to adopt their latest technologies, which I'm a huge proponent of by the way, they need to make their latest technology work. I've seen other posts here as well as a lot of places on the Internet with people who are just as disappointed as I am too, so I know I'm not the only one.

Andre


.

Relevant Pages

  • Re: Windows CD cant find my hard drives.
    ... Two of them are in a RAID 0 array. ... To quit setup without installing Windows XP, ... driver floppy, it offered a selection of drivers for the RAID. ...
    (microsoft.public.windowsxp.general)
  • Re: Explorer slow to find drives after Cameras installed
    ... Knowing that svchost.exe was the bug, as WIA is started from this, I seached ... This post hinted at a conflict or driver error of a device. ... After installing this ... The registry has been restored to its previous state before cleaning ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: No Sound on IBM ThinkPad T42
    ... The Control Panel for "Sounds and Audio Devices" shows no playback ... "Sound, video and game controllers": ... I figured that all I need to do is re-install my sound card driver. ... I'm not the only person having problems installing SoundMAX ...
    (microsoft.public.windowsxp.general)
  • Re: No Sound on IBM ThinkPad T42
    ... Sound was working fine for the last year until a Windows ... The Control Panel for "Sounds and Audio Devices" shows no playback devices ... I figured that all I need to do is re-install my sound card driver. ... I'm not the only person having problems installing SoundMAX ...
    (microsoft.public.windowsxp.general)
  • RE: Webcam installation problem
    ... I did what you advised me to do apart from installing the driver that is not ... available (the link you provided is not the producer of the camera). ... My laptop was bought in Italy while I bought the camera in the UK but I ...
    (microsoft.public.windowsxp.help_and_support)