Hi, the driver which i am using is type IV. do i still need to install myodbc? thks -----Original Message----- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:04 PM To: shane Cc: [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi Shane To connect to MySQL using JDBC Driver, it depends up on the type of JDBC driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER) then you need MyODBC installed on the system and configured properly as explained in the earlier mail in the mysql list. Here is the link, which tells different types of JDBC drivers in the world. http://java.sun.com/products/jdbc/driverdesc.html < or > http://www.jguru.com/faq/view.jsp?EID=691 Let us know, what type of JDBC driver are you using to connect to MySQL ? Thank you Venu Anuganti ----- Original Message ----- From: "shane" <[EMAIL PROTECTED]> To: "Venu Anuganti" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 10:39 PM Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message > i am using the mmmysql jdbc driver, and i was wondering whether i need to > install myodbc. > i'm running mysql server on a linux machine and the binary version of the > download from > www.mysql.com does not include the odbc driver and the libraries required > for myodbc. > I'm running on a i686 but the rpm version they have is for i386 system > > thks > shane > > -----Original Message----- > From: Venu Anuganti [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 12:55 PM > To: Luc Lalancette; [EMAIL PROTECTED] > 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 > --------------------------------------------------------------------- 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