Professional Web Applications Themes

How do I connect with MySQL Connector/NET 1.0 - MySQL

Dear people, I writen a application in vb.net with the MySQL Connector/NET 1.0 provider. But I can't get a connection with the MySQL database. The database is running at my ISP. I think there's something going wrong with the right serveradres. 1) How can I find the right address? 2) Must I use a special port? 3) Or is it possible that my ISP didn't allowed to connect from an other IP than the localhost? Greetings...

  1. #1

    Default How do I connect with MySQL Connector/NET 1.0

    Dear people,

    I writen a application in vb.net with the MySQL Connector/NET 1.0 provider.
    But I can't get a connection with the MySQL database. The database is
    running at my ISP. I think there's something going wrong with the right
    serveradres.

    1) How can I find the right address?
    2) Must I use a special port?
    3) Or is it possible that my ISP didn't allowed to connect from an other IP
    than the localhost?

    Greetings


    Gerrit de Haan Guest

  2. #2

    Default Re: How do I connect with MySQL Connector/NET 1.0

    >I writen a application in vb.net with the MySQL Connector/NET 1.0 provider.
    >But I can't get a connection with the MySQL database. The database is
    >running at my ISP. I think there's something going wrong with the right
    >serveradres.
    Try using the command-line utility 'mysql' to connect.
    mysql -h mysqlserver.isp.com -u whatever -pdrowssap mydatabase
    (Also add -P port# in with the options if your ISP gave you a
    specific port to use). Note any error message produced if it fails.
    If that works, chances are you've got problems setting up the
    connection with MySQL Connector. If it doesn't work, you have
    problems with the connection info and/or net connectivity.

    If that doesn't work, try using telnet to port 3306 (or whatever
    port your ISP told you to use) on the host you think the server is
    on. If you get 'connection refused', you have the wrong host or
    wrong port. It's a binary protocol, so you can't actually log in
    with telnet, but it verifies the server is reachable.
    >1) How can I find the right address?
    Ask your ISP.
    >2) Must I use a special port?
    Ask your ISP.
    >3) Or is it possible that my ISP didn't allowed to connect from an other IP
    >than the localhost?
    Yes, it's possible. Likely, even. Who do you think you should ask?

    Gordon L. Burditt
    Gordon Burditt Guest

  3. #3

    Default Re: How do I connect with MySQL Connector/NET 1.0

    Gerrit de Haan wrote:
    > Dear people,
    >
    > I writen a application in vb.net with the MySQL Connector/NET 1.0 provider.
    > But I can't get a connection with the MySQL database. The database is
    > running at my ISP. I think there's something going wrong with the right
    > serveradres.
    >
    > 1) How can I find the right address?
    > 2) Must I use a special port?
    > 3) Or is it possible that my ISP didn't allowed to connect from an other IP
    > than the localhost?
    >
    > Greetings
    >
    >
    A lot of useful information on this subject for novices and experts alike can be found in this site:
    [url]http://www.vbmysql.com/articles[/url]

    ciao
    gmax

    --
    _ _ _ _
    (_|| | |(_|>< The Data Charmer
    _|
    [url]http://datacharmer.org/[/url]
    Giuseppe Maxia Guest

  4. #4

    Default Re: How do I connect with MySQL Connector/NET 1.0

    > Try using the command-line utility 'mysql' to connect.
    > mysql -h mysqlserver.isp.com -u whatever -pdrowssap mydatabase
    Where did if find the command-line utility?


    Gerrit de Haan Guest

  5. #5

    Default Re: How do I connect with MySQL Connector/NET 1.0

    Gerrit de Haan wrote:
    >> Try using the command-line utility 'mysql' to connect.
    >> mysql -h mysqlserver.isp.com -u whatever -pdrowssap mydatabase
    >
    > Where did if find the command-line utility?
    Download a mysql package and unpack it. You will find mysql.exe in there.


    Paul Lautman Guest

Similar Threads

  1. MySQL Connector/J - driver not recognised
    By erasmus in forum Coldfusion Server Administration
    Replies: 1
    Last Post: October 22nd, 01:49 PM
  2. mysql-connector-java sadness
    By Walter Vaughan in forum MySQL
    Replies: 3
    Last Post: May 11th, 01:08 PM
  3. Help! MySQL Connector/J too slow for production use!
    By shirai in forum Coldfusion Database Access
    Replies: 1
    Last Post: March 13th, 01:24 PM
  4. Replies: 0
    Last Post: January 29th, 02:03 PM
  5. MySQL 4.1 & CFMX 6.1 connector problems
    By Babray in forum Coldfusion Database Access
    Replies: 13
    Last Post: September 29th, 12:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139