Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Ohio
    Posts
    2

    Unanswered: ODBC Call Failed when accessing ACCESS

    I have had an ODBC configuration from Pervasive.SQL 2000i to ACCESS97 running for some time now, on a network drive (NT). Now I am getting an error telling me the connection failed when I try to use it:

    [Pervasive][ODBC Client Interface][Client LNA]The ODBC Client
    Interface cannot access the data source because SQL Connection
    Manager is not running at the specified port number. Contact
    your system administrator for assistance.

    I have rebooted my server and my PC. Pervasive knowledge base says to rename my engine using a name and not an IP address. I am and have always used the name here. Don't know what else to try. Suggestions?

  2. #2
    Join Date
    Jan 2005
    Posts
    1

    Any Luck

    Did you find a resolution to the ODBC / COnnection Manager / Port issue?

    We have just started to experience the same error.

    Thanks.
    Carl.

  3. #3
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Carl,
    The "port issue" is usually a communication issue between the client and the server. Make sure that the Pervasive System Analyzer works with both the network tests and the ODBC/Relational tests. If they don't, start a new thread and post the results of the PSA tests.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

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