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

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: dedicated per-connections in the mutlithreading program

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 multithreadin

Re: MySQL C API Version incompatibility

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: http://lists.

Re: MySQL C API problems

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: > >

Re: MySQL C API problems

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: > >

Re: MySQL C API problems

Password hashing was changed in 4.1 to improve authentication security, but this complicates backward compatibility. See the manual for details: Your best bet is to link your app against

Re: mySQL C++ API (which libraries)

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 --- An

Re: MySQL C API questions

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 som

RE: MySQL C API questions

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: M

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

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 c

Re: MySQL C API license

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

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 here

RE: MySQL C API

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 co

RE: MySQL C API

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 b

Re: MYSQL C++ API

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 m

Re: Mysql C API problems

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

RE: Mysql C API problems

> 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 documentation

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_us

Re: MySQL C API documentation

* Michael Widenius <[EMAIL PROTECTED]> [02/03/26 12:41]: > Konstantin> class Cursor > Konstantin> { > Konstantin>Cursor(MYSQL_RES *res):_res(res) {} > Konstantin>bool fetch() { return mysql_fetch_row(_res); } > Konstantin>Row row() { return Row(_res->current_row); } > Konstantin>~

Re: MySQL C API - Lost connection?

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 w

Re: MySQL C API - Lost connection?

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.. An

Re: mysql c api

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" #d

Re: mysql c api

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

Re: Mysql C API Problem

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

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 sa

Re: MYSQL C API

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 t

Re: MYSQL C API

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

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 > co

Re: MySQL C API multiple connections

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

Sinisa Milivojevic wrote: > > Hi! > > I made an error in my previous message. All three instances should be > like this: > > connX = mysql_init(NULL); > if (!mysql_real_connect(connX, ip2, user2, pass2, db2, 0, NULL, 0)) > error . > By the way it seems to me that in 3.23.XX series mys

Re: MySQL C API multiple connections

Valerio Ferrucci writes: > John Dean wrote: > > > Hi > > I think you should check the API documentation > > Can you point me to some docs about this? > > > because you code example is > > wrong. Each connection should have its own initialized connection handle. > > You have only initi

Re: MySQL C API multiple connections

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, u

RE: MySQL C API multiple connections

Valerio, It seems to me, that you need to init (mysql_init) serveral times; I have not tried this but I would try the following: MYSQL conn1, conn2, conn3; conn1 = mysql_init(NULL) if ( mysql_real_connect(conn1, ip1, user1, pass1, db1, 0, NULL

Re: MySQL C API multiple connections

John Dean wrote: > Hi > I think you should check the API documentation Can you point me to some docs about this? > because you code example is > wrong. Each connection should have its own initialized connection handle. > You have only initialized one data structure i.e. mysql, which is passed >