On Sun, 15 Jun 2003, James Mills wrote:
> On Sat, Jun 14, 2003 at 06:30:09PM +0200, [EMAIL PROTECTED] wrote: > > > > > > On Sun, 15 Jun 2003, James Mills wrote: > > > > > On Sat, Jun 14, 2003 at 05:01:38PM +0200, [EMAIL PROTECTED] wrote: > > > > > > > > > > > > On Sun, 15 Jun 2003, James Mills wrote: > > > > > > > > > On Sat, Jun 14, 2003 at 04:08:38PM +0200, [EMAIL PROTECTED] wrote: > > > > > > > > > > > > > > > > > > On Sat, 14 Jun 2003, James Mills wrote: > > > > > > > > > > > > > $ fpc testdb > > > > > > > Free Pascal Compiler version 1.0.6 [2002/08/10] for i386 > > > > > > > Copyright (c) 1993-2002 by Florian Klaempfl > > > > > > > Target OS: Linux for i386 > > > > > > > Compiling testdb.pas > > > > > > > Assembling qtest > > > > > > > Linking testdb > > > > > > > testdb.o(.text+0xaa): In function `program_init': > > > > > > > : undefined reference to `mysql_connect' > > > > > > > testdb.pas(84,3) Error: Error while linking > > > > > > > Closing script ppas.sh > > > > > > > > > > > > > > What have I done wrong here ? ... > > > > > > > Yes I have installed the appropiate libmysqlclient-dev (from debian). > > > > > > > > > > > > It is not the correct version of mysql. Please check what the mysql_version > > > > > > unit reports as a version, and what the version is of the installed mysql. > > > > > > > > > > How on earth do I do that :P ? > > > > > > > > Simple: > > > > > > > > program ver; > > > > > > > > uses mysql_version; > > > > > > > > begin > > > > Writeln(MYSQL_SERVER_VERSION); > > > > end. > > > > > > Okay I didn't know such a unit existed :) > > > > > > Here's the info you wanted... > > > > Correction: the info which you need :-) > > > > Seems that you have mysql version 4 installed. > > The units we distribute standard work with MySQL 3.23. > > > > There are units for mysql version 4 as well, but you must compile and > > install them separately. Get the sources of the packages , and look in > > packages/base/mysql/mysql4 > > > > I warn against using mysql with FPC. Their API changes quite often in > > incompatible ways, which can be masked with C macros but which cannot > > be masked with Pascal functions. > > > > Try and use firebird instead is my usual advice. > > What about sqlite ? Has anyone gotten that to work in any application > they've developed. I don't know of any report. But if you want to give it a try, I just converted the C headers for it, I can send them to you. Michael. _______________________________________________ fpc-pascal maillist - [EMAIL PROTECTED] http://lists.freepascal.org/mailman/listinfo/fpc-pascal