Bala_SSRS


Hi All,

I am getting the below error while executing the opendatasource statement

SELECT ParamName, ParamDate,ParamNumber,ParamChar

FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

'Data Source= c:\testcmd\misc\CSTARIntegrationParameters.xls;Extended properties=Excel 8.0')...[CSTARIntegrationParameters$]

Error :

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

Enviromnet :

Windows 2003 64 bit with SP1 and sql 2005 installed.

Same code is executing fine in my local machine which is XP 32 bit.

Can some one help me in resolving this issue.

Also when I tried to check the providers by expanding the linked servers node in the SQL server management studio . i couldnt found the provider for jet.

Regards,




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

Matt Neerincx


64-bit SQL Server cannot use Jet, there is no 64-bit OLEDB provider for Jet.
Currently there is no plan to write one either, but this could change based on demand.





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

Bala_SSRS

Hi,

Is there is any work around so that I can still import spreadsheets on my 64 bit server using opendatasource method.

thanks again

regards






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

Matt Neerincx

As far as I know, there are no workarounds short of running a 32-bit instance of SQL 2005 on the machine, but I'll double check with the DQ folks and let you know shortly.




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

Matt Neerincx

I found this -> http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine

The Jet Database Engine will remain 32-bit only for the forseeable future. Microsoft has no plans to natively support Jet under 64-bit versions of Windows. This means that native 64-bit applications (such as the 64-bit versions of SQL Server) cannot access data stored in MDB files through ODBC, OLE DB, or any other means, except through 32-bit software Access database from SQL 2005/64).

Check out this link ->

http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html

This is the best solution I have found thus far.