mySQL Essentials

Top  Previous  Next

 

When you are using mySQL as your database, you will need to connect both from your PC and with your published pages.  The table shows the various combinations when using mySQL and the supported connection type.

 

Operating System

Function

Script Language

Connection Type

Windows

Designing with dbQwikSite

N/A

myODBC

Windows

Testing on PC

ASP

myODBC

Windows

Testing on PC

PHP

Native or myODBC

Windows

Hosting

PHP

Native

Windows

Hosting

ASP

myODBC

Linux

Hosting

PHP

Native

mySQL Connection Compatibility Chart

 

Where is your Database?

 

Another important consideration when connecting to your mySQL databases from your PC is the database's location.  Do you have mySQL installed running on your PC or is your database hosted on a server on your LAN or on the Internet?

 

You can normally connect to mySQL no matter where it is located, but there are more restrictions and prerequisites.

 

Location

Requirements

Your PC

You must have the mySQL database program installed on your PC.
You must have the mySQL service running
You must have MyODBC.
You must have a myODBC connection defined.

LAN Server

You must have myODBC installed on your PC
You must have a connection defined to your LAN mySQL Server
Your PC must be connected to your LAN.

Hosting Server on Internet

You must have myODBC installed on your PC.
You must have a connection defined with your PC
Your Hosting Service must have configured mySQL security to allow remote connections.
You must be connected to the internet.