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? |