Workgroup vs. Workstation

[delphidestructor]

I’m sure I know the answer to this but I am going to ask anyway. Can anyone give me a clear definition of the difference between the workstation engine and the workgroup engine? Also clear examples were each might be the better choice. Mike

 

[mirtheil]

The only difference between the Workgroup and the Workstation engine is the license. The Workgroup allows remote computers to access the data where the Workstation is single user only. Example of when to use each:
Workstation - one workstation accessing the data.
Workgroup - peer to peer network where multiple users are accessing the data. I would recommend less than 10 users for Workgroup engine. After 10 users, I would suggest the Server Engine.
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[delphidestructor]

Thank you for the information. This is what I thought. I just wanted verification. I have the workgroup engine now running on two machines but a cannot access the demodata on either one from the other. I get this error when trying to connect to the demodata on the WGE.

[Pervasive][ODBC Client Interface][Engine LNA]You cannot connect because remote ODBC (or SQL) connections are allowed only to P.SQL 2000 server engines. Please contact Pervasive Software for additional information.

Not sure what the problem is yet.
Mike

 

[mirtheil]

To use ODBC with the Workgroup, you need to create an Engine DSN at each machine. Workgroup handles ODBC a little different than Btrieve.. The SQL will be parsed at the local machine then MKDE requests will be sent to the remote machine. With Btrieve, the Btrieve requests are sent to the remote machine directly.
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician