×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Access to MySql

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

PK Odendaal

RE: Access to MySql

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...

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

(OP)
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

RE: Access to MySql

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.



RE: Access to MySql

(OP)
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

RE: Access to MySql

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.

RE: Access to MySql

(OP)
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

RE: Access to MySql

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? bigsmile 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.

RE: Access to MySql

(OP)
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

RE: Access to MySql

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.

RE: Access to MySql

(OP)
Thanks so much spamjim.

PK Odendaal

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close