Subject Re: Using dBase to Access Data Stored in MariaDB From Ketan G <ketan_gondhalekar@aol.com> Date Thu, 01 Sep 2022 10:28:49 -0400 Newsgroups dbase.getting-started Thanks a lot, Merwyn and Akshat, for your detailed descriptions. I will certainly use these tips while connecting to the MariaDB data. Ketan Akshat Kapoor Wrote: > Good Evening Ketan, > > > Briefly, I need to access data stored in a MariaDB database (several tables) using dBase. > > > > Through a bit of reading and following this forum, have a vague idea that this is done through the BDE (older method) and through ADO (nowadays the more recommended approach). > > > > However, I have no experience of either of these methods as my use of dBase is for local tables, and through xBase commands. > > > > Any suggestions on a good starting point (reading as well as code examples) would be a great help. > > This is in extension to Mervyn's reply. > > I use dBase with MariaDB as backend regularly. All my data is on MariaDB > except for some temp tables which may be shifted to MAriaDB if I am not > feeling lazy enough to do so. > > Once you have a user name and password you can use the following code to > check the connection > > d = new adodatabase() > d.connectionString = "Driver={MySQL ODBC 3.51 > Driver};Server=WINDOWS-XXXXXX;Database=yourDatabaseNAme;UID=UserID;PWD=Password;Port=3306;option=71303680" > > (Watch for word wrap in above line) > d.provider = "MSDASQL" > d.active = true > > q = new adoquery() > q.database = d > q.sql= [select coalesce(max(invoice),0) from invoice] > q.active = true > > ?[Connection okay ] > //Cleanup > q.active = false > d.active = false > > Copy all the above lines in a prg and run it after making necessary > changes for ODBC driver Server name etc. > > Once you have installed the driver (I will recommend installing both > versions 32 bit AND 64 bit) you can view the exact driver name by going > through the control panel > Admininstrative tools > > (A screen shot is attached) > > If MariaDB server is running on Linux server then in place of server > name use ip address of the server. > Database name > User ID > Password > > Will have to be supplied by database administrator. > > If the prg is running without errors then we are ready to start with > retrieval of data as and when required. > > If you want to modify data as well then post will provide help on that also. > > Hope this helps. > Regards > Akshat >