OPENROWSET to Access error

[Mahesh Hardikar]

Hi ,

I have been trying to connect to access database from SQL Server 7.0.
This machine is having 7.0 as a default instance and 2000 as a named
instance.
Also the machine doesn't have access installed and Microsoft.Jet.4.0
is of version SP8 for Windows 2000
The access database is password protected.
I have tried all, OPENROWSET, OPENDATASOURCE, linked server, and ODBC.

These are some of the commands which I have tried but gives following
error.
*******************************************
SELECT a.*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'F:\Geerimain\billing.mdb';'bhagath';'bhagath', Employee)
AS a

Server: Msg 7303, Level 16, State 2, Line 1
Could not initialize data source object of OLE DB provider
'Microsoft.Jet.OLEDB.4.0'.
[OLE/DB provider returned message: Cannot start your application. The
workgroup information file is missing or opened exclusively by another
user.]
**********************************************

SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'DataSource="F:\Geerimain\billing.mdb";
User ID=bhagath;Password=bhagath;Jet
OLEDB:SystemDatabase="c:\WINNT\system32\System.mdw "')...Employee

Server: Msg 7303, Level 16, State 2, Line 1
Could not initialize data source object of OLE DB provider
'Microsoft.Jet.OLEDB.4.0'.
[OLE/DB provider returned message: Cannot start your application. The
workgroup information file is missing or opened exclusively by another
user.]

**********************************************
SELECT *
FROM OPENROWSET('MSDASQL',
'Driver={Microsoft Access Driver
(*.mdb)};Dbq=F:\Geerimain\billing.mdb;Uid=bhagath; pwd=bhagath','SELECT
*
FROM Employee')

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified]

**********************************************

I have tried all possible combinations but most of the time I come up
with Error 7399.
In case if anyone has some other syntax and successful with that,
please let me know

Regards,
Mahesh

[Simon Hayes]

"Mahesh Hardikar" <ha*******@yahoo.com> wrote in message
news:4a**************************@posting.google.c om...

Hi ,

I have been trying to connect to access database from SQL Server 7.0.
This machine is having 7.0 as a default instance and 2000 as a named
instance.
Also the machine doesn't have access installed and Microsoft.Jet.4.0
is of version SP8 for Windows 2000
The access database is password protected.
I have tried all, OPENROWSET, OPENDATASOURCE, linked server, and ODBC.

These are some of the commands which I have tried but gives following
error.
*******************************************
SELECT a.*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'F:\Geerimain\billing.mdb';'bhagath';'bhagath', Employee)
AS a

Server: Msg 7303, Level 16, State 2, Line 1
Could not initialize data source object of OLE DB provider
'Microsoft.Jet.OLEDB.4.0'.
[OLE/DB provider returned message: Cannot start your application. The
workgroup information file is missing or opened exclusively by another
user.]
**********************************************

SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'DataSource="F:\Geerimain\billing.mdb";
User ID=bhagath;Password=bhagath;Jet
OLEDB:SystemDatabase="c:\WINNT\system32\System.mdw "')...Employee

Server: Msg 7303, Level 16, State 2, Line 1
Could not initialize data source object of OLE DB provider
'Microsoft.Jet.OLEDB.4.0'.
[OLE/DB provider returned message: Cannot start your application. The
workgroup information file is missing or opened exclusively by another
user.]

**********************************************
SELECT *
FROM OPENROWSET('MSDASQL',
'Driver={Microsoft Access Driver
(*.mdb)};Dbq=F:\Geerimain\billing.mdb;Uid=bhagath; pwd=bhagath','SELECT
*
FROM Employee')

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified]

**********************************************

I have tried all possible combinations but most of the time I come up
with Error 7399.
In case if anyone has some other syntax and successful with that,
please let me know

Regards,
Mahesh

This KB article looks like it might describe your issue:

http://support.microsoft.com/default...b;en-us;285833

Simon