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('Mic rosoft.Jet.OLED B.4.0',
'F:\Geerimain\b illing.mdb';'bh agath';'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\bill ing.mdb";
User ID=bhagath;Pass word=bhagath;Je t
OLEDB:SystemDat abase="c:\WINNT \system32\Syste m.mdw"')...Empl oyee
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('MSD ASQL',
'Driver={Micros oft Access Driver
(*.mdb)};Dbq=F: \Geerimain\bill ing.mdb;Uid=bha gath;pwd=bhagat h','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
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('Mic rosoft.Jet.OLED B.4.0',
'F:\Geerimain\b illing.mdb';'bh agath';'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\bill ing.mdb";
User ID=bhagath;Pass word=bhagath;Je t
OLEDB:SystemDat abase="c:\WINNT \system32\Syste m.mdw"')...Empl oyee
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('MSD ASQL',
'Driver={Micros oft Access Driver
(*.mdb)};Dbq=F: \Geerimain\bill ing.mdb;Uid=bha gath;pwd=bhagat h','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
Comment