A company I work for has a lot of information stored in Access Databases. Ideally, we want this information on the web server so we can dynamically display tournament scores, points standings and more. So is there a way to connect a Microsoft Access database to a MySQL Database?
The answer, I found quickly, is yes.
I couldn't export the table data right away from my Access table, but after downloading the Connector/ODBC from the MySQL dev site, and following these simple instructions on the same site, I was able to connect to the MySQL server set up on my localhost with no problems.
This is exciting because now my company can use Microsoft Access as a front-end to our MySQL servers on our website.
Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts
Tuesday, August 24, 2010
Thursday, August 19, 2010
My life just got easier thanks to XAMPP
I decided to set up PHP5, Apache and MySQL on my localhost, so I could develop a new database-driven website completely offline. I could not seem to get these things to play together nicely. A friend recommended XAMPP, a nice little Apache distribution containing MySQL, PHP and Perl. After I removed my current MySQL instance, XAMPP worked like a charm.
Then I decided to install WordPress. Using XAMPP, I was able to easily access phpMyAdmin and create a database for WordPress. But where should I install the WordPress directory so everything would work nicely? A simple Google search led me to this tutorial and within minutes my new WordPress site was installed on my localhost.
Life can be easy sometimes.
Then I decided to install WordPress. Using XAMPP, I was able to easily access phpMyAdmin and create a database for WordPress. But where should I install the WordPress directory so everything would work nicely? A simple Google search led me to this tutorial and within minutes my new WordPress site was installed on my localhost.
Life can be easy sometimes.
Labels:
Apache,
MySQL,
phpMyAdmin,
WordPress,
XAMPP
Subscribe to:
Posts (Atom)