Page 1 of 1

ODBC - SQL_ERROR (servlets/TOMCAT)

Posted: Sun Jul 22, 2007 7:27 pm
by chiching72
Hello,

I am trying to create a Data Source Name for MySQL with ODBC and I keep getting an error. I am trying to get servlets to work with JSP and MySQL database. I used PHP before and the database can be accessed fine.

The error is:

Code: Select all

[ODBC 3.51 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error: 0
[/b]

Perhaps I am not configuring it correctly? 
I am using TOMCAT for Apache and so I am entering a localhost on Port 8080... Should the server be 'localhost' with  '8080' under Connect Options or 'localhost:8080'? Is a user and password specified somewhere else or can I just make one up there?

Can someone tell me what I am doing wrong or give me instructions on how to make this work? Thanks for any help.[/b]