Connecting to a MySQL Database from within UltraDev can be a little daunting, especially if you're new to UltraDev. This tutorial explains how to connect to a MySQL database using MyODBC. Extremely usefull for PHAkt users!
Using PHAkT v1.0: Connecting to a MySQL Database using MyODBC
Using PHAkT v1.0
Connecting to a MySQL Database using MyODBC
Connecting to a MySQL Database from within UltraDev can be a little daunting, especially if you're new to UltraDev. There are currently two ways you can do this. The first is using an ODBC connection, and the second is using a JDBC connection.
This tutorial covers the first option, ODBC. If you are a Macintosh user then an ODBC connection is not an option. You will have to use a JDBC connection (a tutorial for which you can find here)
Stage 1: Installing MyODBC
If you have already completed this stage, go to Stage 2.
To create an ODBC connection to MySQL you will first need to download the MyODBC driver from http://www.mysql.com/downloads/api-myodbc.html . To ensure that you have all the necessary files download the full setup for your operating system (Win95/98/2k).
Once done, unzip the file and run Setup.exe, you will see a screen like this :-
Click Continue :-
Click on MySQL, then click OK :-
When you see this screen the driver has been installed. Click Close.
MyODBC has now been installed on your machine. You can now proceed to Stage 2
Tim Green
36 Years Old and recently married. Initially started as a COBOL, PASCAL, FORTRAN, ALGOL, 6502 and Z80 Assembly language programmer at age 16.
At age 19 I chased a career in acting where I had a couple of 'Extra' roles and appeared in 'Robin Hood' (no not the Kevin Costner one). Missed out on my big break when I contracted pneumonia which stopped me working on Aliens 3.
Following a 5 year stretch as a casual barman, chef and waiter on Spain's Costa Brava, I returned to the UK where I began work, on a VERY busy IT Support helpline.
Quickly moving through the ranks to Team Leader of Hardware, Software, 2nd level and Principle Support, I finally left after raising the service level from 17% to 98% and getting demoted by way of reward.
CEO of The Rawveg Consultancy, I provide custom extension development services, IT Consultancy, B2B and eBusiness consultancy services.
Comments
Be the first to write a comment
You must me logged in to write a comment.