Pervasive ODBC Driver set up

[kvogler]

I'm trying to test the odbc driver from pervasive to connect to Peachtree. I've downloaded the latest trial version of Peachtree and the Pervasive ODBC Drivers 2.04 for Btrieve 6.15 but am fuzzy about the set up. I can find many data files but I'm not sure what directory or database name to use. I've tried several but I keep getting login errors. Is there a tutorial on this. I've done a lot of database connections but usually with Access or ADO and SQL Server.

Many Thank
Kevin

 

[DougStevens]

I'm very much interested in trying to set this up as well. I'm trying to use MS Access as a front end to the Peachtree software.

So far, I've downloaded Pervasive's Workstation demo program. Think I've set up a ODBC connection which I was able to view the tables in MS Access. However, I can not write to these tables. I think I need the 6.15 engine, where do I get it? I've looked and looked on the Pervasive site and found only knowledge base articles but nothing to download.

-Doug

 

[dgillz]

faq641-2108 should give you some insights into what you are trying to do. I have never tried to write to these tables however.

Let meknow if you have any questions. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Guest_imported]

I too am attempting to access Peachtree dat files with Access, but I'm having a hard time setting up the Pervasive driver. During setup it asks you for the directory of the .ddf files, which I take it define the data structure of the peachtree dat files. I can't find ddf files anywhere in my peachtree setup, and I'm wondering if someone can give me a clue what I'm doing wrong. Where are they located? Are they called something else? I got the driver to work with the demo data they sent with the program, but peachtree is still a mystery.

Thanks in advance for any help.
-James

 

[dgillz]

James,

I have seen that some versions of peachtree do not provide you with .ddf files. I am betting you will have to visit peachtree and either download them or purchase them. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Guest_imported]

I to am working on the same thing but have not purchased the control (software development, standalone or workgroup for networksas yet and gathered all the data, here is what I have so far. DONALD_WALKER@Prodigy.net. you can go to the following web site for more info and I will post another message here when I have completed my project.

http://www.pervasive.com

donald walker


Issue:
Peachtree Software introduced version checking in Peachtree Accounting for Windows version 5.0. This version checking looks for a specific version of the Btrieve engine and will cause Peachtree to fail if it receives a response different from what it expects. Since Peachtree versions 5, 6, 7 & 8 all expect Btrieve 6.15, they will fail if they get the version information from the Pervasive.SQL 2000 Engine.

Note:
Peachtree Accounting for Windows 2002 (or version 9) does do the version checking, but it will accept Btrieve 6.15, Pervasive.SQL 2000 SP2a, or Pervasive.SQL 2000i (SP3), though Pervasive.SQL 2000i is designed to be 100% backward compatible with all Btrieve API applications. Peachtree Software does not recommend that their users run with Pervasive.SQL 2000, but this is primarily because they do not support it and they have not done extensive testing with it.

Workarounds:
There are a few workarounds available, and they depend on what version of Peachtree Accounting you are running, and what you want to accomplish.

The workarounds for versions 5, 6 & 7 will allow you to run Peachtree Software with the Pervasive.SQL 2000 Workstation or Workgroup Engine.

The Workaround for version 8 will allow you to run Peachtree with Btrieve 6.15 on the same machine that also has Pervasive.SQL 2000 installed, but you cannot run Btrieve 6.15 and Pervasive.SQL 2000 on the same machine at the same time. This means that you will have to exit Peachtree Accounting, which will unload the Btrieve 6.15 engine, and then you can start Pervasive.SQL 2000 and any applications that you will be using with Pervasive.SQL 2000 without having to reboot.



Peachtree Accounting Version 5.0
Executable: peachw.exe 16 bit App, expected to run on Win3.11
Default Engine: Btrieve 6.15 Type: wbtr32.exe, wbtrlocl.dll

Instructions:
1. Install Peachtree 5.0
2. Install P2k Engine
3. Stop the engine
4. Run PSA and point it to clean c:\peachw directory.
5. Run the Btrieve Version Override utility, Pvsetopt.exe (Utility is available from Pervasive Support):



For Win NT/2K
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Type"=W
For Win 9x/ME (this is a last minute patch because WIN API calls to enum 16bit apps do not work for win9x)
pvsetopt "Microkernel Router\Settings Override" kernel32.dll "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" kernel32.dll "Version Type"=W

6. Start the engine
7. Run Peachtree Accounting Software.

Pitfalls:
1. PSA fails to clean up the 6.15 engine residing in c:\peachw directory because C:\peachw is not in the path. See item 4 above. Must run PSA and point to c:\peachw directory to clean out:
Wbt32res.dll, wbtrvres.dll, wbtrlocl.dll, wbtrcall.dll and wbtr32.exe.
2. For Win9.x/ME platforms, the behavior of pvsetopt is not consistent. In some versions of Win9.x the Peachw.exe 16 bit app hangs while accessing the engine.



Peachtree Accounting Version 6.0
Executable: peachw.exe 16 bit App, expected to run on Win3.11
Default Engine: Btrieve 6.15 Type: W wbtr32.exe, wbtrlocl.dll

Instructions:
1. Install Peachtree 6.0
2. Install P2k Engine
3. Stop the engine
4. Run PSA and point it to clean c:\peachw directory.
5. Run the Btrieve Version Override utility:

For Win NT/2K
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Type"=W
For Win 9x/ME (this is a last minute patch because WIN API calls to enum 16bit apps do not work for win9x)
pvsetopt "Microkernel Router\Settings Override" kernel32.dll "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" kernel32.dll "Version Type"=W

6. Start the engine
7. Run Peachtree Accounting Software.

Pitfalls:
1. PSA fails to clean up the 6.15 engine residing in c:\peachw directory because C:\peachw is not in the path. See item 4. above. Must run PSA and point to c:\peachw directory to clean out:
Wbt32res.dll, wbtrvres.dll, wbtrlocl.dll, wbtrcall.dll and wbtr32.exe.
2. For Win9.x/ME platforms, the behavior of pvsetopt is not consistent. In some versions of Win9.x the Peachw.exe 16 bit app hangs while accessing the engine.



Peachtree Accounting Version 7.0
Executable: peachw.exe 32 bit App, expected to run on Win9.x
Default Engine: Btrieve 6.15 Type: N w32mkde.exe, wbtrv32.dll

Instructions:
1. Install Peachtree 7.0
2. Install P2k Engine
3. Stop the engine
4. Run PSA and point it to clean c:\peachw directory.
5. Run the Btrieve Version Override utility:

pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Type"=N

6. Start the engine
7. Run Peachtree Accounting Software.



Peachtree Accounting Version 8.0
Executable: peachw.exe
Default Engine: W32BTICM.DLL, W32MKDE.EXE

Peachtree version 8 will only use Btrieve version 6.15 workstation engine and requesters. Any attempt to use any other version of Btrieve or Pervasive.SQL will result in the error message.

Move the following files into the \peachw directory (these files are most likely located in the \windows\system directory):
WBTR32.EXE
W32MKDE.EXE
W32MKRC.DLL
WBTRVRES.DLL
WBTRTHNK.DLL
WBTRLOCL.DLL
WBT32RES.DLL
WBTRCALL.DLL file size 43,472
WBTRV32.DLL file size 68,096

Right click on the gray start bar at the bottom of your desktop screen and select properties.
Select the "Start Menus" tab
Click the "Remove" button
Select the "Startup" folder
Delete the shortcut for Pervasive.SQL 2000 workstation engine
Reboot the workstation

You should now be able to alternately run your Pervasive.SQL application and Peachtree 8. The two applications cannot be run at the same time because the different versions of the engines will conflict. When the Pervasive.SQL engine is running an icon will appear in the system tray. When the application is closed and the icon disappears you can run Peachtree.
The Btrieve version 6.15-workstation engine requires 30 seconds to remove itself from memory. After closing Peachtree 8, please allow at least 30 seconds for the 6.15 engine to unload.



Disclaimer:


Pervasive Software does not warranty or support these configurations. These workarounds are provided as a courtesy to Pervasive Software customers who use Peachtree Accounting. Pervasive Software assumes no responsibility or liability for damage that may occur as a result of using these configurations.



Workarounds for running Peachtree Accounting for Windows with Pervasive.SQL 2000

Issue:
Peachtree Software introduced version checking in Peachtree Accounting for Windows version 5.0. This version checking looks for a specific version of the Btrieve engine and will cause Peachtree to fail if it receives a response different from what it expects. Since Peachtree versions 5, 6, 7 & 8 all expect Btrieve 6.15, they will fail if they get the version information from the Pervasive.SQL 2000 Engine.

Note:
Peachtree Accounting for Windows 2002 (or version 9) does do the version checking, but it will accept Btrieve 6.15, Pervasive.SQL 2000 SP2a, or Pervasive.SQL 2000i (SP3), though Pervasive.SQL 2000i is designed to be 100% backward compatible with all Btrieve API applications. Peachtree Software does not recommend that their users run with Pervasive.SQL 2000, but this is primarily because they do not support it and they have not done extensive testing with it.

Workarounds:
There are a few workarounds available, and they depend on what version of Peachtree Accounting you are running, and what you want to accomplish.

The workarounds for versions 5, 6 & 7 will allow you to run Peachtree Software with the Pervasive.SQL 2000 Workstation or Workgroup Engine.

The Workaround for version 8 will allow you to run Peachtree with Btrieve 6.15 on the same machine that also has Pervasive.SQL 2000 installed, but you cannot run Btrieve 6.15 and Pervasive.SQL 2000 on the same machine at the same time. This means that you will have to exit Peachtree Accounting, which will unload the Btrieve 6.15 engine, and then you can start Pervasive.SQL 2000 and any applications that you will be using with Pervasive.SQL 2000 without having to reboot.



Peachtree Accounting Version 5.0
Executable: peachw.exe 16 bit App, expected to run on Win3.11
Default Engine: Btrieve 6.15 Type: wbtr32.exe, wbtrlocl.dll

Instructions:
1. Install Peachtree 5.0
2. Install P2k Engine
3. Stop the engine
4. Run PSA and point it to clean c:\peachw directory.
5. Run the Btrieve Version Override utility, Pvsetopt.exe (Utility is available from Pervasive Support):



For Win NT/2K
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Type"=W
For Win 9x/ME (this is a last minute patch because WIN API calls to enum 16bit apps do not work for win9x)
pvsetopt "Microkernel Router\Settings Override" kernel32.dll "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" kernel32.dll "Version Type"=W

6. Start the engine
7. Run Peachtree Accounting Software.

Pitfalls:
1. PSA fails to clean up the 6.15 engine residing in c:\peachw directory because C:\peachw is not in the path. See item 4 above. Must run PSA and point to c:\peachw directory to clean out:
Wbt32res.dll, wbtrvres.dll, wbtrlocl.dll, wbtrcall.dll and wbtr32.exe.
2. For Win9.x/ME platforms, the behavior of pvsetopt is not consistent. In some versions of Win9.x the Peachw.exe 16 bit app hangs while accessing the engine.



Peachtree Accounting Version 6.0
Executable: peachw.exe 16 bit App, expected to run on Win3.11
Default Engine: Btrieve 6.15 Type: W wbtr32.exe, wbtrlocl.dll

Instructions:
1. Install Peachtree 6.0
2. Install P2k Engine
3. Stop the engine
4. Run PSA and point it to clean c:\peachw directory.
5. Run the Btrieve Version Override utility:

For Win NT/2K
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Type"=W
For Win 9x/ME (this is a last minute patch because WIN API calls to enum 16bit apps do not work for win9x)
pvsetopt "Microkernel Router\Settings Override" kernel32.dll "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" kernel32.dll "Version Type"=W

6. Start the engine
7. Run Peachtree Accounting Software.

Pitfalls:
1. PSA fails to clean up the 6.15 engine residing in c:\peachw directory because C:\peachw is not in the path. See item 4. above. Must run PSA and point to c:\peachw directory to clean out:
Wbt32res.dll, wbtrvres.dll, wbtrlocl.dll, wbtrcall.dll and wbtr32.exe.
2. For Win9.x/ME platforms, the behavior of pvsetopt is not consistent. In some versions of Win9.x the Peachw.exe 16 bit app hangs while accessing the engine.



Peachtree Accounting Version 7.0
Executable: peachw.exe 32 bit App, expected to run on Win9.x
Default Engine: Btrieve 6.15 Type: N w32mkde.exe, wbtrv32.dll

Instructions:
1. Install Peachtree 7.0
2. Install P2k Engine
3. Stop the engine
4. Run PSA and point it to clean c:\peachw directory.
5. Run the Btrieve Version Override utility:

pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Level"=6.15
pvsetopt "Microkernel Router\Settings Override" peachw.exe "Version Type"=N

6. Start the engine
7. Run Peachtree Accounting Software.



Peachtree Accounting Version 8.0
Executable: peachw.exe
Default Engine: W32BTICM.DLL, W32MKDE.EXE

Peachtree version 8 will only use Btrieve version 6.15 workstation engine and requesters. Any attempt to use any other version of Btrieve or Pervasive.SQL will result in the error message.

Move the following files into the \peachw directory (these files are most likely located in the \windows\system directory):
WBTR32.EXE
W32MKDE.EXE
W32MKRC.DLL
WBTRVRES.DLL
WBTRTHNK.DLL
WBTRLOCL.DLL
WBT32RES.DLL
WBTRCALL.DLL file size 43,472
WBTRV32.DLL file size 68,096

Right click on the gray start bar at the bottom of your desktop screen and select properties.
Select the "Start Menus" tab
Click the "Remove" button
Select the "Startup" folder
Delete the shortcut for Pervasive.SQL 2000 workstation engine
Reboot the workstation

You should now be able to alternately run your Pervasive.SQL application and Peachtree 8. The two applications cannot be run at the same time because the different versions of the engines will conflict. When the Pervasive.SQL engine is running an icon will appear in the system tray. When the application is closed and the icon disappears you can run Peachtree.
The Btrieve version 6.15-workstation engine requires 30 seconds to remove itself from memory. After closing Peachtree 8, please allow at least 30 seconds for the 6.15 engine to unload.



Disclaimer:


Pervasive Software does not warranty or support these configurations. These workarounds are provided as a courtesy to Pervasive Software customers who use Peachtree Accounting. Pervasive Software assumes no responsibility or liability for damage that may occur as a result of using these configurations.