Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Unanswered: Connecting Access from MS SQL 7.0

    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 OLEDBystemDatabase="c:\WINNT\system32\System.mdw"')...E mployee

    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 or 7303
    In case if anyone has some other syntax and successful with that, please let me know

    Regards
    Jay

  2. #2
    Join Date
    Jul 2004
    Posts
    23
    Daft answer but... do you have any other way of confirming that you can open an Access database on that machine? Could be that SQL is just showing a general problem. Is MDAC installed?

  3. #3
    Join Date
    Mar 2004
    Posts
    18
    I have copied the mdb file on my machine and have Access installed.
    I can open the access application using the username and password specified here.
    Yes MDAC is installed, but which version can't say.
    Can you tell me how to find that ..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •