>>>>> "Net-Lynx" == Net-Lynx <santos@stripped> writes:
Net-Lynx> Hi All,
Net-Lynx> Being new to MySql, I wrote a simple program (see below) that connects to a
Net-Lynx> server, selects a database, performs a query ... you get the picture.
Net-Lynx> Anyway, I can connect and select a database, but then the program
Net-Lynx> fails when I try to execute a query with a "No Database selected".
Net-Lynx> Could someone tell me what I'm doing wrong? I don't understand why I'm
Net-Lynx> getting a "No Database Selected" right after the DB is selected...
Net-Lynx> I've place a comment where the code fails... Any help would be
Net-Lynx> appreciated...
Net-Lynx> Thanks,
Net-Lynx> Jorge
Net-Lynx> #include <stdio.h>
Net-Lynx> #include "/usr/local/include/mysql/mysql.h"
Net-Lynx> MYSQL sock;
Net-Lynx> MYSQL_RES *result;
Net-Lynx> MYSQL_ROW row;
Net-Lynx> int main(void) {
Net-Lynx> if (!mysql_real_connect(&sock,NULL,NULL,NULL,0,NULL,0)){
Net-Lynx> printf("Connect failed: %s\n",mysql_error(&sock));
Net-Lynx> return 0;
Net-Lynx> }
Net-Lynx> printf("Connected\n");
Net-Lynx> if (!mysql_select_db(&sock,"YESWIM")){
Net-Lynx> printf("DB Selection failed: %s\n",mysql_error(&sock));
Net-Lynx> return 0;
Net-Lynx> }
Net-Lynx> printf("DB selected\n");
Hi!
The problem is that mysql_select_db() return 0 if its ok and something
else on error!
Remove the ! before mysql_select_db and try again!
(The problem is probably that "YESWIM" should be "yeswim")
Regards,
Monty
