RE: Tomcat-mysql configuration

[Panagiotis Konstantinidis]

Well I can tell you how my mySQL database works: . . . String url = "jdbc:mysql://isle:3306/football"; where: "jdbc:mysql" is the name of connection and the database. "isle" is the name of the server (you could have IP address instead of the name) on which the databse is and, "football" is the name of the database.       Class.forName="(org.gjt.mm.mysql.Driver"); which is the driver that must be loaded (I guess it is the same for all the mySQl databases - I am not entirely sure though)   Connection con = DriverManager.getConnection(url, "user", "password"); where "user" and "password" are the real iuser name and password that are used in order to grand you access to the database     Hope this helps. [Panagiotis Konstantinidis]  -----Original Message----- From: Sameer [mailto:[EMAIL PROTECTED]] Sent: 30 November 2000 12:58 To: [EMAIL PROTECTED] Subject: Tomcat-mysql configuration Hi everybody,   following is the code sample of a jsp file working in (Windows NT + SQLServer + Java Web Server) environment   ...... String url = "jdbc:odbc:testdsn"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection(url, "", ""); .......   what changes are necessary in the above code to make it work in (Linux + mysql + Tomcat) environment. Please help,   Thanks in anticipation Sameer