Hello John,
I am using an ODBC connection to an Advantage Database Server in one of my
RB applications. Here is what you have to do (i'm working on windows; i
don't know if you are using RB on Mac or Windows).
First you have to download the Advantage ODBC Driver at:
http://devzone.advantagedatabase.com/dz/content.aspx?key=20
Pick your database version and you should see a 'Advantage ODBC Driver'.
Install the driver.
Then in Windows You go to Start -> Control Panel -> Administrative Tools ->
Data Source (ODBC) and Create a new ODBC connection. Fill in the name you'll
be using as DSN in your RB ODBC connection. In the 'Database or Data
Dictionary Path' you have to fill in the path to the advantage database
files. In 'Available Server Types' I also chose 'Remote Server (ADS)', but
it could also be Local Server or Internet Server in your case.
Now all you have to do in realbasic is establish the ODBC connection like
this (the ODBC connection name in my case is advantage):
App.adv = new ODBCDatabase
App.adv.DataSource = "DSN=ADVANTAGE"
if not App.adv.Connect then
MsgBox "Advantage database could not be opened."
quit
end if
Then all you have to do in SQL queries is specify the file you want to use.
FOr instance, i have a ihisto.adt file in the Advantage database folder with
a comment field in it. So then you do:
App.adv.SQLSelect("SELECT comment FROM ihisto")
You don't have to put the '.adt' in the table name.
I hope this helps you. If you have any more questions, just let me know.
Michael Beaucourt
On Wed, Oct 29, 2008 at 2:07 PM, John Kouraklis <j_kour@hotmail.com> wrote:
> Does anyone know if there is any kind of plug in to use Realbasic with
> Advantage Database Server?
>
>
>
>
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|