Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Microsoft.Jet.OLEDB.4.0 - Error

 
   Database Help (Home) -> Programming RSS
Next:  A small puzzle  
Author Message
Grzegorz Niemiec

External


Since: Sep 22, 2006
Posts: 1



(Msg. 1) Posted: Fri Sep 22, 2006 4:43 pm
Post subject: Microsoft.Jet.OLEDB.4.0 - Error
Archived from groups: microsoft>public>sqlserver>programming (more info?)

Hi,

I am using SQL Server 2005 (SP1) on Windows Server 2003 EE (SP1).
I get following error while accessing Excel or Text file data sources with
OPENROWSET or OpenDataSource and Microsoft.Jet.OLEDB.4.0:

From SQLAgent Job Log file:
Cannot initialize the data source object of OLE DB provider
"Microsoft.Jet.OLEDB.4.0" for linked server "(null)". [SQLSTATE 42000]
(Error 7303) OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server
"(null)" returned message "Unspecified error". [SQLSTATE 01000] (Error 7412)


From SQL Server Management Studio:
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)".


All this works fine on:
- SQL Server 2000, Windows Server 2003 EE
- SQL Server 2000, Windows XP Professional (SP2)
- SQL Server 2005, Windows XP Professional (SP2)

What is more it worked fine in my current configuration i.e. SQL Server
2005 (SP1) on Windows Server 2003 (SP1) until recent restart. No updates
were instaled during restart! This was just because of some expected power
cut off.

SQL Server service is running as Domain Admin.
Domain Admin is logged to the server.
I am trying to execute the query as Domain Admin and Local Admin.
EVERYONE has full rights to the file I want to access.

SQL Server "Ad Hoc Distributed Queries" option is set to 1
DisallowAdHocAccess registry entry is set to 0


NO MORE IDEAS!!!

Does Anyone know the solution?

Regards,
Grzegorz Niemiec

 >> Stay informed about: Microsoft.Jet.OLEDB.4.0 - Error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
OLEDB HResult error reference? - Where is reference for the HRESULT error codes that SQL Server generates, when communicating with it over ADO? For example: 0x80040E14 Breaking this HRESULT down you get: Severity: 1 (SEVERITY_ERROR) Facility: 4 (FACILITY_ITF) Code: 3604..

Error with Microsoft.SqlServer.BatchParser - Hi I am very new to using the CLR in SQL Server programming. I am trying to register the Microsoft.SqlServer.Smo.dll assembly. Below is the code: CREATE assembly [Microsoft.SqlServer.Smo] FROM 'C:\Program Files\Microsoft SQL ..

problem using oledb + informix - Hi all. I have a problem writing a table on informix (IDS 10.0) using a linked server on SqlServer Express: This is the insert: INSERT INTO unixdb1.practor.informix.ven_rilcld (rilcld_rilcld,rilcld_entazi, rilcld_numter, rilcld_codbar, rilcld_qta, ..

openrowset and jet.oledb - Please help, since the introduction of SQL2005 the default mode for opening access mdb databases with Openrowset appears to be in exclusive open mode I wish to open the database in share mode so the other (non net) ADO threads can open the database at....

Need a deadly row lock through oledb - Hi, I might have asked this before, but since SQL 2005 was there, MS strongly modified locking in favor of scalability. I never got an answer that solved the problem. I have an app that really needs to lock a certain row to be locked so that other..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]