Access to MySql

[peekay]

Reposting from VB6

I wish to change my VB6 program/s to read, write edit and delete data from a MySql database in stead of from MS Access.

1. Can this be done and are the changes significant?
2. Do I need to use PHP or can I edit directly like I do now with DAO or even ADO.
3. What is the best operating system to run MySql from?
4. Is Maria DB any better than MySql?

Thanks


PK Odendaal

 

[ChrisHirst]

Q1. Yes and possibly.

Q2. No and Yes if you install the MySQL driver on the machine(s) your programme will be running on.

Q3. Linux (though Windows will suffice)

Q4.

https://mariadb.com/kb/en/library/mariadb-vs-mysql-features/

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

Never mind this jesus character, stars had to die for me to live.

 

[peekay]

Thank you so much Chris.

1. I presume Linux Ubuntu is ok for the operating system.
2. Are the drivers for MySql and MariaDB the same?
3. Is it easy to port the database to another server should I wish to do so later?



PK Odendaal

 

[spamjim]

1 Yes
I agree with "Q3. Linux" but would emphasize "(though Windows will suffice)". If you're already working in a Windows environment and have a system ready, there's not much point to adding an additional system to maintain. I'd add Linux if there was not already a Windows system ready to host the database.

2 Yes
MariaDB's connector "can be used as a drop-in replacement for MySQL Connector/ODBC"
(

https://downloads.mariadb.org/connector-odbc/)

3 Yes
One concern with developing between Linux and Windows MySQL (or Maria) is case sensitivity (Linux is case-sensitive). Be mindful of case sensitive queries and you should be able to bounce between either system, as the need appears.

 

[peekay]

Thank you all for your valuable contributions.
One more question. Do I need to use phpmyadmin with MariaDB on windows 7 or the workbench?


PK Odendaal

 

[ChrisHirst]

Ubuntu would be fine if you need a GUI for configuring etc. But if you are okay with shell commands, using CentOS or Fedora without installing a Desktop environment would save on resources. For development work running a Raspberry Pi (Raspbian) with MySQL on it is more than capable and will save a huge chunk of desk space.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

Never mind this jesus character, stars had to die for me to live.

 

[peekay]

Maybe I should backtrack a little first. I am on windows 7 presently and developing with VB6. Access is becoming too small for my purposes.
1. Is MySql a database with all the necessary functions access has and does it have integrity for big data?
2. Why should I use MariaDB if I only need a basic relational database with a few million lines and about 30 connections?
3. It seems that MySql Workbench is much easier to use than phpmyadmin. Or can I use MySql Workbench with MariaDB as well?

Thanks

PK Odendaal

 

[spamjim]

1 Yes

2 Oracle bought MySQL a few years ago. Free MySQL is a competing product with other paid Oracle DB products. See where that's heading? MariaDB development is driven by former MySQL creators/managers and continues the open/free concept.

3 While we might use the general term "MySQL", we often run Maria. You can still use MySQL GUI tools (MySQL Workbench, SQLyog Community, HeidiSQL, etc) on Maria.

 

[peekay]

Thanks spamjim.

1. I have this error (screenshot attached) opening the Workbench. How can I fix that?

2. Workbench refers to MySql database engine and to Mariadb paths (screenshot attached). How do I know I use MariaDB and how do I change this configuration?

3. I used the following code on Access (with DAO).

dim dbControls As Database,rs as recordset
Set dbControls = DBEngine.OpenDatabase(App.Path & "\GMControls.mdb")
Set rs = dbControls.OpenRecordset("Select count(*) as links from Busunits where isnull(DatabaseName)=false", dbOpenSnapshot) 'the links database only t

How would I change this for MariaDB.

Tnanks

PK Odendaal

 

[peekay]

First error

PK Odendaal

 

[spamjim]

1. May not be an issue and you can "continue anyway". This is Oracle saying that the DB you're connecting to is not developed and maintained by Oracle so they cannot guarantee all features will function. I haven't used Workbench in years so I can't say what portion may not be compatible. I don't see this as a major problem but if you do, you can still use SQLyog Community or HeidiSQL...both free. HeidiSQL is nice because it supports MySQL, MariaDB, MSSQL, and PostgresSQL...and it can also run as a portable app.

2. That screen shot suggests everything is running correctly. The only thing that is marked as 'MySQL' is the INI (configuration) file. If you pop that open in a text editor, it should already be pointing to MariaDB.

3. It is doable in VB6, but VB6 is out of my range. Google for "VB6 MySQL" and "VB6 MariaDB". The solutions work in either DB.

 

[peekay]

Thanks so much spamjim.


PK Odendaal