Access to MySql
Access to MySql
(OP)
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
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
RE: Access to MySql
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...
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.
RE: Access to MySql
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
RE: Access to MySql
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.
RE: Access to MySql
One more question. Do I need to use phpmyadmin with MariaDB on windows 7 or the workbench?
PK Odendaal
RE: Access to MySql
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.
RE: Access to MySql
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
RE: Access to MySql
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?
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.
RE: Access to MySql
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
RE: Access to MySql
PK Odendaal
RE: Access to MySql
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.
RE: Access to MySql
PK Odendaal