Hi, I have written in intermediate, on the appropriate position in this discussion, please go thru in full.
--- Michael Widenius <[EMAIL PROTECTED]> wrote: > > hi! > > >>>>> "A" == Arunachalam <[EMAIL PROTECTED]> writes: > A> As per my searching I have found the right C API in libmysql.lib from > A> MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???) > A> C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), > A> mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()... > > You should probablty use MySQL 4.1 instead of MySQL 5.0 for testing > this as we make more often releases for 4.1 than for 5.0 (until 4.1 is > production ready). I didn't find the API's what I have specified above in MySQL 4.1.1 in *libmysql.dll*, but those API's are provided by *mysqlclient.lib* in this version. I have created COBOL specific *libmysql.lib* from existing *libmysql.dll* becaz libmysql is Dynamic Access Library - right. (what I have did to convert libmysql.dll file into COBOL compiler specific *libmysql.lib* is by using an utility *pexports.exe*, i have convert given libmysql.dll into libmysql.def file then by using LIB.EXE of COBOL compiler convert libmysql.def into libmysql.lib file.) > A> I have installed MySQL 5.0.0-alpha for Windows and I have properly linked > A> thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing > A> mechanism to the API routines i have taken the sample C code from MySQL > A> manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * ) > > A> When I compiled this sample coding using VC++, it ask for *typelib.h* header > A> file, it is not given with insatllation pack, under the Mysql folder > A> (C:/MySQL/Include), I have searched on the net and include it accordingly. > > Thanks for notifying us about this. typelib.h should be included in > the MySQL folder and we will do that for next MySQL windows release. > (4.1.2) > > A> After that i have made changes in some variable names becaz of it follows > A> other header files variable name as such. > > What changes did you have to make ? > Including typelib.h should be enough. When I try to first compile this program in VC++ it notify the mismatch variable as MYSQL_BIND bind[3]; which is already used by <winsock.h> header file, so I have change this variable into *Pbind* like this. (I have doubt: after your discussion i once again compiled it with previous name(i.e, bind) it never produce any error). The variable mysql used in other API's to be changed to *&mysql*, I have changed this after meeting the following errors; D:\vcprojects\mysql\src\source.c(41) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(41) : warning C4024: 'mysql_query' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(44) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(44) : warning C4024: 'mysql_error' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(48) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(58) : warning C4024: 'mysql_prepare' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(62) : error C2115: 'function' : incompatible types > I will ask our windows team to verify that the example works ok with > VC++ > > A> Upon all the changes I can able to execute succcessfully the coding and it > A> does the function properly on the MySQL server database. > > A> The PROBLEM I met is, Once this sample code executed and inserted data to > A> the Database the server get's hanged - why??????????????? After the discussion with you only i came to listen mysqld.trace, but it's content cann't be understand by me, herewith I have attached that file for your reference. anyhow i understand that there is some Memory alloca/dealloc problem hangs up my MySQL server. > This shouldn't happen. > Can you please describe exactly what you mean with a 'hang' ? > > - Does the connection in your test program stop respoding ? Yes, if I run the client C program again, the console ouput stay blank with out any message. > - Can you connect to mysqld with other clients ? No, WinMySQLAdmin tool won't allow me to right click on it mysql -u user -ppass also stay as such when i try it from console > - Does the MySQL server take all cpu No, I can work with other application with out any trouble. I hope I have given here enough information to identify my trouble, suggest me in detail ASAP please... Thanks a lot... Regards, 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]
