List:General Discussion« Previous MessageNext Message »
From:Sinisa Milivojevic Date:June 4 2001 12:03pm
Subject:Re: MySQL++ API Help
View as plain text  
David Ayliffe writes:
> Does anyone have any SIMPLE proggies written in C++ using the MYSQL++
> API library? Preferably MS Visual Studio 6 format.  If so can you please
> provide me a link for them or contact me over email directly.
> 
> I'm having problems compiling a project that just connects to the server
> issues a query and then exits.  I'm getting linker errors all over the
> shop (attatched)
> 
> ANY ADVICE FOR C++ DEVELOPMENT USING MYSQL++ API APPRECIATED
> 
> !! Sorry if you get this more than once !!
> 
> Thanks lots
> David Ayliffe (mail@stripped)
> Deleting intermediate files and output files for project 'mysqltest - Win32 Debug'.
> --------------------Configuration: mysqltest - Win32 Debug--------------------
> Compiling...
> mysqltest.cpp
> c:\vc\type_info1.hh(39) : warning C4800: 'int' : forcing value to bool 'true' or
> 'false' (performance warning)
> c:\vc\type_info1.hh(159) : warning C4800: 'unsigned int' : forcing value to bool
> 'true' or 'false' (performance warning)
> c:\vc\type_info1.hh(172) : warning C4800: 'int' : forcing value to bool 'true' or
> 'false' (performance warning)
> c:\vc\type_info1.hh(176) : warning C4800: 'int' : forcing value to bool 'true' or
> 'false' (performance warning)
> c:\vc\type_info1.hh(180) : warning C4800: 'int' : forcing value to bool 'true' or
> 'false' (performance warning)
> c:\vc\type_info1.hh(184) : warning C4800: 'int' : forcing value to bool 'true' or
> 'false' (performance warning)
> c:\vc\sql_query1.hh(37) : warning C4800: 'class SQLQuery *' : forcing value to bool
> 'true' or 'false' (performance warning)
> c:\vc\sql_query1.hh(135) : warning C4355: 'this' : used in base member initializer
> list
> c:\vc\compare1.hh(48) : warning C4800: 'int' : forcing value to bool 'true' or
> 'false' (performance warning)
> c:\vc\result1.hh(33) : warning C4355: 'this' : used in base member initializer list
> c:\vc\result1.hh(42) : warning C4800: 'char' : forcing value to bool 'true' or
> 'false' (performance warning)
> Linking...
> mysqltest.obj : error LNK2001: unresolved external symbol "public: __thiscall
> MysqlConnection::~MysqlConnection(void)" (??1MysqlConnection@@QAE@XZ)
> mysqltest.obj : error LNK2001: unresolved external symbol "public: bool __thiscall
> MysqlQuery::exec(class std::basic_string<char,struct std::char_traits<char>,class
> std::allocator<char> > const &)"
> (?exec@MysqlQuery@@QAE_NABV?$basic_string@DU?$char_
> traits@D@std@@V?$allocator@D@2@@std@@@Z)
> mysqltest.obj : error LNK2001: unresolved external symbol "public: bool __thiscall
> MysqlConnection::real_connect(char const *,char const *,char const *,char const *,unsigned
> int,char,unsigned int,char const *)" (?real_connect@MysqlConnection@@QAE_NP
> BD000IDI0@Z)
> mysqltest.obj : error LNK2001: unresolved external symbol _mysql_init@4
> mysqltest.obj : error LNK2001: unresolved external symbol _mysql_errno@4
> Debug/mysqltest.exe : fatal error LNK1120: 5 unresolved externals
> Error executing link.exe.
> 
> mysqltest.exe - 6 error(s), 11 warning(s)
> 
> #include "C:\VC\sqlplus.hh"
> #include <stdio.h>
> #include <windows.h>
> 
> #define MY_DATABASE	"telcent"
> #define MY_TABLE    "nazivi"
> #define MY_HOST     "localhost"
> #define MY_USER     "root"
> #define MY_PASSWORD ""
> #define MY_FIELD    "naziv"
> #define MY_PORT     "3306"
> #define MY_QUERY    "SELECT URL from my_table as t1, my_table as t2 where t1.field =
> t2.field"
> 
> int  main (void) 
> {
>   Connection con(use_exceptions);
> 	try {
> 		ostrstream strbuf; unsigned int i=0; 
> 		con.real_connect (MY_DATABASE,MY_HOST,MY_USER,MY_PASSWORD,3306,(int)0,60,NULL);
> 		Query query = con.query(); query << MY_QUERY; 
> //		ResUse res = query.use(); Row row; 
> //		strbuf << "delete from " << MY_TABLE << " where " <<
> MY_FIELD << " in (";
> //		for UPDATE just replace the above DELETE FROM with UPDATE statement
> //		for(0;row=res.fetch_row();i++) strbuf <<	 row[0] << ",";	if (!i)
> return 0; 
> 		string output(strbuf.str()); output.erase(output.size()-1,1); output += ")";
> 		query.exec((const string&)output); // cout << output << endl;
> 		return 0;
> 	} catch (BadQuery er) { 
>     cerr << "Error: " << er.error << " " << con.errnum()
> << endl;
>     return -1;
> 	}
> }


Hi!

First of all I hope you have used MySQL++ version for VC++.

Second, include sqlplus.hh as a last file.

Third, you have to add sqlplus lib and mysqlclient lib to your
project.


Regards,

Sinisa

      ____  __     _____   _____  ___     ==  MySQL AB
     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic
    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaca, Cyprus
  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____
  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
             /*/             \*\                Developers Team
Thread
Experiences with mysql on Alpha LinuxJohn Banks19 Mar
  • Experiences with mysql on Alpha LinuxMichael Widenius19 Mar
  • Re: Experiences with mysql on Alpha LinuxJohn Banks19 Mar
  • Re: Experiences with mysql on Alpha LinuxJohn Banks29 Mar
    • Re: Experiences with mysql on Alpha LinuxMichael Widenius29 Mar
  • Re: MySQL++ API HelpSinisa Milivojevic4 Jun
Re: Experiences with mysql on Alpha LinuxAnthony Rumble30 Mar