SQL Server Performance

SQL error trying to connect

Discussion in 'General DBA Questions' started by Mr930, Nov 3, 2006.

  1. Mr930 New Member

    I have set up an ODBC connection to our SQL Server. If I use this ODBC to create linked tables in MS Access, I can edit, delete, whatever as I see fit, no trouble hitting the database at all.

    I have a SQL report writer app that uses ODBC. When I try to use the same ODBC connection I get the "server does not exist or access denied" error when I first try to create a report.

    Since I can get to the server with MS Access, it seems like I have the proper rights.

    What could cause this problem? Would MS Access have some sort of way to communicate when my other app does not?

    thanks
    Fred
  2. satya Moderator

Share This Page