------=_NextPart_000_0009_01C46BDF.D71D30B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Can anyone help me here..... Im using Web based Cobol (PerCobol) that =
converts to Java.... Im trying to use the PREPARE and EXECUTE statements =
to create Complex queries.... I am currently using MySql version =
4.0.18 and trying to use JDBC driver version 3.1.3 Beta (the new =
release brought out to fix problems with Prepare??? ) Does this new =
JDBC driver only work with MySql versions 4.1 and newer?????=20

My problem is I cannot connect to the database, getting SqlState =
08000....

EXEC SQL=20

CONNECT TO "jdbc:mysql://127.0.0.1/imagescan"=20

DRIVER "com.mysql.jdbc.Driver"

END-EXEC.=20


=20

------=_NextPart_000_0009_01C46BDF.D71D30B0--

On Saturday 17 July 2004 08:24 am, Michael McQuade wrote:
Knowing nothing about PerCobol and not having enough detail about your problem
let me venture a few questions to help isolate your problem (SQLState 08000
means nothing to me):

* Can you connect to the MySQL session from the cmd line MySQL client (using
the machine running the program)?

* Do you need to specify a password? (If so, where is it specified in your
code?)

* Tried 'localhost' instead of '127.0.0.1'? Tried your system's hostname?


HTH,

Robert J Taylor

--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw