I'm using following string (JDBC without dsn) which works fine:
DBName --> MySQL Database name
USERNAME --> username
PASS ---> password
>From: Sai Koneru <spkoneru@stripped>
>To: mysql@stripped, myodbc@stripped
>Subject: problem with mysql and myodbc--from saikoneru
>Date: Thu, 21 Sep 2000 21:19:26 -0700 (PDT)
>i have seen lot queries in the list talking about the
>same but my problem is bit peculier(i feel)
>i am using asp and myodbc to contact mysql using root
>username and no password and this is failed with error
>access denied with following error.
>[TCX][MyODBC]Access denied for user: 'root@KCPL'
>(Using password: YES)
>but i could able to login directly with the same.
>I tried both dsn less connection and dsn connection
>I read the lists and try to go for grants but the
>install_mysql_db script is not available but all the
>privilege tables are available.
>I didn't modify anything after installtion.
>i have beed posted same question before and mr john
>answered me to go through mysql lists which didn't
>fetch me any help
>i am desparate to get this right.
>Could anybody guide me exactly what do next.
>thanks in advance
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>Please check "http://www.mysql.com/documentation/manual.php" before
>posting. To request this thread, e-mail mysql-thread51333@stripped
>To unsubscribe, send a message to:
>If you have a broken mail client that cannot send a message to
>the above address (Microsoft Outlook), you can use:
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at