Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PollyMorph
Starting Member
5 Posts |
 Posted - 2008-08-05 : 08:14:58
|
| Hi all,I am having a problem with the Openrowset functionality in SQL 2005.If I use the functionality on my local machine example:SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\DemoExcel.xls','SELECT * FROM [Sheet1$]')It works fine.If I use this functionality on the test server, it works perfectly.If I use it on the live server, it does not work.I have read that a couple of people have had a similar problem but without a fix. Is there a problem with 'Microsoft.Jet.OLEDB.4.0'? Or is there a couple of other things I can try to get this to work?Please can someone assist?Thanks,Polly. |
|
|
PollyMorph
Starting Member
5 Posts |
Posted - 2008-08-05 : 10:13:26
|
| I have also checked that all needed services are enabled.EXEC sp_configure 'Ad Hoc Distributed Queries', '1';I still get the following error when running the simple select:Script:-------SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\DemoExcel.xls','SELECT * FROM [Sheet1$]')Message:---------OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". |
 |
|
|
|
|
|
OPENROWSET Problem