Rob,
When I attach to the ACCESS database we have, I use the SCONNECT and
SATTACH codes on a DSN less connection.
SCONNECT ';Driver={Microsoft Access Driver
(*.mdb)};DBQ=g:\db\TABLES.mdb;'
SATTACH tblPARTINFO AS PARTINFOA USING APARTNUM ALIAS
APARTNUM,APARTNAME,+
ACOMMENTS,APARTDESC,APTLENGTH,APTWIDTH,LENGTHD,WIDTHD,THICKD,+
AMATID#,COATWORK,AWORKOUT
I use the ALIAS code because the tables have Identical columns.
As long as RBASE recognizes the ODBC drivers you should connect to the
database and tables.
Hope this at least points you in the right direction.
Jim
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Rob
Vincent
Sent: Monday, December 07, 2009 6:46 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - mySQL ODBC connection
Is there a tutorial that outlines the steps necessary to connect to an
external mySQL database through the Rbase interface?
I have installed the mySQL ODBC Connector (v5.1) on my local machine.
User, System & File DSN's have been created and the connection tested OK
to the external web-based mySQL DB.
I just don't know how (or if) Rbase can directly access the database and
tables.
Thanks!
