dbTalk Databases Forums  

Multiple DB's

comp.databases.btrieve comp.databases.btrieve


Discuss Multiple DB's in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jlapenta@entelsys.com
 
Posts: n/a

Default Multiple DB's - 10-24-2003 , 10:17 AM






Platorm Windows 2000 Server, running P8 Sp1

Create a Server DSN on the server called P31SERVER. Use the DDF's in the
\DDF subdirectory, but add path for data to \DATA\p31

Create a Second Server DSn called P32SERVER. Use same DDF's, set path for
data to \data\p32.

In Control on Server, so a query SELECT * from P31SERVER.EMPLOYEE shows
records from data in \data\31.

SELECT * from P32SERVER.EMPLOYEE shows records from data in \data\32.

So far, so good.


On the client workstation, create a CLIENT DSN. P31, which uses the server
DSN P31SERVER and a second one P32 which uses SERVER DSN P32SERVER.

On the Client in control center SELECT * from P31.EMPLOYEE fails, as
does SELECT * from P32.EMPLOYEE.

Any thoughts?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.