-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
first a note: this is a topic best discussed on
[EMAIL PROTECTED]
* On Thu, Dec 12, 2002 at 08:35:40AM -0800, Muhammad Salman wrote:
> I am using the official type 4 mysql driver from
> www.mysql.com but unable to make a remote connection
> with the mysql database running on our companie's
> remote server. I mailed some mailing mailing lists but
> didnt find out the right answer yet. I am using the
> following code for simple remote connection test:
>
> Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> Connection con =
>
>DriverManager.getConnection("jdbc:mysql://66.137.7.185:3306/prefill","prefill","jeem");
> out.println("Testing Database Connectivity");
> Statement stmt = con.createStatement();
> ResultSet rs = stmt.executeQuery("select * from
> state");
> int i = 0;
> while(rs.next() && i < 10)
> {
> out.println("<h2> Output: "+rs.getString(2) +
> "</h2>");
> i ++;
> }
> rs.close();
> stmt.close();
> con.close();
that all looks pretty good. what error are you getting?
have you checked out the readme that comes with the driver?
it is pretty good at addressing some of the more often run
into problems of this variety.
- --
Peter Abplanalp
PGP: pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9+NFVggA8sH0iRXQRArzMAJwLngnF/ouMCFMEEU846oExQE3H5gCgsrGv
IICJvZ3VPu4+MUtBAKsTAkU=
=NLko
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
