Tuesday, January 26, 2010

Create New DSN for Microsoft Word and MySQL Server Mail Merge

As Previous Post about Create a MySQl Data Source Name for a Database Programming in Windows XP

we can do it fast now
1. 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.

    Fill in the form. In the last step, if you correct, The list of Database will be shown. We will use a table named user on database named belanja. Fisrt, we just choose the database to make the DSN, like example below.

    I Assume this was an Example, Just Pick Up an Example Database that have a Flat Table (Table that has no Relationship)





    Just Click Ok. Now You Already have a Data Source Name.The DSN was named User.



    We can move to Next Steps on Mail Merge With Microsoft Word and MySQL.

    Possibly Related Article



    2 comments:

    web marketing melbourne said...

    I Think of your talents as the things you’re really good at. They’re like personality traits. For instance, you may be a very creative person, or a person who’s really good at attending to details or a person with a gift for communicating. Your talents are the base for any successful business venture, including a home-based business.

    SEO Hampshire said...

    You may be a very creative person, or a person who’s really good at attending to details or a person with a gift for communicating.