Home arrow MySQL arrow Using MyODBC to Connect to a Remote Database
MYSQL

Using MyODBC to Connect to a Remote Database


Using MySQL's support for MyODBC, you can connect to remote databases, import and export tables to and from your MySQL database and more. In this article Steve shows us exactly how to get started...

Author Info:
By: Steve Knoblock
Rating: 5 stars5 stars5 stars5 stars5 stars / 38
January 02, 2003
TABLE OF CONTENTS:
  1. · Using MyODBC to Connect to a Remote Database
  2. · Why Connect Using MyODBC?
  3. · Installing MyDOBC
  4. · MyODBC Setup
  5. · Exporting a Table to the Remote Database (contd.)
  6. · Conclusion

print this article
SEARCH DEVARTICLES

Using MyODBC to Connect to a Remote Database
(Page 1 of 6 )

One of the impressive features of MySQL is its full support for ODBC (Open DataBase Connectivity). The source for the ODBC driver and interface are available for those interested in furthering open source development or customizing ODBC access. All ODBC 2.5 functions and many others are supported.

You may use Microsoft Access to connect to your MySQL server, which this tutorial is based on. MyODBC is the ODBC driver for the MySQL database server produced by TCX Data-Consult in Sweden. MySQL provides support for ODBC by means of the MyODBC program.

In this article I will show you exactly how to use MyODBC to connect to a remote database, perform data copying activities and more. I will assume that you have an intermediate knowledge of MySQL.
blog comments powered by Disqus
MYSQL ARTICLES

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials