Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2005
    Posts
    16

    Unanswered: Odd Pervasive.sql Error

    I have an odbc connection setup for my pervasive.sql database and it tests ok., When I open the Pervasive Control Center I can view a list of all the tables but if I try to open one of them I get the following error:

    ODBC Error: SQLSTATE = S1000, Native error code = 0
    Unable to open table: AP Current Distrib.
    No such table or object.

    In addition, if I try to open an asp page that accesses the db it gives the following error.

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
    [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Unable to open table: PM Occupant Info.
    /SysAdmin/adminC.asp, line 13


    The db works fine on another server. So it has to have something to do with the configuration. Any ideas?

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    It might be a configuration issue if the database has paths in the DDFs. Issue a "select * From x$file" and look at the xf$loc for the table(s) in question. If there is only a filename, make sure the file with that name is in the same directory as the DDFs. If it's got a path with the name, make sure the file exists in the path.
    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.

  3. #3
    Join Date
    Dec 2005
    Posts
    16
    I checked and there are not any paths. I use the same ddfs for the other db that works, so I doubt that is the issue. I think it must have something to do with how I have the ODBC setup.

    Any other ideas on what would cause this error?

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    It might have to do with the way the DBname is set up but the ODBC driver just points to the DBName.

    What happens if you copy the DDFs/Data file to another location on this box, create a new DBName/DSN pointing to the copy? Does it give the same error?
    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.

  5. #5
    Join Date
    Dec 2005
    Posts
    16
    Yes I get the same error with that test.

  6. #6
    Join Date
    Dec 2005
    Posts
    16
    Thanks for your help.

    Any other ideas are welcome. I don't know what else to try.

  7. #7
    Join Date
    Dec 2005
    Posts
    16
    Any other ideas?

Posting Permissions

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