If you are only going to read from the Access DB, you do not need Oterro.
I have used the Access connection string to read from *.mdb files and
*.txt files using the Access TEXT driver. No worries, but the connection
string in the other email got wrapped, so here is the same wrapped shorter.
SET VAR VLOC = 'F:\ACCESS\HHS62\HHSdata.mdb;'
SET VAR vconnect = +
('SCONNECT '';Provider=MSDASQL.1;Driver={Microsoft Access Driver')
SET VAR vconnect = +
(.vConnect & (*.mdb)};Dbq=' + .vloc +'')
set var vconnect = +
(.vConnect + ';Uid=admin;Pwd=;''')
&vConnect
SATTACH SomeAccessTableQuery
-- To Disconnect and Detach
SET VAR vconnect = +
('SDISCONNECT '';Provider=MSDASQL.1;Driver={Microsoft Access Driver')
SET VAR vconnect = +
(.vConnect & (*.mdb)};Dbq=' + .vloc + '')
set var vconnect = +
(.vConnect + ';Uid=admin;Pwd=;''')
&vConnect
SDETACH SomeAccessTableQuery
----- Original Message -----
From: "Luc Delcoigne" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, July 27, 2010 2:00 PM
Subject: [RBASE-L] - re: VB connection to Rbase
Hello Mike,
back from a week of Italian holiday....
I answered your previous mails but apparently your email -address wasn't
accepted by the provider over here, so I got a "no delivery" return.
Hope you can read this mail.
As far as efilm is concerned:
I couldn't test it so far. On the PC where I got Rbase the Efilm software
wouldn't install because of a 32/64 bit conflict.
On the Pc where I got efilm I still have to install Rbase.
I will do this when the rest of the program is ready and I get the 5 seat
add-on.
I don't see why it wouldn't work.
As far as the other problem is concerned:
The VB program that I have to run retries data from the actual
Access-database.
Now I have to modify this VB program so that it can connect and read a
table in my new Rbase database.
Do I need Oterro for this or is there another way to do this ?
best regards,
Luc Delcoigne
--------------------------------------------------
From: "Mike Byerley" <[email protected]>
Sent: Tuesday, July 27, 2010 7:39 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - re: VB connection to Rbase
Here's an example. I would still like to hear of the results if you were
able to use RMScript.DLL in your eFilm app?
SET VAR VLOC = 'F:\ACCESS\HHS62\HHSdata.mdb;'
SET VAR vconnect = +
('SCONNECT '';Provider=MSDASQL.1;Driver={Microsoft Access Driver
(*.mdb)};Dbq=' + .vloc +'')
set var vconnect = (.vConnect + ';Uid=admin;Pwd=;''')
&vConnect
----- Original Message -----
From: "Luc Delcoigne" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, July 27, 2010 12:40 PM
Subject: [RBASE-L] - re: VB connection to Rbase
Hi,
I have to run a VB 6.0 program where I have the following line to
"translate" to RBASE.
DBConnection.Open "provider=Microsoft.Jet.OLEDB.4.0;data
source=c:\Source\RxData2000.mdb"
How does this look to make this program connect to my Rbase database and
do what it's supposed to do ?
Do I need the Oterro driver for this ?
Luc Delcoigne
