>I writen a application in vb.net with the MySQL Connector/NET 1.0 provider.Try using the command-line utility 'mysql' to connect.>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
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.
Ask your ISP.>1) How can I find the right address?
Ask your ISP.>2) Must I use a special port?
Yes, it's possible. Likely, even. Who do you think you should ask?>3) Or is it possible that my ISP didn't allowed to connect from an other IP
>than the localhost?
Gordon L. Burditt