So far I am with you . My problems is however that my odbc datasource is
for example:
Name: Accounting
Location: T:\db\KONTEMA\1000\GL
Where the location contains a variable part in this case 1000 beeing a
client number. The way I have it set up is that each klient has there
own set of 3 databases fore accounting Receivables and payables.
I am trying to avoid to have to define in ODBC each individuell
clientdatabase since that would give something like 300 ODBC datasources
to be maintained on each workstation.
My present understanding is that I can not avoid it.
I suppose what I am asking for is an extansion of the SCONNECT syntax
SCONNECT ODBCdatasource IDENTIFIED BY ''
|
using R:BASE driver on T:\db\KONTEMA\1000\GL IDENITIED BY ''
So I guess I can only pray for 7.0
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Walker,
Buddy
Sent: den 10 januari 2003 00:23
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: SCONNECT & SATTACH
You must have ODBC setup for your other database to use SCONNECT.
If you don't have an ower password then you can do the following.
SCONNECT ODBCdatasource IDENTIFIED BY ''
Now you can use the SATTACH.
Check out http://www.rsyntax.com/Syntax.htm
<http://www.rsyntax.com/Syntax.htm>
Buddy
-----Original Message-----
From: Gunnar Ekblad [mailto:[EMAIL PROTECTED]]
Sent: Thu 1/9/2003 9:05 AM
To: [EMAIL PROTECTED]
Cc:
Subject: [RBASE-L] - SCONNECT & SATTACH
Can someone give me a hint on use of this command in RBWIN
In RBDOS I do as an ex
Connect .pgl *(containg name of general ledger database for ex 0056\gl)
Sconnect .pinvdb *(containg name of invoicedatabase for ex 0056\invoice
where the 0056 is a klientnummber that varies pending which klient I am
working on)
Sattach people as invpeople
*(Then I synchronize common data between the 2 databases)
How do I do the same in windows without every time getting prompted for
dsn and ODBClogon and qualification of columns. I like all to happen in
my scriptfile and hide all OBC related stuff from enduser.
Kontema IT AB
Gunnar Ekblad
H�stholmsv�gen 32
131 30 NACKA
Tel +46 8 814 59 00
Mobil +46 705455038
E-mail [EMAIL PROTECTED]
