Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    Join Date
    Nov 2008
    Posts
    8

    Angry Unanswered: How to access DacEasy v10 data

    DacEasy v10 connects to it's data through Pervasive SQL 2000 Workstation (W3DBSMGR.EXE). In order to create System DSN i need PSQL 2000 Engine which I don't have, because it's not supported anymore. It doesn't matter what I'm using, because I'll use anything just to connect to bloody thing.

    Is there anyone with enough patience to explain to me how to achieve this?
    Is there any way for me to use existing files in DacEasy folder?

    Please help,
    Nikola

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    If you can still use DacEasy, then the PSQL engine is still running and still accessing data.
    In order to create a SystenDSN, you need the Pervasive ODBC driver, the data files, and DDF files (FILE.DDF, FIELD.DDF, INDEX.DDF).

    Do you have a Pervasive ODBC driver installed? If so, what have you tried and what errors have you seen?

    Before I give steps, I need to know where you stand and what you've tried and what behavior you're seeing.
    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
    Nov 2008
    Posts
    8
    I only have DDF files and DacEasy v10 Demo downloaded from :
    http://www.infocenter.com.hk/daceasy...dac10trial.exe

    That's it. I can't find ODBC driver for Pervasive SQL 2000, and I know that DacEasy uses Pervasive WorkStation 2000 Engine, which I don't see in my list of ODBC providers. I tried to install Pervasive SQL Client Engine v10, but then DacEasy didn't work. That's about it...

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    The ODBC driver name for PSQL 2000 is "Pervasive ODBC Engine Interface" or "Pervasive ODBC Client Interface".
    What OS are you running on? I'm not sure if DacEasy installs a full engine or just the Btrieve portion. To find out, check the PVSW\BIN directory for W3ODBCEI.DLL. If it exists, then you've got the driver.
    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
    Nov 2008
    Posts
    8
    I'm using Windows XP. There is no PVSW folder, there's only W3DBSMGR.EXE in DacEasy folder, which starts every time you start DacEasy. I tried to create a reference to that file, but wasn't able to do so.

    There are following dll files in the same folder, none of wich I could register with RegSvr32, every time it says the file was loaded, but the DllRegisterServer entry point wasn't found, so they are useless.

    ap95conv.dll
    btrvc.dll
    BtrvUtil.dll
    clib.dll
    Dea-1.dll
    Dea-2.dll
    Dea-3.dll
    Dea-4.dll
    Dea-5.dll
    Dea-6.dll
    deabase.dll
    DEAOffi.dll
    deascrns.dll
    defreg.dll
    dehlpmnu.dll
    deimgs.dll
    DEOffice.dll
    derv20.dll
    detslink.dll
    dewreg.dll
    hlp25632.dll
    Implode.dll
    NTUCMEN.DLL
    NTUCMGR.DLL
    w32rbld.dll
    W32ucren.dll
    W3AIF104.DLL
    W3BIF109.DLL
    W3BTRV7.DLL
    w3comsrv.dll
    W3CRS109.DLL
    W3DBAV75.DLL
    W3DBNV7.DLL
    W3MIF10F.DLL
    w3mkde.dll
    W3MKDERC.DLL
    W3NSL10A.DLL
    W3NSR104.DLL
    W3SCMV7.DLL
    W3SQLV7.DLL
    W3UPI103.DLL
    W3upi204.dll
    WBTRV32.DLL
    WDBUUI32.DLL

  6. #6
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Because you don't have the ODBC driver, you're going to be limited in your options. You said you tried the v10 engine but DacEasy didn't work. You'll probably need to contact DacEasy to find out why it doesn't work with the newer version and also to find out why they don't include the ODBC driver.
    The ODBC driver has been included with PSQL for almost 10 years now (since PSQL 7).
    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
    Nov 2008
    Posts
    8
    DacEasy v10 doesn't use any ODBC drivers, it uses Pervasive WorkGroup Engine which I don't see in my list of odbc drivers

  8. #8
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    You'll probably need to contact DacEasy to find out why it doesn't work with the newer version and also to find out why they don't include the ODBC driver.
    The ODBC driver has been included with PSQL for almost 10 years now (since PSQL 7).
    As I said above, you need to contact DacEasy. Since upgrading to v10 isn't working (you mentioned errors), you need to contact DacEasy to get ODBC drivers. All Pervasive engines have included ODBC drivers since before PSQL 2000. The PSQL 2000 does have ODBC drivers but if your vendor (DacEasy) doesn't include them, you need to contact them. There has not been a separate download for ODBC drivers for any version of PSQL since PSQL 7.
    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
    Nov 2008
    Posts
    8
    Hi mirtheil, I tried everything to connect to the database, except contacting client and asking him of the drivers. Now, when I did that, I still can't connect to those tables. I just don't get it, when I create a connection in Pervasive SQL server all I can see are the X$Field and similar tables. Where is the data? I can see that DEAMITM.DB file is modified, but when I select it as the Data folder I don't see any tables. Please can you explain to me what do I see and how can I use it?

  10. #10
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    If you don't see tables defined, it means the DDFs are empty. Are there DDFs in the Data folder? Sometimes applications put the DDFs in a different directory.
    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.

  11. #11
    Join Date
    Nov 2008
    Posts
    8
    Hi, I deleted all DDF files I found in any folder on my C: drive and DacEasy still works. How?

  12. #12
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Because DacEasy doesn't use DDFs. It uses the Btrieve API which does not use or need DDFs. DDFS are only needed for relational (ODBC, OLEDB, etc) access.
    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.

  13. #13
    Join Date
    Nov 2008
    Posts
    8
    Can you tell me a bit more about that? Do you have Btrieve API class for Pervasive 2000 server?

  14. #14
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    I do not offer a Btrieve API class. The Btrieve API is actually the same from Btrieve v6.15 all the way to PSQL v10 (including PSQL 2000).
    You might take a look at:
    http://www.pervasive.com/library/doc...api/index.html

    The Btrieve API will not allow you to use ODBC however. The ODBC driver uses a different entry point to the PSQL engine.
    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.

  15. #15
    Join Date
    Nov 2008
    Posts
    8
    Thank you for all your help. I've made some progress and connected to the database and count the records with API example provided by Pervasive.

    As you can see, I've been trying to solve my problem for over two weeks, and I'm running out of time, so I need some more help. How can I get the Table structure in order to update fields?

Posting Permissions

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