Urgent Pls....
Dear Sir/Madam, I'm totally strugling on choosing the mysql distribution for my RedHat Linux9.0. My system config is as follows. 1.Pentium 4 and Intel845 Chipset (Intel Original Board) 2.gcc version - (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) I'm trying to develop the client programs. Pls, help me on this as soon as possible. Thanks and Regards, Ashok. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help needed regarding MySQL-C Libraries on Linux....
Dear Friends, I'm Ashok here. first i'll tell my sys configuration. 1.Redhat-Linux 9 2.Intel Pentium chipset 3.MySQL 4.1 with Development Libraries For this i've downloaded the MySQL4.1 under the specification Linux x86 RPM downloads from the site. In my system, the MySQL Server is working well. I tried to run the C program that will make the connection to the MySQL database and create the user database and useracc table. It's finely working with Windows-VC++. But when i'm trying to run with Linux gcc, I'm getting lots of errors. I don't know what's the problem. I've attached the C-Pgm and the Error info. Pls, help me regarding this. Thanks and Regards, Ashok. Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com[EMAIL PROTECTED] CGI]# gcc -c -I/usr/lib/bcc/include -I/usr/include/mysql user.c In file included from /usr/include/pthread.h:20, from /usr/include/mysql/my_global.h:149, from user.c:3: /usr/include/sched.h:41: parse error before __THROW /usr/include/sched.h:44: parse error before __THROW /usr/include/sched.h:48: parse error before __THROW /usr/include/sched.h:51: parse error before __THROW /usr/include/sched.h:54: parse error before __THROW /usr/include/sched.h:57: parse error before __THROW /usr/include/sched.h:60: parse error before __THROW /usr/include/sched.h:63: parse error before __THROW In file included from /usr/include/mysql/my_global.h:149, from user.c:3: /usr/include/pthread.h:166: parse error before __THROW /usr/include/pthread.h:169: parse error before __THROW /usr/include/pthread.h:172: parse error before __THROW /usr/include/pthread.h:176: parse error before __THROW /usr/include/pthread.h:181: parse error before __THROW /usr/include/pthread.h:187: parse error before __THROW /usr/include/pthread.h:195: parse error before __THROW /usr/include/pthread.h:198: parse error before __THROW /usr/include/pthread.h:202: parse error before __THROW /usr/include/pthread.h:206: parse error before __THROW /usr/include/pthread.h:211: parse error before __THROW /usr/include/pthread.h:217: parse error before __THROW /usr/include/pthread.h:221: parse error before __THROW /usr/include/pthread.h:226: parse error before __THROW /usr/include/pthread.h:230: parse error before __THROW /usr/include/pthread.h:235: parse error before __THROW /usr/include/pthread.h:239: parse error before __THROW /usr/include/pthread.h:243: parse error before __THROW /usr/include/pthread.h:261: parse error before __THROW /usr/include/pthread.h:266: parse error before __THROW /usr/include/pthread.h:285: parse error before __THROW /usr/include/pthread.h:290: parse error before __THROW /usr/include/pthread.h:303: parse error before __THROW /usr/include/pthread.h:309: parse error before __THROW /usr/include/pthread.h:333: parse error before __THROW /usr/include/pthread.h:336: parse error before __THROW /usr/include/pthread.h:339: parse error before __THROW /usr/include/pthread.h:342: parse error before __THROW /usr/include/pthread.h:352: parse error before __THROW /usr/include/pthread.h:359: parse error before __THROW /usr/include/pthread.h:362: parse error before __THROW /usr/include/pthread.h:367: parse error before __THROW /usr/include/pthread.h:371: parse error before __THROW /usr/include/pthread.h:392: parse error before __THROW /usr/include/pthread.h:395: parse error before __THROW /usr/include/pthread.h:398: parse error before __THROW /usr/include/pthread.h:401: parse error before __THROW /usr/include/pthread.h:406: parse error before __THROW /usr/include/pthread.h:415: parse error before __THROW /usr/include/pthread.h:420: parse error before __THROW /usr/include/pthread.h:423: parse error before __THROW /usr/include/pthread.h:428: parse error before __THROW /usr/include/pthread.h:432: parse error before __THROW /usr/include/pthread.h:557: parse error before __THROW /usr/include/pthread.h:560: parse error before __THROW /usr/include/pthread.h:564: parse error before __THROW /usr/include/pthread.h:567: parse error before __THROW /usr/include/pthread.h:577: parse error before __THROW /usr/include/pthread.h:584: parse error before __THROW /usr/include/pthread.h:588: parse error before __THROW /usr/include/pthread.h:591: parse error before __THROW /usr/include/pthread.h:596: parse error before __THROW /usr/include/pthread.h:612: parse error before __THROW /usr/include/pthread.h:621: parse error before __THROW In file included from /usr/include/pthread.h:655, from /usr/include/mysql/my_global.h:149, from user.c:3: /usr/include/bits/sigthread.h:32: parse error before '*' token /usr/include/bits/sigthread.h:36: parse error before __THROW In file included from /usr/include/mysql/my_global.h:149, from user.c:3: /usr/include/pthread.h:673: parse error before __THROW /usr/include/pthread.h:678:
Help needed regarding MySQL-C Libraries on Linux....
Dear Friends, I'm Ashok here. first i'll tell my sys configuration. 1.Redhat-Linux 9 2.Intel Pentium chipset 3.MySQL 4.1 with Development Libraries For this i've downloaded the MySQL4.1 under the specification Linux x86 RPM downloads from the site. In my system, the MySQL Server is working well. I tried to run the C program that will make the connection to the MySQL database and create the user database and useracc table. It's finely working with Windows-VC++. But when i'm trying to run with Linux gcc, I'm getting lots of errors. I don't know what's the problem. I've attached the C-Pgm and the Error info. Pls, help me regarding this. Thanks and Regards, Ashok. Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com[EMAIL PROTECTED] CGI]# gcc -c -I/usr/lib/bcc/include -I/usr/include/mysql user.c In file included from /usr/include/pthread.h:20, from /usr/include/mysql/my_global.h:149, from user.c:3: /usr/include/sched.h:41: parse error before __THROW /usr/include/sched.h:44: parse error before __THROW /usr/include/sched.h:48: parse error before __THROW /usr/include/sched.h:51: parse error before __THROW /usr/include/sched.h:54: parse error before __THROW /usr/include/sched.h:57: parse error before __THROW /usr/include/sched.h:60: parse error before __THROW /usr/include/sched.h:63: parse error before __THROW In file included from /usr/include/mysql/my_global.h:149, from user.c:3: /usr/include/pthread.h:166: parse error before __THROW /usr/include/pthread.h:169: parse error before __THROW /usr/include/pthread.h:172: parse error before __THROW /usr/include/pthread.h:176: parse error before __THROW /usr/include/pthread.h:181: parse error before __THROW /usr/include/pthread.h:187: parse error before __THROW /usr/include/pthread.h:195: parse error before __THROW /usr/include/pthread.h:198: parse error before __THROW /usr/include/pthread.h:202: parse error before __THROW /usr/include/pthread.h:206: parse error before __THROW /usr/include/pthread.h:211: parse error before __THROW /usr/include/pthread.h:217: parse error before __THROW /usr/include/pthread.h:221: parse error before __THROW /usr/include/pthread.h:226: parse error before __THROW /usr/include/pthread.h:230: parse error before __THROW /usr/include/pthread.h:235: parse error before __THROW /usr/include/pthread.h:239: parse error before __THROW /usr/include/pthread.h:243: parse error before __THROW /usr/include/pthread.h:261: parse error before __THROW /usr/include/pthread.h:266: parse error before __THROW /usr/include/pthread.h:285: parse error before __THROW /usr/include/pthread.h:290: parse error before __THROW /usr/include/pthread.h:303: parse error before __THROW /usr/include/pthread.h:309: parse error before __THROW /usr/include/pthread.h:333: parse error before __THROW /usr/include/pthread.h:336: parse error before __THROW /usr/include/pthread.h:339: parse error before __THROW /usr/include/pthread.h:342: parse error before __THROW /usr/include/pthread.h:352: parse error before __THROW /usr/include/pthread.h:359: parse error before __THROW /usr/include/pthread.h:362: parse error before __THROW /usr/include/pthread.h:367: parse error before __THROW /usr/include/pthread.h:371: parse error before __THROW /usr/include/pthread.h:392: parse error before __THROW /usr/include/pthread.h:395: parse error before __THROW /usr/include/pthread.h:398: parse error before __THROW /usr/include/pthread.h:401: parse error before __THROW /usr/include/pthread.h:406: parse error before __THROW /usr/include/pthread.h:415: parse error before __THROW /usr/include/pthread.h:420: parse error before __THROW /usr/include/pthread.h:423: parse error before __THROW /usr/include/pthread.h:428: parse error before __THROW /usr/include/pthread.h:432: parse error before __THROW /usr/include/pthread.h:557: parse error before __THROW /usr/include/pthread.h:560: parse error before __THROW /usr/include/pthread.h:564: parse error before __THROW /usr/include/pthread.h:567: parse error before __THROW /usr/include/pthread.h:577: parse error before __THROW /usr/include/pthread.h:584: parse error before __THROW /usr/include/pthread.h:588: parse error before __THROW /usr/include/pthread.h:591: parse error before __THROW /usr/include/pthread.h:596: parse error before __THROW /usr/include/pthread.h:612: parse error before __THROW /usr/include/pthread.h:621: parse error before __THROW In file included from /usr/include/pthread.h:655, from /usr/include/mysql/my_global.h:149, from user.c:3: /usr/include/bits/sigthread.h:32: parse error before '*' token /usr/include/bits/sigthread.h:36: parse error before __THROW In file included from /usr/include/mysql/my_global.h:149, from user.c:3: /usr/include/pthread.h:673: parse error before __THROW /usr/include/pthread.h:678:
RE: Help needed regarding MySQL-C Libraries on Linux....
Hi Prashanth, I'm happy to help u. i attached one 'C' code in the previous mail. just use that code for in vc++. Follow the procedure, 1.Create the new win32 Console App. as a empty project and add the attached 'C' file to the project. 2.goto Tools-options-Directories(tab) and in that add the corresponding MySQL Include path and as well as the lib-debug path. 3.goto Project-settings-Link(tab)-General Category-add the name 'libmysql.lib' in lib modules 4.Save the project. 5.Add the MySQL lib-debug path to the environment path variable, which is found in ctrl-panel-system-Advanced-env.var-path (for the dynamic linking of libmysql.dll file). 6.Restart the system (for effect of env path var). 7.Run the project. This c pgm will create one database called user and table named useracc under the db user. Note: Don't forget to change the username and password vars in the pgm if u set anything like that for ur MySQL. For further info on C-MySQL read the following page, some sample chapters are there, that will be useful. http://www.quepublishing.com/articles/article.asp?p=30494seqNum=2rl=1 If u have any doubts means, send that to the group, rather than sending to the seperate person and so that reply will be useful for others also. Thanks and Regards, Ashok. --- Prashanth H. Baragur [EMAIL PROTECTED] wrote: Ashok, Can u do me a favor. Am trying to update the mysql server in windows using VC++ and C code. Am very new to this domain. Can u please send the code u are using in VC++ to me? Your help would be greatly appreciate. Thanks prashanth -Original Message- From: Ashok Kumar [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 3:34 PM To: mysql mysql Subject: Help needed regarding MySQL-C Libraries on Linux Dear Friends, I'm Ashok here. first i'll tell my sys configuration. 1.Redhat-Linux 9 2.Intel Pentium chipset 3.MySQL 4.1 with Development Libraries For this i've downloaded the MySQL4.1 under the specification Linux x86 RPM downloads from the site. In my system, the MySQL Server is working well. I tried to run the C program that will make the connection to the MySQL database and create the user database and useracc table. It's finely working with Windows-VC++. But when i'm trying to run with Linux gcc, I'm getting lots of errors. I don't know what's the problem. I've attached the C-Pgm and the Error info. Pls, help me regarding this. Thanks and Regards, Ashok. Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help me for God!!
Hi Carlos, My suggestion for this problem is, just uninstall the MySQL Server and manually delete all the corresponding files, restart the system once (not a must, but it's a advisable), then u install the MySQL, hope now it'll definitely work. This is happening because of mis-configuration b/w the prev and current installations. Thanks and Regards, Ashok. Carlos J Souza wrote: The error as follows: when installation is try to finish, the install try a start de new service MYSQL 4 and does not success I try the install and reinstall many times and nothing. Regards Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 Win 2003 server install problem
hi, if u'r uninstalled the mysql and try to reinstalling means, try the following. 1.Delete all the corresponding files that are created by the prev installation after the uninstallation. 2.Install the MySQL again. Now it'll work. This is due to some configuration prob between the prev and new installation. Try it, all the best. Thanks and Regards, Ashok. --- Carlos J Souza [EMAIL PROTECTED] wrote: Dear Friends, Iam trying to install MySQL 4.1.2 in Windows 2003 Server, and on error occurs when installation try a start de service. The service does not start and installation don't finish. I Need a help about it. Regards for all. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Doubt on MySQL for Linux...
Hi friends, I'm now started to using the Redhat-Linux. Now i want to start MySQL on Linux. I'm not having much idea about Linux. I'm new to this. For Linux which MySQL installation i've to choose from the site. there are lot of binary distributions, i don't which one is compatible for my OS. Linux and H/W specification of my system is as follows. 1. Redhat Linux 9 2. Intel PIII And i also want to know abt how to install and configure MySQL for using that in 'C'. Pls guide me in this. Thanks and Regards, Ashok Kumar.P.S. Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need Help on C with MySQL in win2000...
Dear friends, I'm using win2000 with VC++. In this now i wrote one console application for invoking MySQL Database. After creating the .exe file, if i try to run that means its giving the error that can't find the specified file libmysql.dll. So i added the path of limysql.dll in env path variables and now it's working well. But my questions is, is it possible to embed that dll file with my project itself, rather than adding the path to env path var. when i'll try to run that means it never ask for the path. Is it possible? Thanks and Regards, Ashok Kumar.P.S __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Regarding NOT NULL Option for Table Fields....
Hi friends,
I'm having one doubt on NOT NULL specification for
the table field properties. That is i have created on
table-mine which contains name(Not Null) and pwd(Not
Null). Now I intended to execute the following query.
insert into mine values('','')
This means that i'm trying to insert the null fields
to the table. but this query is successfully executed
and 1 row is inserted into table with empty values.
why it's happening and how can i resolve this problem.
Pls give me suggestions regarding this.
Thanks and Regards,
Ashok Kumar.P.S
__
Discover Yahoo!
Stay in touch with email, IM, photo sharing and more. Check it out!
http://discover.yahoo.com/stayintouch.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
WebHosting with MySQL.......
Hi Friends, I'm Ashok. I tried one c-cgi script which is get two input data from the user (thro' browser) and store it into MySQL Database, which is running in my m/c as a service. It's working well in my local pc. Now i want to host that cgi pgm into one site (where cgi scriptings r allowed). My doubt is how can i invoke the database connectivity for that. is it neccessary that server must have the MySQL DB? Help me pls. Thanks and Regards, Ashok Kumar.P.S. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need some clarification on MySql with BorlandC++ in windows...
Dear Friends, I'm having one problem. that is using MySQL C API Libraries with BorlandC++ compiler ver 3.1and as well as in TC ver 3.0. The problem i'd found is can't include the header files which r having the more than 8 char name length. I can't come up with the solution. pls anybody has any idea, give me. I'm waiting for ur reply. Thanks and regards, Ashok Kumar.P.S. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Urgent help...
Hello Friends, I wrote one simple pgm to connect and disconnect the database in TC(Windows). when compiling the program, it's giving the error, unable to open the my_global.h and giving some more errors from the header files my_sys.h and mysql.h. I copied all the header files from the mysql\include to tc\include. but i'm getting this error repeatedly. What can i do for that. Thanks and Regards, Ashok Kumar.P.S - Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more.
Very UIrgent....How can i start with mysql in c language?
Hi friends, I'm ashok, new member to this forum. I'm doing my final year graduation and I'm new to this MySQL, C and Windows Combination(i never worked DB connectivity in C). There is no such header files in TC such as mysql.h and so on. how can i include those files and how can i create a db via queries from 'C'(is it possible to create a db manually?). Pls give me sugestions in some what detailed manner. Thank u and Regards, Ashok Kumar.P.S - Yahoo! Mail Stay connected, organized, and protected. Take the tour
ashok, from cusat
Sir,
I am facing problem in one function , actually in my table
there is two field: id, and password and I am checking the id
field for any user who is added to the friendlist of another user,
like in yahoo messenger.
MYSQL *conn;
MYSQL_RES *res_ptr;
MYSQL_ROW sqlrow;
FILE *fp;
/**/
int Friend_Result()
{
unsigned int i; int rows;
while( (sqlrow = mysql_fetch_row(res_ptr)) != NULL)
{
for(i = 0; i mysql_num_fields(res_ptr); i++)
{
if(i 0) printf(\t);
if(sqlrow[i] != NULL) printf(%s, sqlrow[i]);
else printf(%s, NULL);
}
printf(\n);
}
if(mysql_errno(conn) != 0)
{
printf(mysql_fetch_row error\n);
return 0;
}
if((unsigned long)mysql_num_rows(res_ptr) == 0)
{
printf(Invalid Not have a valid TARA ID...\n);
return 0;
}
return 1;
}
/**/
int Check_Exist_Friend(char *f)
{
char buf[200];
int result, rows;
printf( Friend = %s\n, f);
strcpy(buf, SELECT id from tara_user where id = );
strcat(buf, ');
strcat(buf, f);
strcat(buf, ');
result = mysql_query(conn, buf);
res_ptr = mysql_store_result(conn);
if(res_ptr == NULL) printf(Storing Error\n);
else
{
printf(Res_ptr is not null\n);
if(! Friend_Result() ) return 0;
mysql_free_result(res_ptr);
}
return 1;
}
/* CHECK THE FRIEND - ID IN DATABASE ***/
void Add_New_Friend(char *a, char *gp, char *f, int sd)
{
int result;
char buf[200];
printf(Friend name = %s\n, f);
if(! Check_Exist_Friend(f) ) return;
else
{
strcpy(buf, INSERT INTO flist values();
strcat(buf, ');
strcat(buf, a);
strcat(buf, ');
strcat(buf, ,);
strcat(buf, ');
strcat(buf, gp);
strcat(buf, ');
strcat(buf, ,);
strcat(buf, ');
strcat(buf, f);
strcat(buf,');
strcat(buf,));
result = mysql_query(conn, buf);
if(!result) printf(Inserted %lu rows\n,
(unsigned long)mysql_affected_rows(conn));
else fprintf(stderr, Insert error %d: %s\n,
mysql_errno(conn),
mysql_error(conn));
}
}
I am calling function Check_Exist_Friend(f) from
Add_New_Friend() but each time where the friend name is existing
in the table or not it give me the same result. I have tried a
lot but couldn't succeed.
I don't know where is fault , so please reply me . so that I
can do my rest of work.
If there are other option to check the existence of any user
whether the user is present or not , please let me know
Hoping positive response from your side.
Thanking you
ASHOK KUMAR
M.C.A. 5TH SEM.
COCHIN UNIVERSITY OF SCIENCE AND TECHNOLOGY
KOCHI : 682 022, KERALA (INDIA).
NIIT supports World Computer Literacy Day on 2nd December.
Enroll for NIIT SWIFT Jyoti till 2nd December for only Rs. 749
and get free Indian Languages Office software worth Rs. 2500.
For details contact your nearest NIIT centre, SWIFT Point
or click here http://swift.rediff.com/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
