Hi,

I'm trying to connect to mysql using mm.mysql 1.2b, and having a bit of
difficulty.

on the line where you call the database url after establishing the
connection with the jdbc driver, it gives an error saying to make sure there
is mysql database active on the ipaddress or the port specified.  however
the database is up and running and i can access it using the console just
fine.  jsp for some reason keeps thinking that the database is not running.
If I then change the password to a wrong one, then it says "bad handshake",
and if I don't provide any password it rejects the access, so the database
is responding to the script, but it doesn't approve my connection.

Here is the line:
Connection connection 
DriverManager.getConnection("jdbc:mysql://localhost:3306/test_db?user=test&p
assword=password");

"java.sql.*" had been imported at the top of the page.

what am i doing wrong?

Cheers,

Takuya



-----Original Message-----
From: Danny Ayers [mailto:danny@p...]
Sent: Thursday, April 05, 2001 5:15 PM
To: Pro_JavaServer_Pages
Subject: [pro_jsp] RE: set up mysql database to jsp?!


Personally I'd opt for the mm JDBC driver as this connects directly to the
database without going through ODBC, which cuts out one possible source of
errors. The bonus is that if you decide to move any of the system to a
non-MS machine then everything should still work. The drivers don't actually
need installing apart from being visible on your classpath.

---
Danny Ayers
http://www.isacat.net

<- -----Original Message-----
<- From: lingling lee [mailto:linglinglee@h...]
<- Sent: 04 April 2001 23:04
<- To: Pro_JavaServer_Pages
<- Subject: [pro_jsp] set up mysql database to jsp?!
<-
<-
<- I have been trying to set up jdbc(JDK 2) to mysql on NT.  I have
<- installed
<- myodbc already. I am not sure whether I need to install jdbk or
<- mm.myhsql.jbdc?! If I do need to install, do I put in any
<- directory of my
<- choice?
<- Does anyone out there know a good source for this?
<- Thanks in advance,
<- Ling