Monday, January 18, 2010

Create a MySQl Data Source Name for a Database Programming in Windows XP



If we use MySQL as Our Database Management System, Maybe it wasn't a default to be provide by Microsoft Windows. So We need to download the MySQL ODBC Connector First. You can download version 3.5.x or 5.1.x. I have try 5.1 and work fine.

Step by step to Create a MySQl Data Source Name for a Database Programming in Windows XP isn't too much.

1. First May be you need to finish less than 30 seconds step (while you read, you will also understand and can do it == Simply click Start -- Control Panel -- Administrative Tools -- Data Source (ODBC))

2.  Double Click Data Source and You will find existing data sources.

3. Click Add New Data Source
MySQl Data Source Name

4. Be sure You have install MySQL ODBC Connector, The indicator if you have install is a MySQL ODBC Driver in a list like below.
MySQl Data Source Name



5. Click Finish, You will then Fill a form with MySQL user account, Give DSN Name an it's description. Be sure input Server, User and Password. Leave Port as Default. 

MySQl Data Source Name
If you correct, The list of Database will be shown.





MySQl Data Source Name

Just Click Ok. Now You Already have a Data Source Name.

MySQl Data Source Name

This  Data Source (DSN) can be Helpful for Next Step Programming.

Possibly Related Article



at Monday, January 18, 2010
Labels:

2 comments:

seo melbourne said...

Thanks first for providing with this informative and alluring blog…
Can we make database programmes in mysql without making dsn..?

January 12, 2011 at 9:42 PM
Website Designers said...

Thanks for describing database programming nicely. Actually it’s a long time I had been using the data source name in this programming. But now I have been using mysql without making any DSN( data source name). I think this is easier and more comfortable using without any DSN.

January 29, 2011 at 1:24 AM

Post a Comment

Subscribe to: Post Comments (Atom)