ODBC connection

[Klave]

---

I just remembered something about "FLUSH" ..."FLUSH ALL" tingali to...

[niehrx]

hehe. old school. hmm. try imong firewall bro. and try if open ba ang port 3306.

[budzprog]

checked na nko firewaal and port 3306.. ok mn..

mka connect mnko sa akoa comp ra but if lain na comp ibutang ang akoa database dli nko mka link...

[messerchtmitt]

My few cents, I think you will need to install a MySQL-Client in your other computer as your workstation, and configure the ODBC that point to your server. Your server must be installed as MySQL-Server. Maybe that's one of the reason you could not connect to the server. It cannot detect the MySQL in the Server.

You should have installed MySQL both in your computer. One for the server as MySQL-Server and for the client as MySQL-Client.

Unless you are doing online (web apps), your computer doesn't need to install MySQL-client. But you are doing the desktop apps and using odbc, you should install MySQL-client in every computer that communicate to your server with MySQL-Server.

Hope this will solve your problem.

[fixyourself]

My few cents, I think you will need to install a MySQL-Client in your other computer as your workstation, and configure the ODBC that point to your server. Your server must be installed as MySQL-Server. Maybe that's one of the reason you could not connect to the server. It cannot detect the MySQL in the Server.

You should have installed MySQL both in your computer. One for the server as MySQL-Server and for the client as MySQL-Client.

Unless you are doing online (web apps), your computer doesn't need to install MySQL-client. But you are doing the desktop apps and using odbc, you should install MySQL-client in every computer that communicate to your server with MySQL-Server.

Hope this will solve your problem.

MySQL-Client? He already have the ODBC Connector driver, prolly there is something wrong with the network connection or the MySQL server does not accept remote connections.

[messerchtmitt]

@fixyourself:

Even if you have the ODBC MySQL driver connector still it won't work, you must install MySQL-Client in the workstation. If you are dealing with online or web applications of course it will connect remotely. In desktop apps especially using ODBC is different from online, you will need a client installation.

If you can check with the MySQL, it has client and server. That's the use of the client workstation.

As per budzprog, when clicking the "Test Connection" it didn't work or cannot connect considering the ODBC been configured correctly and network connection is okay. Your ODBC MySQL driver doesn't know where to connect that's why it needs to install MySQL-Client in the workstation. MySQL-Client will be used as bridge to the server thru ODBC MySQL driver.

[messerchtmitt]

Furthermore, setup your MySQL client DB connection to your server IPort, with authentication: username and password.

[fixyourself]

@fixyourself:

Even if you have the ODBC MySQL driver connector still it won't work, you must install MySQL-Client in the workstation. If you are dealing with online or web applications of course it will connect remotely. In desktop apps especially using ODBC is different from online, you will need a client installation.

If you can check with the MySQL, it has client and server. That's the use of the client workstation

Ai ambot lang sad sir hap..I'm not sure, but I've been developing web/desktops apps, datalayer/ORM frameworks.. but wala pako kasugat nga gi require ang MySQLClient para mo connect og remote MySQL server. The MySQL Connector does the job.

BTW, unsa imong gi mean nga MySQL Client? ang MySQL command line client?

[messerchtmitt]

@fixyourself:

MySQL Client - I mean that is a MySQL database software installed in the workstation. You can configure the MySQL as a Server or a Client database. That is not a command line.

I did this in my apps using VB.NET as front-end.

[fixyourself]

@fixyourself:

MySQL Client - I mean that is a MySQL database software installed in the workstation. You can configure the MySQL as a Server or a Client database. That is not a command line.

I did this in my apps using VB.NET as front-end.

I still don't get it, why need the MySQL Client software installed in your machine, the Connector library acts as a broker between the application and the MySQL server.