Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Multiple DB's



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?



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.