ODBC - SQL_ERROR (servlets/TOMCAT)

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
chiching72
Forum Newbie
Posts: 3
Joined: Tue Jun 26, 2007 8:40 pm

ODBC - SQL_ERROR (servlets/TOMCAT)

Post 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]
Post Reply