I am trying to setup database connection to MySQL server using MySQL ODBC driver that i downloaded from mysql web site. What should I put into "Data source". When I leave it blank I get an error "Data source name not found and no default driver specified". In "Driver" I choose MySQL ODBC 5.2w Driver. Provider is set to MySQL (MSDASQL). The only option that gives me successful connection is dBase Files, but in this case Database Manager shows no data, although there is data in the database, and I see no connection attempts using tcpdump on the server where mysql DB server resides.
