libmysql

Delphi 7 Personal, MySQL using libmysql.dll + UTF8

Hi, I'm using Delphi 7 Personal. To access MySQL database I'm using libmysql.dll + very simple wrapper, which is good enough for me. Except one thing ... it doesn't seem to handle Utf8... is that possible somehow to pass Utf8 strings from libmysql to Delphi? Please keep in mind I'm not using commercial delphi, this means no ADO / dbExpr...

libmysqlclient hangs on vmsplice()

Hi I am running an executable that uses libmysqlclient.so.15 on a 64bit kernel & 32bit user space compatibility mode. Once in a while, my program hangs on something from libmysql: #0 0xf7f01430 in __kernel_vsyscall () #1 0xf7b451e3 in vmsplice () from /lib/i686/cmov/libc.so.6 #2 0xf7e72c10 in ?? () from /usr/lib/libmysqlclient.so.1...

Cheapest way to to determine if a MySQL connection is still alive

I have a pool of MySQL connections for a web-based data service. When it starts to service a request, it takes a connection from the pool to use. The problem is that if there has been a significant pause since that particular connection has been used, the server may have timed it out and closed its end. I'd like to be able to detect this...

Problems upgrading MySQL application from Delphi 2006 to 2010

I upgraded my Delphi to 2010 version and I tried to open and run application written in Delphi 2006. The app is using mysql by dbexpress with libmysql.dll and a second driver found somewhere on the Internet. I can't run it on 2010. I'm always getting "missing libmysql.dll library". I tried to get new version of it but it didn't help. C...

libmysql c++ text problem

Im using libmysql for mysql in c++ and now i got a column, type= text, and i want the word(s) inside it. how to do this? when i use Blob (dont know what it is) it gives me e44158. can somebody help me please? ...

mysql_close doesn't kill locked sql requests

I use mysqld Ver 5.1.37-2-log for debian-linux-gnu I perform mysql calls from c++ code with functions mysql_query. The problem occurs when mysql_query execute procedure, procedure locked on locked table, so mysql_query hangs. If send kill signal to application then we can see lock until table is locked. Create the following SQL table ...

How do I build libmySQL ?

I aim to integrate libmySQL into my executable instead of using libmySQL.dll. I use VC++ 2008 @ Windows Vista. I've downloaded "mysql-connector-c-noinstall-6.0.2-win32-vs2005.zip" from http://dev.mysql.com/downloads/connector/c/ It contains only ".h" files with declarations. Where is the implementation code (".c" files)? As said, I wi...

Where's the source of mysqlclient.lib ?

I have a C++ application which connects to a MySQL server. It all works fine. Currently it uses libmysql.dll. At build time I link to libmysql.lib. As far as I understand I can link to mysqlclient.lib instead and get rid of the dependency of libmysql.dll, i.e have the functionality embedded within my exe. My question is: Where can I f...

CLSQL and MYSQL on OS X

I'm working on OS X 10.6.4. I've been using clbuild to install supporting libraries for SBCL (including clsql), and I do all my work through Aquamacs. I installed MySQL using the excellent instructions over at Hive Logic. But when I call (require 'clsql) -- which seems to work fine -- and then try to execute (clsql:connect '(nil "lisp" "...

Runtime "symbol lookup error" when accessing libmysqlclient.so functionality in C

Context: I am not certain whether this is my problem or the problem of the server this is running on. I am trying to compile and run a small utility, to become a cron job, that uses the mysql libraries. The program compiles successfully with the following command, no errors or warnings: gcc my_program.c -o my_program -I /usr/include/mys...