ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> Workgroup...can't connect via ODBC
http://www.istechforum.com/YaBB.pl?num=1114717762

Message started by Mike_Habich on 04/28/05 at 11:49:22

Title: Workgroup...can't connect via ODBC
Post by Mike_Habich on 04/28/05 at 11:49:22

Workgroup 2000i SP4

I'm trying to set up ODBC connection to get UPS track no into DBA. I've set up the DSN on the machine that runs DBA. Both machines are running the Workgroup Engine. On the machine that runs UPS, I can see the database in Pervasive Control Center under the remote machine, but can't access it: Connection to database failed/You cannot connect because remote ODBC connections are allowed only to P.SQL server engines.

What am I missing?

Title: Re: Workgroup...can't connect via ODBC
Post by Mike_Habich on 05/03/05 at 11:13:14

Fixed it. Upgraded to Pervasive V8. Now can access "server" workgroup engine ODBC from "client" workgroup machine. Don't need workgroup engine running on client.

Title: Re: Workgroup...can't connect via ODBC
Post by dameng on 07/04/05 at 12:47:17

i just saw your postings.

pervasive 2000i workgroup and earlier never had relational access between workgroup engines. you could only have relational access to the files from the same workstation that is running the engine.

pervasive 8.x and newer, for the workgroup, they added the ability to have relational access between worksations. emulating what one would have in a client server setup.

fyi.
dave