Arun, You are back to the same issue. This has nothing to do with MyODBC. The parameters you are passing are not the correct data types. If no username is passed, the user 'ODBC' is supplied. If no host is passed 'localhost' is supplied. The parameter you are passing for the password is being read (not necessarily correctly), but some value is being passed as the password.
You need to have someone familiar with your flavor of COBOL show you how to pass the specific data types that the mysql library requires (based upon the MySQL C API). When your are able to pass and confirm the correct data types to the C functions, the process may work (assuming the callout from COBOL works as advertised). Until you can confirm the data types are being correctly interpreted when passed from COBOL to the function, your only going to experience serendipitous success. You need to solve the problem sequentially and the next step here is confirming the data types and parameters being passed from your COBOL code. Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP > > ----- 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
