Search
Home
Agenda
Links
Bloggers
Over PASS Nederland
       User benefits
       Geregistreerd... en dan?
       Sponsoring
Artikelen
       Cursussen en certificering
          SQL Server 2000
          SQL Server 2005
             Examenrecensies
Archief nieuwsbrieven
       2005
          Nieuwsbrief 1 / 09-10-2005
       2006
          Nieuwsbrief 2 / 16-01-2006
          Nieuwsbrief 3 / 11-03-2006
          Nieuwsbrief 4 / 11-04-2006
          Nieuwsbrief 5 / 08-05-2006
          Nieuwsbrief 6 / 18-06-2006
          Nieuwsbrief 7 / 27-08-2006
          Nieuwsbrief 8 / 20-10-2006
          Nieuwsbrief 9 / 22-12-2006
       2007
          Nieuwsbrief 10 / 04-02-2007
          Nieuwsbrief 11 / 05-03-2007
          Nieuwsbrief 12 / 02-04-2007
          Nieuwsbrief 13 / 01-05-2007
          Nieuwsbrief 14 / 01-06-2007
          Nieuwsbrief 15 / 02-09-2007
          Nieuwsbrief 16 / 04-10-2007
          Nieuwsbrief 17 / 05-11-2007
          Nieuwsbrief 18 / 06-12-2007
       2008
          Nieuwsbrief 19 / 12-01-2008
          Nieuwsbrief 20 / 14-02-2008
          Nieuwsbrief 21 / 02-05-2008
          Nieuwsbrief 22 / 16-06-2008
          Nieuwsbrief 23 / 01-08-2008
          Nieuwsbrief 24 / 13-11-2008
          Nieuwsbrief 25 / 01-12-2008
       2009
          Nieuwsbrief 26 / 07-02-2009
          Nieuwsbrief 27 / 09-03-2009
          Nieuwsbrief 28 / 01-04-2009
          Nieuwsbrief 29 / 04-06-2009
          Nieuwsbrief 30 / 02-09-2009
          Nieuwsbrief 31 / 06-10-2009
          Nieuwsbrief 32 / 07-11-2009
          Nieuwsbrief 33 / 04-12-2009
Forum

onze sponsors

microsoft_logo.gif


 

computrain_logo.JPG
Forum Login | Register
   Forum

 

Forums > Forums > DBA
Subject: OPENROWSET error
Prev Next
You are not authorized to post a reply.

Author Messages
Colin van ViegenUser is Offline

Posts:4
18-11-2008 17:16:44 Alert 
Since the upgrade from SQL 2000 to SQL 2005 we have issues with the OPENROWSET function.

All standard settings have been configured like:

- DisallowAdhocAccess registry Setting explicit to (0) for each Provider
- Enable OPENROWSET and OPENDATASOURCE support in SQL Server Service Area Configuration
- Enable Ad Hoc Distributed Queries

, but still we recieve the following error:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".


Many searchhits in Google, but none yet with the right answer.

All previous used OPENROWSET queries in our SQL2000 Server are still in use, but within a SQL2005 server they fail continuously.

Which setting are we forgetting??
for the record... There is no syntax error in the code. It works fine in a SQL2000 environment, but fails in a SQL2005 environment.

An example of the use is:

SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','C:\TEMP\273.mdb';'admin';'','SELECT * FROM Export') P


Help is welcome!!

Regards,
Colin
Vladimir EricUser is Offline

Posts:6
12-12-2008 17:04:18 Alert 
Is your linked server maybe gone with conversion?

Linked servers are not stored per database but in master database.

Try:
select * from sysservers
You are not authorized to post a reply.
Forums > Forums > DBA > OPENROWSET error


ActiveForums 3.6
  
Copyright (c) 2012 PASS Nederland   Privacy Statement  Terms Of Use