I think MyODBC in this situation is irelevant. ODBC reinterpret the SQL language (and is good for some universal data components like ADO,DAO,...), but MySQL C API is native. Also you can't connect by MyODBC using MYSQL C API. So you really didn't forget some parameter??, it seems like. Otherwise try to create user named ODBC, and you will see, also it writes "Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*", so you are using some password, and question is from where this goes, and which password you have to give to user ODBC. I still thing that you must omit some parameter when establishing connection. (But I never tried to make connection from COBOL, I'm just using MYSQL C API from C++)
----- Original Message ----- From: "Arunachalam" <[EMAIL PROTECTED]> To: "KKoTY" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 06, 2004 6:21 AM Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > I have installed MyODBC 3.51 and created the DSN for my Database. > > I want to clarify that; > If the User name I have given is could not be resolved by mysal_real_connect, > then it automatically establish the connection to the server using > [EMAIL PROTECTED] - right > > If so, Is there need to have the user named ODBC in mysql database. > > OR > > It'll connect automatically using the DSN setting i have specified in myODBC. > > Becaz I don't have the source to check Is COBOL value passed to C > as such what I have specified? > > Please clarify my doubts... > > regards, > Arun. > > > --- KKoTY <[EMAIL PROTECTED]> wrote: > this occures when you ommit the user name, MYSQL C API uses > user ODBC as > > default when you ommit or enter empty string as > > user name when calling mysql_real_connect() > > > > ----- Original Message ----- > > From: "Arunachalam" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, February 05, 2004 3:38 PM > > Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > > > > > Hi all, > > > > > > Is any one met with the error while connecting to MySQL Server > > > > > > *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)* > > > > > > if so pleass let me know the remedy to resolve this error. > > > > > > > > > I don't have the user named ODBC in my mysql Database. > > > > > > my configuration is: > > > Windows 2000 SP 4. > > > MySQL Server 4.0.17-max-debug for windows > > > > > > The situation I have met this error is when I try to Connect MySQL > > > from COBOL using the C API provided by MySQL. I have properly link > > > the *libmysql.lib* file into my COBOL compiler. > > > > > > Any suggestion are highly appreciated... > > > > > > Thanks. > > > > > > regards, > > > Arun. > > > > > > ________________________________________________________________________ > > > Yahoo! India Mobile: Download the latest polyphonic ringtones. > > > Go to http://in.mobile.yahoo.com > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > ________________________________________________________________________ > Yahoo! India Mobile: Download the latest polyphonic ringtones. > Go to http://in.mobile.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
