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

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.

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...

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.

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

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).

DacEasy v10 doesn't use any ODBC drivers, it uses Pervasive WorkGroup Engine which I don't see in my list of odbc drivers

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.

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?

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.

Hi, I deleted all DDF files I found in any folder on my C: drive and DacEasy still works. How?

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.

Can you tell me a bit more about that? Do you have Btrieve API class for Pervasive 2000 server?

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.

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?