Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Unanswered: can't seem to access database !!

    Hi,

    I've got a database that I connect to using odbc and
    want to check the connection using the control center
    when I open a table or even the ddf files I get an error
    odbc error:sqlstate = S1000,native error code = 0
    unable to open table : ......
    The Microkernel cannot find the speified file(Btriev Error 12)

    Al the ddf files and btriev files are in the same dirrectory
    A0001 and the btrieve file is A001_01
    when I use the function executer I have to enter the user ea 03
    and the I can connect to the btrieve file ok

    But when I go to task \ edit table disign I cannot see the fields of
    the file location

    Can Enyone tell me what I'm forgetting or doing wrong

    Kind Regards
    Kevin

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Open the X$FILE table and look at the XF$LOC field for the table in question. Does it show just the file name? If not, then the data file needs to be in a directory other than the directory where the data file is located.
    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
    Aug 2004
    Posts
    2
    THe problem is I can't open the ddf files they give the same error as the
    tables has this something to do with user.ddf
    in the dir of the database I have only got the
    file.ddf field.ddf and the user.ddf but no index.ddf

    in the control center i get all the tables and the
    file.ddf index.ddf and the field.ddf

    but I cannot open the tables nor the ddf files

    Kevin

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    In that case, I would verify the path of the database name itself. You can right click on the "Configuration" node and select "Maintain Named Databases". Then you'll want to find the one you're using and verify that it's pointing to the right path for the DDFs and the data files.
    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
    Aug 2004
    Posts
    5

    Unhappy We get the same problem and have to restart Pervasive Services?

    We get the same error, resarting the services cures it for a short time before it happens again. I have checked our X$File when this happens - its empty? so are all the other system files. I tried deleting the database and re-creating this made no difference. Resarting the services is all we can do. Why would this happen every so often.

  6. #6
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    I've never seen that behavior. What's in the PVSW.LOG file?
    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.

  7. #7
    Join Date
    Aug 2004
    Posts
    5

    Unhappy X$FILE empty - PCSW.Log

    The log shows no indication of problems. Do I need to set Pervasive to log specific errors?

  8. #8
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    No, it should log issues automatically. Is there anything in the Event Log?
    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.

  9. #9
    Join Date
    Oct 2004
    Posts
    1

    Can't access database via ODBC - X$File, X$Field and X$Index empty

    Quote Originally Posted by mirtheil
    No, it should log issues automatically. Is there anything in the Event Log?
    I've had the same problem where X$File, X$Field and X$Index tables are all empty. I've verified the "Maintain Named Databases" as you suggested and checked the pvsw.log & event log and all seems ok. The only solution was to restart the services. Can you throw some light onto why this is happening, and what I can do to prevent it from happening again?

Posting Permissions

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