ODBC problems when joining Access table to linked

Results 1 to 1 of 1

Thread: ODBC problems when joining Access table to linked

  1. #1
    Join Date
    Dec 1969
    Posts
    672

    Default ODBC problems when joining Access table to linked

    I use a DSN to open a connection to an Access database. I then execute a SQL statement that joins a table in the Access database to a linked table. This linked table is via DSN to MS SQL Server. I receive an &#039ODBC-connection failed&#039 error on the second DSN when executing the SQL statement.I can properly select from either DSN by themselves, and I can execute the orginal statement if the SQL table has been imported instead of linked via DSN.I have seen references to this problem, but am in need of a resolution.TIA,Jay
    ________
    BLACK GIRL
    Last edited by Jay; 04-16-2011 at 01:24 AM.

Posting Permissions

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