At the moment I have a Netbeans project that works completely.
I've a local MySQL database. The connection with the database happens here.
SERVLET
DATAACCESS
In the web.xml file are the values for url, password, login and driver.
But now I want to publish it online. So I have an online MySQL database. My .war file is also online but they can't connect.
I think I need an ODBC DSN connection. And I can only choose from:
SQL Server
Microsoft Access Driver (*.mdb)
MySQL ODBC 3.51 Driver
Microsoft Excel Driver (*.xls)
I have tried using the MySQL ODBC 3.51 Driver but all the connection parameters I tried were wrong.
(I can change my MySQL database into a MS SQL database if this is easier.)
I hope someone can help me with this issue.