Results 1 to 2 of 2

Thread: ODBC DSN (2000)

  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC DSN (2000)

    I have all the tables linked to SQL Server. When I copy the access program to a different PC, no matter if the DSN are create as is in the PC where the program was created, sometimes it request a login and password..or "trustee connection" .....Exist a way to force access to use a DSN?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ODBC DSN (2000)

    What kind of DSN did you create, file, system, what? What kind of authentication did you select for SQL Server in the DSN? The nature of SQL Server is that it always requires a login or a trusted connection, and you still have to make that trusted connection on the other machine, just adding a DSN isn't enough. If you give us more details on your setup and specifics on the problem, someone can help you.
    Charlotte

Posting Permissions

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