Thank you Razzak
It helps my understanding. To solve my problem the best I can figure is
sometning like this from within R:BASE
Set v vodbc to ('DBQ=t:\db\kontema\'+ .vclient + '\gl') *(where vclient
is from a choose command containg my clientnumber and ther by
identifying the DB)
Zip cmd /c copy c:\windows\odbc.ini c:\windows\odbc.sav
Out c:\windows\odbc.ini append
Write '[accounting]'
Write 'Driver32=c:\windows\system32\rb65_32.dll'
Write .vodbc
Out ter
Sconnect accounting identified by ''
Sattach thetablei need
Zip cmd /c copy c:\windows\odbc.sav c:\windows\odbc.ini
That way I should be able create on the fly the entries I require in
odbc.ini???
I donot however like to like that since my opinion is leave Micrsoft
files to Microsoft. I would rather do from within rbase for example
Sconnect with driver on database IDENTIFIED by ''
Any way I will give my above a try!
Gunnar
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of A.
Razzak Memon
Sent: den 10 januari 2003 14:47
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: SCONNECT & SATTACH - Razzak's Reply
At 09:53 AM 1/10/2003 +0100, Gunnar Ekblad wrote:
>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.
Gunar,
Technically, using R:BASE database as your front end, you need
to define either User, System or File Data Source Name (DSN) for
each database, to be used for SCONnect. I prefer System DSN.
User DSN is only visible to you, and can only be used on the
current machine.
A System DSN is visible to all other users on that machine.
File DSN can be shared by users who have installed the same
ODBC driver installed.
Now, if you are using other programs as the font-end, such as
designing a web-based application, using MS Front-Page, you can
use DSN Less Connection ( a connection without a predefined DSN),
to connect R:BASE database as following:
Example:
Session("ConcompCS") = "Driver=Oterro Database Driver (*.rb1);
DBQ=C:\RBTI\RBWin65\Samples\Concomp\Concomp.RB1"
Session("Connect").Open Session("ConcompCS")
Knowing the ODBC driver and the database to be used, of course,
you can create that string on the fly.
Hope that helps!
Very Best Regards,
Razzak.
