Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    7

    Question Unanswered: SQL 7 Link to MS Access

    I am working from within an SQL database trying to get data from an MS Access Database as a linked server. I can "successfully" add the linked server, but when I try to open it from SQL EM I get "Error 7399. . . " from Microsoft Jet. When I try to query it from QA I get "Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. [OLE/DB provider returned message: Not a valid account name or password.]"

    I tried both Access 2000 databases and '97. Same results for each. Big project pending . . . any help is appreciated!

    JB

  2. #2
    Join Date
    Sep 2003
    Location
    United States
    Posts
    65
    Provided Answers: 1
    use ODBC connectivity, b'cos i could connect and browse the tables in the access database throught EM. I used ODBC(System DSN)
    >>
    >> Learn PHP/MySQL for free https://www.youtube.com/watch?v=mpQts3ezPVg
    >> Free Web Hosting with PHP, MySQL, Website Builder : http://www.000webhost.com/862861.html

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    99% of the time, this problem is caused by either:

    A filename for the MDB file that the server can't resolve. You need to specify file names from the server's perspective, so c:\myMDB.mdb had better be on the server's C: drive, not your workstations!

    A permission problem. If the server starts as (localsystem), it can't see anything but the machine that it runs on, no other machines are visible to that NT login.

    -PatP

  4. #4
    Join Date
    Oct 2003
    Posts
    7

    Still thrashing this about

    The advice you both have given has been helpful - but still no success.

    XP and 2000 servers are not having this problem (and don't need the ODBC connection). Our primary NT data server has permissions throughout the network, but won't connect properly to outside databases. We can connect from other servers to this NT server and query the data, but not vise-versa. This holds true for querying both SQL tables and MS Access.

    Using gvphubli's comments, our best success has been that we can see the tables through EM via the ODBC connection, but Query Analyzer still gives "invalid Schema" error--can't see into the tables.

    Any thoughts?

    JB

Posting Permissions

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