MySQL Connector / ODBC Data Source Connection Settings

[DevelopV]

I need to set up an ODBC connection to a MySQL database
I have installed the "MySQL-connector-ODBC-5.2.3" software.

I am struggling with the MySQL Connector / ODBC Data Source Connection.
Whenever I hit the "Test" button I get a failure message!

Can someone please help me with the correct settings?

Data Source Name - Can this be anything?
Description - Can this be anything?

Which Option Should I select? The database I want to connect to is on a web server.
If:
TCP/IP Server - where do I get the TCP/IP address?

Named Pipe - what is the correct entry?
User & Password - I have a user name / password to access the domain & another set for FTP. Which one do I use?
Database - this never get populated! There are three databases on the domain

All help greatly appreciated!

Thanks

 

[PHV]

Have a look here

http://www.connectionstrings.com/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886