Re: MySQL C API: dedicated per-connections in the mutlithreading program

2006-09-08 Thread Philippe Poelvoorde
2006/9/8, Andrew W. Nosenko [EMAIL PROTECTED]: Sorry, but documentation on the MySQL C API say nothing about many interesting questions. The one of them: is it safe (or unsafe) to use non-MT client library (libmysqlclient.*, as opposite to the MT-aware libmysqlclient_r.*) for the multithreading

Re: MySQL C API: dedicated per-connections in the mutlithreading program

2006-09-08 Thread Andrew W. Nosenko
On 9/8/06, Philippe Poelvoorde [EMAIL PROTECTED] wrote: 2006/9/8, Andrew W. Nosenko [EMAIL PROTECTED]: Sorry, but documentation on the MySQL C API say nothing about many interesting questions. The one of them: is it safe (or unsafe) to use non-MT client library (libmysqlclient.*, as

Re: MySQL C API Version incompatibility

2005-08-11 Thread Warren Young
Sujay Koduri wrote: I was connecting to MySQL 5.0.4 through the C API and it was workign fine. But when I downgraded to MYSQL 4.1.13, the same code is giving the following error. Try rebuilding your program against the v4.1 APIs. -- MySQL General Mailing List For list archives:

Re: MySQL C API problems

2005-03-25 Thread Michael Stassen
Password hashing was changed in 4.1 to improve authentication security, but this complicates backward compatibility. See the manual for details: http://dev.mysql.com/doc/mysql/en/old-client.html http://dev.mysql.com/doc/mysql/en/password-hashing.html Your best bet is to link your app against

Re: MySQL C API problems

2005-03-25 Thread Andrew Prock
On Fri, 25 Mar 2005, Michael Stassen wrote: Password hashing was changed in 4.1 to improve authentication security, but this complicates backward compatibility. See the manual for details: http://dev.mysql.com/doc/mysql/en/old-client.html

Re: MySQL C API problems

2005-03-25 Thread Andrew Prock
On Fri, 25 Mar 2005, Andrew Prock wrote: On Fri, 25 Mar 2005, Michael Stassen wrote: Password hashing was changed in 4.1 to improve authentication security, but this complicates backward compatibility. See the manual for details: http://dev.mysql.com/doc/mysql/en/old-client.html

Re: mySQL C++ API (which libraries)

2005-01-11 Thread Karam Chand
The one supported by MySQL AB and the best till date is MySQL C API (well its best because I am C developer). It is the speediest too. I think you should find wrappers over the C API() over the net. If not then you can develop one for yourself and probably release it in GNU. Regards, Karam ---

RE: MySQL C API questions

2004-12-06 Thread Dave Juntgen
Prepared Statements, only offered in 4.1 API's. http://dev.mysql.com/doc/mysql/en/C_API_Prepared_statements.html David W. Juntgen Medical Informatics Engineering Inc. Phone: 260.459.6270 Fax : 260.459.6271 -Original Message- From: Mads Kristensen [mailto:[EMAIL PROTECTED] Sent:

Re: MySQL C API questions

2004-12-06 Thread Aftab Jahan Subedar
Hey check the MySQL C API By Example site. http://www.geocities.com/jahan.geo Yes you have to convert the data always and its zero terminated. Mads Kristensen wrote: Hi all. I'm using the MySQL C API to interface with my MySQL 4.1 server and I have the following questions: When I do a SELECT of

Re: mysql c-api 1064 mysql_real_query: issue with upgrade to 4.1.3

2004-08-28 Thread Aftab Jahan Subedar
Can you check the client version and server version from c api? you can copy paste it from (ehem) http://www.geocities.com/jahan.geo/mysql_c_by_example.html VY wrote: Hi, For some reason, all my sql queries fail with a 1064; These were all working under mysql-4.0 but had to upgrade to 4.1 so i

Re: MySQL C API license

2004-03-05 Thread Bernard Clement
To my knowledge it is GPL. Bernard On Friday 05 March 2004 17:52, Ronald J. Yacketta wrote: Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General

RE: MySQL C API

2003-09-10 Thread Tom Roos
whats the error u get? -Original Message- From: Håkan Medin [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 10:31 To: [EMAIL PROTECTED] Subject: MySQL C API Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't

RE: MySQL C API

2003-09-10 Thread Rick Robinson
Håkan- The prepared statement capability isn't available until 4.1 (I believe). Best of luck, Regards, Rick -Original Message- From: Håkan Medin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 4:31 AM To: [EMAIL PROTECTED] Subject: MySQL C API Hello All, I am trying to

Re: MySQL C API

2003-09-10 Thread Paul DuBois
At 10:30 +0200 9/10/03, Håkan Medin wrote: Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't be found.. This function is one of those use for handling prepared statements. They're not available until 4.1, as indicated

Re: MYSQL C++ API

2002-09-27 Thread Stefan Fleiter
Paco wrote: I'm having probles with the c++ api of mysql... could somebody help me plesae? Could be, maybe you should post your specific problem. - Before posting, please check: http://www.mysql.com/manual.php (the

RE: Mysql C API problems

2002-06-29 Thread Dean Harding
1 - if i wanna make an action based on the fact that a query i just made won't return results (empty set), how can i test that? will this do? if(!mysql_query(myData, query) { results = mysql_store_results(myData); if(mysql_num_rows() == 0) { //action; } }

Re: Mysql C API problems

2002-06-29 Thread Georg Richter
On Saturday, 29. June 2002 11:15, Hugo Veiga wrote: Hello Hugo, will this do? if(!mysql_query(myData, query) { results = mysql_store_results(myData); -if(mysql_num_rows() == 0) +if (!mysql_num_rows(results)) { //action; } } with the above correction it should

Re: MySQL C API documentation

2002-03-26 Thread Konstantin Osipov
* Michael Widenius [EMAIL PROTECTED] [02/03/26 12:41]: Konstantin class Cursor Konstantin { KonstantinCursor(MYSQL_RES *res):_res(res) {} Konstantinbool fetch() { return mysql_fetch_row(_res); } KonstantinRow row() { return Row(_res-current_row); } Konstantin~Cursor() {

Re: MySQL C API documentation

2002-03-26 Thread Sinisa Milivojevic
Konstantin Osipov writes: * Michael Widenius [EMAIL PROTECTED] [02/03/26 12:41]: But, according to MYSQL C API documentation, 8.4.2, (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_function_overview) I have to do this: An advantage of mysql_use_result()

Re: MySQL C API - Lost connection?

2001-11-25 Thread David Bouw
I don't know if this will answer the question: Is MySQL located on the same computer your script/software is running on..?? If this is not the case you have a chance that your network connection to the computer which MySQL is running on loses some packets which results in the above problem..

Re: MySQL C API - Lost connection?

2001-11-25 Thread Benjamin Charles Tehan
The MySQL server is localhost. As for checking if the query was successful or not, this was the check, and that was the result of the failure. if (mysql_query(mysql,sqlcmd)) logger([sql] %s\n%s \n\n,sqlcmd,mysql_error(mysql)); sqlcmd is the query If the query fails logger() is executed

Re: mysql c api

2001-09-04 Thread Carl Troein
ahmed writes: hi all i hope that some one send me a programme illustrating how to access to mysql database with c api .. ahmed Please don't repost just because you didn't like the answers you got the first time. Someone pointed you to C sources, and there are plenty of those available on

Re: mysql c api

2001-09-04 Thread Philip Mak
On Tue, 4 Sep 2001, ahmed wrote: i hope that some one send me a programme illustrating how to access to mysql database with c api .. I run a site that has a free e-mail forwarding service. The following program is what runs .qmail-default. #define HOST localhost #define USER username #define

Re: Mysql C API Problem

2001-09-01 Thread Uwe Sander
just add mysql_init(csql); before accessing the struct for any purpose. Sure it helps (I made the same mistake, got the same result ;-) Uwe - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 01, 2001 8:25 PM Subject: Mysql C API Problem

Re: MYSQL C API

2001-05-04 Thread VVM Ravikumar Sarma Chengalvala
Hi PAUL, 1.Thanks for the mail. 2.Regarding the return values I wonder anyone else has encountered other than the values -1,0 for mysql_query(). 3. I will try our the option suggested by you for mysql_real_connect(); 3. Another thing does mysql_api has any provision to send the error messages to

Re: MYSQL C API

2001-05-04 Thread Paul DuBois
At 3:03 PM +0100 5/4/01, VVM Ravikumar Sarma Chengalvala wrote: Hi PAUL, 1.Thanks for the mail. 2.Regarding the return values I wonder anyone else has encountered other than the values -1,0 for mysql_query(). You need to stop asking this question. The function is explicitly documented to say

Re: MYSQL C API

2001-05-03 Thread Paul DuBois
At 8:13 PM +0100 5/3/01, VVM Ravikumar Sarma Chengalvala wrote: Hi, 1. I am using C_API for accessing data from MYSQL. 2. mysql_query() function returns the following values: 0 if the query is successful -1 if the query fails. No. It returns 0 if the query is successful and NON-ZERO if it

Re: MySQL C API: Problem with load_defaults

2001-01-20 Thread Paul DuBois
On Sat, Jan 20, 2001 at 02:53:22PM -0500, Hlady, Brian wrote: I'm using the code found on page 245 - 247 of Paul Dubois' book, MySQL. When I attempt to make it under Code Crusader, I get the error found below. gcc -g -Wall -Werror -I- -I. -I/usr/local/include/mysql -c common.c -o

Re: MySQL C API multiple connections

2001-01-13 Thread Sinisa Milivojevic
alex writes: By the way it seems to me that in 3.23.XX series mysql_init() returns address not of the starting point of the allocated memory pool but a point somewhere further (like to provide hidden data not included in "official" MYSQL structure). Hence when trying to use

Re: MySQL C API multiple connections

2001-01-12 Thread Sinisa Milivojevic
Valerio Ferrucci writes: Hi, I'm building a MySQL C API client. I need to connect to different dbs at the same time. My code is (approximately): // MYSQL mysql, *conn1, *conn2; mysql_init(mysql) conn1 = mysql_real_connect(mysq, ip1, user1,