Hello.
Maybe you have old includes too, use -I to specify the location of
4.1.13 includes.
Sujay Koduri <[EMAIL PROTECTED]> wrote:
>
> Hi gleb,
>
> I am including the packages which I tried to install along with the program
> and the error I am getting when I tried running it.
>
> Packages
>
> MySQL-client-4.1.13-0.i386.rpm
> MySQL-server-4.1.13-0.i386.rpm
> MySQL-devel-4.1.13-0.i386.rpm
> MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm
>
> The error I am getting for the below program is
>
> Binding of columns failed
> 2036: Using unsupported buffer type: 0 (parameter: 1)
>
> I tried running the program using the following command.
> gcc -g prog_name -lmysqlclient
>
> This is the program I am going to test.
>
> #include <stdio.h>
> #include <mysql/mysql.h>
> #define INSERT "select column_name from information_schema WHERE Table_Name
> = ?"
> //This table is already existing. All the columns in the table are of type
> varchar.
>
> int main()
> {
> MYSQL mysql;
> MYSQL_STMT *stmt;
> MYSQL_BIND bind[1];
> MYSQL_BIND bind_result[1];
> char str_in[50], str[2];
> unsigned long length[1];
> unsigned long str_in_len;
> my_bool is_null[1];
>
> if(!mysql_init(&mysql))
> {
> exit(3);
> }
>
> if(!mysql_real_connect(&mysql, "localhost","user", "pass", "db", 0, NULL,
> 0))
> {
> printf("%d: %s \n",mysql_errno(&mysql), mysql_error(&mysql));
> exit();
> }
>
> stmt = mysql_stmt_init(&mysql);
> if(!stmt)
> {
> printf("Out of memory..\n");
> exit(3);
> }
>
> if ( mysql_stmt_prepare(stmt, INSERT, strlen(INSERT)) )
> {
> printf("Prepare statement failed for insertion..:( \n");
> exit(3);
> }
>
> bind[0].buffer_type = MYSQL_TYPE_VAR_STRING;
> bind[0].buffer = (char *)str_in;
> bind[0].buffer_length = 50;
> bind[0].is_null = 0;
> bind[0].length = &str_in_len;
>
> strncpy(str_in, "information_schema", 50);
> str_in_len = strlen(str_in);
>
> if ( mysql_stmt_bind_param(stmt,bind) )
> {
> /*****Failing here ******/
> printf("Binding of columns failed\n");
> printf("%d: %s \n",mysql_stmt_errno(stmt), mysql_stmt_error(stmt));
> exit(3);
> }
>
> if (mysql_stmt_execute(stmt))
> {
> printf("Executing prepared statement failed\n");
> exit(3);
> }
>
> memset(bind_result, 0, sizeof(bind_result));
> bind_result[0].buffer_type = MYSQL_TYPE_STRING;
> bind_result[0].buffer = (char *)str;
> bind_result[0].buffer_length = 2;
> bind_result[0].is_null = &is_null[0];
> bind_result[0].length = &length[0];
>
> if (mysql_stmt_bind_result(stmt, bind_result))
> {
> printf(" mysql_stmt_bind_result() failed\n");
> printf(" %s\n", mysql_stmt_error(stmt));
> exit(0);
> }
>
> /* Now buffer all results to client */
> if (mysql_stmt_store_result(stmt))
> {
> printf(" mysql_stmt_store_result() failed\n");
> printf(" %s\n", mysql_stmt_error(stmt));
> exit(0);
> }
>
> while (!mysql_stmt_fetch(stmt))
> {
>
> if (is_null[0])
> printf(" NULL\n");
> else
> printf(" %s(%ld)\n", str, length[0]);
>
> }
>
> printf("The no of rows affected are %d\n",mysql_stmt_affected_rows(stmt));
> if (mysql_stmt_close(stmt))
> {
> printf("Error while closing mysql statement\n");
> exit(3);
> }
> mysql_close(&mysql);
> return 0;
> }
>
>
> Thank you
> sujay
>
> -----Original Message-----
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 11, 2005 2:58 PM
> To: mysql@lists.mysql.com
> Subject: Re: Uninstalling the MySQL cleanly.
>
> Hello.
>
> I guess you have rpm installation, rpm -e should help you in this case.
> Find installed mysql packets with `rpm -qa |grep -i mysql` command.
> If you have troubles with making a choice, send the list of packets which
> you got to the list.
>
>
> Sujay Koduri <[EMAIL PROTECTED]> wrote:
>>
>>
>>
>>>
>>> OS is RH9 and kernel is 2.4.20
>>
>> I suggest you send this to the MySQL list :-)
>>
>> With regards,
>>>
>>> > Can any one list the steps or give me any pointers how to cleanly
>>> uninstall
>>> > an upper version of MySQL,
>>> > so that after wards if we install lower version it should not be
>>> > affected
>>> by
>>> > any left overs of the previous installation.
>>>
>>> What OS?
>>>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> <___/ www.mysql.com
>
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
