--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu Anuganti <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Redwood city, California USA
<___/ www.mysql.com
----- Original Message -----
From: "Luc Lalancette" <[EMAIL PROTECTED]>
To: "Venu Anuganti" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 10:04 PM
Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
(Using password: No) message
> Thanks again... It seems that I owe you one it worked.
> Luc
> ----- Original Message -----
> From: "Venu Anuganti" <[EMAIL PROTECTED]>
> To: "Luc Lalancette" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, July 18, 2001 10:54 PM
> Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for
user...
> (Using password: No) message
>
>
> > Hi Luc
> >
> > Here is the common syntax, that is used as the connection string through
> > JDBC-ODBC Driver.
> >
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > String url = "jdbc:odbc:TestDSN";
> > Coonection con = DriverManager.getConnection(url,"username","password");
> >
> > Before connecting, make sure you intslled the ODBC Driver and configured
> the
> > DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error
> > below, it looks you have the valid DSN, but you didn't supply the UID
and
> > PWD in the connection string.
> >
> > Thank you
> > Venu Anuganti
> >
> > ----- Original Message -----
> > From: "Luc Lalancette" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 18, 2001 3:02 PM
> > Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user...
> > (Using password: No) message
> >
> >
> > I am starting using mysql and I made a java SimpleQuery servlet that is
> > suppose to retreive one row from the database. However, when I try to
> > connect I get that message from the Subject. I know I'm suppose to pass
> the
> > password but can't seem to find a way of doing it. I was wondering if
the
> > problem was with those two lines or if it was in the tdx mysql driver
> > default configuration in the ODBC.
> >
> > Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > dbConn = DriverManager.getConnection("jdbc:odbc:TestDSN;");
> >
> > I would appreciate if someone could help me to get my connection going.
> > Thank you very much
> > Luc Lalancette
> >
> >
---------------------------------------------------------------------
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
