Hai MySQLians!!! I have established the Successful Connection to MySQL from COBOL.
Now from COBOL I can able to query the MySQL and get back the result sets using C APIs under MySQL 4.0.17-max both in windows and Linux. Note that my Client is in Windows platform... Its not enough for my application, I'm in need to use Prepared statements for further SQL processing... As per my searching I have found the right C API in libmysql.lib from MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???) C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()... I have installed MySQL 5.0.0-alpha for Windows and I have properly linked thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing mechanism to the API routines i have taken the sample C code from MySQL manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * ) When I compiled this sample coding using VC++, it ask for *typelib.h* header file, it is not given with insatllation pack, under the Mysql folder (C:/MySQL/Include), I have searched on the net and include it accordingly. After that i have made changes in some variable names becaz of it follows other header files variable name as such. Upon all the changes I can able to execute succcessfully the coding and it does the function properly on the MySQL server database. The PROBLEM I met is, Once this sample code executed and inserted data to the Database the server get's hanged - why??????????????? (Note that If I didn't run this coding or my COBOL coding the Server remain function properly) Kindly suggest me the solution or quote me the things i forgot to do... Thanks in advance Arun. ________________________________________________________________________ Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more. Go to: http://in.insurance.yahoo.com/licspecial/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
