> Hello Folks,
> i use MSDE to collect data from a Access-Databases.
> I'f got the following SELECT-Statement from this newsgroup
> yesterday:
>
> SELECT count(*)
> FROM OPENDATASOURCE(
> 'Microsoft.Jet.OLEDB.4.0',
> 'Data Source=C:\\TEMP\\FLS.mdb;
> User ID=Admin;Password=\'\'')...FLSA
>
> It looks like the solution of my problem, but ...
> when i send this statement to MSDE I get this error message
>
> "OleDbException: es konnte keine Instanz des OLE DB
> Providers 'Microsoft.Jet.OLEDB.4.0' erstellt werden"
>
> translate from german
> "OleDbException: Impossible to create a instance of
> OLE DB Provider 'Microsoft.Jet.OLEDB.4.0'"
>
> Is it possible to run this statement on MSDE?
> if Yes - what could be the reason for the error?
>
> Thanks in advance for your help.
> Niels