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]