If it is a TYPE IV driver means, ODBC won't come into picture. But the error string whatever you got shows that, you are trying to connect it through JDBC:ODBC bridge driver. Please refer to your driver manual for more information for making the connection with MySQL. If you are using mmmysql driver, please refer to the following link for more information. http://mmmysql.sourceforge.net/doc/mm.doc/book1.htm Thank you Venu Anuganti ----- Original Message ----- From: "shane" <[EMAIL PROTECTED]> To: "Venu Anuganti" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 12:11 AM Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message > 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 --------------------------------------------------------------------- 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
