[RUO 2.0+] Easy MySQL Connector

[Vorspire]

[RUO 2.0+] Easy MySQL Connector

Easy MySQL Connector
Rhovanion-PK - Ultima Online Free-Shard - RunUO
Ouroboros at Vita-Nex​

----------
PACKAGE:
----------
namsepace Server.Vorspire.MySQL
----------
Click file names to view code.

¬Vorspires MySQL Connector

• MySQLConnection.cs

----------

----------
OVERVIEW:
----------
----------

This connector class wraps the System.Data.Odbc.OdbcConnection class to provide an easy-to-use API allowing the developer to execute various queries on a remote MySQL Database Server.

NOTE: I will be using this connector class with future releases of any systems that require a MySQL Database to function.

All code within the class script is annotated to help any prospective developer better understand this system.

IF...
You have connection problems or errors, don't be willing to blame the MySQLConnector straight away

SO...
The most common problems with MySQL ODBC being unable to connect include:

• ODBC Driver Not Installed
• ODBC Driver Version Mis-match
• Incorrect Login Credentials
• Incorrect Host IP Address
• Unspecified Port (If Not 3306)
• Firewall Software (Client And Host)
• Router/HUB/LAN Configuration (Port/Service Forwarding)

OR...
If you host with a web-hosting company, there may be a chance that they have remote MySQL connections blocked, which can usually be overridden on web-host interfaces such as CPanel and WHM.

Some web-hosts use multi-filtering systems, you may need to specifically ask your web-host if they can open a port or white-list your remote IP to allow you to connect; They shouldn't really hesitate unless they believe it could be a security risk.

------------------------------------------------------------

Please do not post help requests or error reports in this thread.

------------------------------------------------------------

Regards,
Vorspire

 

[animalcrackers]

wat exactly is this?

 

[KevinEvans]

It's for using a database with RunUO

 

[Vorspire]

wat exactly is this?

"This connector class wraps the System.Data.Odbc.OdbcConnection class to provide an easy-to-use API allowing the developer to execute various queries on a remote MySQL Database Server."