Can't access database

 I have new computer for windows 7 64 bit. i want to install Accpac 100ERP 5.4A (this is free update version) to this new computer. i perchased database pervasive v10 for workgroup edition (because ther are 2 computer will use accpac).

i install pervasive ver10 first, then put activate code on license administraor to replace expired code that let me try for 30 days. i put 2 new fold under database folder that relate accpac. I install pervasive under C driver.

next i install accpac system manager, then do database setup. then install lanPak. i install accpac under C driver.

when i open accpac system manager, it shows following message:

administrative service is not active for this system daatbase. create adminstrative service data?  Yes proceed

then shows: pervasive license is invalid or has expire. Can't access database (error=96)

i think accpac may find out first pervasive code that has been expire but it can't find the new code OR MAY BE OTHER PROBLEM what can i do?

pervasive already has new perminent code and old code has beed deactive.

 

 

 

 

  • Accpac 5.4 is not compatible with Windows 7 64 bit.  Try installing it in XP mode, or better yet, use XP from the beginning.

  • I take that back, 5.4 is supposedly supported.  Make sure you don't install to the default Windows 7 Programs folder.

  •  Pervasive V10 and accpac 5.4a both of them install under C driver. how come accpac can't access database??

  •  What's the meaning error 96? how to fix it? Does anybody knows?

  • Accpac 54A, but which service pack of System Manager?  It should be SP3.

  • I've been using Accpac and Pervasive for 12 years and have never seen Error=96, so there's a clue that this isn't normal.  Just a guess, you may have to create the ODBC DSN's using the 32-bit version of ODBCAD32 in C:\Windows\Syswow32, not the standard one in Control Panel.

  •  i haven't update to sp3 but i think the problem may be as follow:

    i first install pervasive V10 try version under the program folder (on default folder), after one month i uninstall pervasive, then install try version again, then uninstall, next step is install under C driver and purchase the code. I think accpac may be go to grogram files folder to  find pervasive first when i run accpac system manager. If registration number didn't deleted when i do uninstall pervasive. as a result, the message shows pervasive has expire.

    How to fix it if the problem like this?  Thanks

  • No, Accpac doesn't "go to grogram files folder to find pervasive first". 

    Run the Pervasive License Administrator Utility to see if you have valid licenses.

  •  pervasive licenses is permanet when i check pervasive license administrator utility.

    I try to run sample company ltd. on the accpac system manager. it shows error 2. what is the meaning error 2? because i have install gl, ap,ar and sample company can't run?

  • Error 2 means you haven't created the DSNs in Pervasive Control Center.

  •  Heri is the problem.

    I install pervasive then install accpac system manager lan-pack. next step i go to pervasive control cnetre, under the database, highlight new and open the database, then enter the dbase name and location,click finish. next message asks enter the adminstration name and password on the box, but i dind't put name and pw on it. just click cancle. this is why accpac can't link dbase pervasive.

    The question is where can find the administration name and password? i think i didn't setup any pass word on this computer.  Thanks

  • Sounds like you don't have full permissions to whatever the path to the database is.  Exactly what is the path?

  • C:\pervasive\psql\

    C:\sage software\sege accpac\

    on the pervasive control centre ...  database name I put accpac database id "hansys" and location i put  "C:\sage software\sege accpac\"

    do you think it is correction or location i should put C:\pervasive\psql\?

  • It should be in C:\sage software\sege accpac\HANSYS

  • on the version 5.3 the program path like this: program files\accpac\data\hansys  under the data there are 2 folders hansys and handat

    but if you put it like C:\sage software\sege accpac\HANSYS  how can you open sample company data? as sample company data is not locate Hansys or handat.

    but i can try it. the question how can i chang this database? delete it then create new one?

     

  • If you want to access sample company data, then you're creating SAMINC and SAMSYS in Pervasive Control center, going to C:\sage software\sege accpac\SAMINC and C:\sage software\sege accpac\SAMSYS, or wherever the two folders are.

  •  first, i creat 2 folders hansys and handat under the folder data: C:\sege software\sege accpac\data\hansys

    Second, i delete pervasive control centre under the folder database :hansys and handat

    Third, i will creat 2new folders under the pervasive control database

    Fourth, i will put location as C:\sege software\sege accpac\data\hansys

    do you think it correct?

  • No.  You need two separate folders, and two names in Pervasive.

  •  Yes, i create two separate folders, and two names in Pervasive.

    BUT it doesn't work. i think i didn't do any thing for accpac sample company but how come it doesn't work too. i mean the problem doesn't related "path". please read my first compose, you may find where is the problem. Thanks

  • Then forget about all the PATHs.  Have you asked your Accpac reseller to assist you?  I'm sure someone with technical skills could sort this out in a few minutes.

  •  thank you for the help. i will ask consultant to fix this problem but fee is very expensive.

  •  Hi Jay,

    i find out the problem, but don't know how to fix it.

    i use my way to install pervasive (try version with 30 days) and accpac on another computer B. it is working.

    I think my computer doesn't work because accpac only recoganize the aleady expire code(over 30 days for try version) for pervasive, accpac can't find the permanent code that i aleady put in the computer. 

    Do you know how let accpac know pervasive permanent code?  Thanks 

  • Accpac doesn't know anything about Pervasive licenses, it either works or it doesn't.  I told you before to check the Pervasive licenses with its utility.  Was that OK or not?

  • pervasive licenses with its utility is OK. it shows no expire which i purchase the software code.

  • Then Pervasive licenses are not your problem. 

    Considering that you're installing an old version of Accpac that may not be properly service packed for this version of Windows, you need to contact someone with training and technical skills who can look at it.