I am getting the below error while executing the opendatasource statement
'Data Source= c:\testcmd\misc\CSTARIntegrationParameters.xls;Extended properties=Excel 8.0')...[CSTARIntegrationParameters$]
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered
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.