ODBC connections only work with localhost--cannot use server name? (no replies)

This Comment will be submitted for moderation and will not be accessible to other users until it has been approved.
Submitted by programmer on Thu, 08/14/2008 - 20:25.
::

We have just installed MySQL on a local server.

I downloaded and installed ODBC version 5.1.4 and installed both on the Server (WinXP Pro box) and my workstation (WinXP Pro)--so we could connect MS Access.

I can install the ODBC on the server using "localHost" as the Server Name--no other name will work.

On my workstation I cannot make an ODBC connection. It will not accept the servername "BR123XL". I receive an error message that looks like this:

Connection Failed: [HY000][MySQL][PDBC5.1 Driver] Unknown MySql server host "BR123XL" (11001)

I have not found any documentation on this anywhere.

What can I do to resolve this condition?

Post Comment

  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. Beside the tag style "<foo>" it is also possible to use "[foo]". PHP source code can also be enclosed in <?php ... ?> or <% ... %>.