Connecting Tech Pros Worldwide Forums | Help | Site Map

Openrowset and mdb -Files

Rudi
Guest
 
Posts: n/a
#1: Jul 23 '05
Hy Forum !
I tried to do somsthing like this:

CREATE PROCEDURE dbo.maches AS

select * from openrowset('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Fehler.mdb'; 'Administrator'; ' ' , Fehlerliste)


This user 'Admistrator' exists and there is no password for the .mdb
file. In the end the syntax checker tells me:

Fehler 7303: Datenquellenoblekt von OLE DB Provider
'Microsoft.Jet.OLEDB.4.0' konnte nicht initialisiert werden.

I'm using Access 2000 and SQL Server 7.

Thank you

Simon Hayes
Guest
 
Posts: n/a
#2: Jul 23 '05

re: Openrowset and mdb -Files



"Rudi" <fniedermeyer@aareon.com> wrote in message
news:5d7715e4.0501140518.52df1de6@posting.google.c om...[color=blue]
> Hy Forum !
> I tried to do somsthing like this:
>
> CREATE PROCEDURE dbo.maches AS
>
> select * from openrowset('Microsoft.Jet.OLEDB.4.0',
> 'C:\temp\Fehler.mdb'; 'Administrator'; ' ' , Fehlerliste)
>
>
> This user 'Admistrator' exists and there is no password for the .mdb
> file. In the end the syntax checker tells me:
>
> Fehler 7303: Datenquellenoblekt von OLE DB Provider
> 'Microsoft.Jet.OLEDB.4.0' konnte nicht initialisiert werden.
>
> I'm using Access 2000 and SQL Server 7.
>
> Thank you[/color]

This KB article describes one possible reason:

http://support.microsoft.com/default...b;en-us;285833

Simon


Closed Thread