Hi List, I want to call the C API functions from Visual Basic in MS Access 2003. I assume that I have to use: "c:\Program Files\MySQL\MySQL Server 4.1\Bin\LibMySQL.dll". In my code at module level I have included various code lines to declare entry-points, such as: Declare Function mysql_info Lib "c:\Program Files\MySQL\MySQL Server 4.1\Bin\LibMySQL.dll" () Declare Function mysql_stat Lib "c:\Program Files\MySQL\MySQL Server 4.1\Bin\LibMySQL.dll" ()
After making an ADODB.Connection and running a query succesfully, I want to call mysql_info(). The syntax in C language for this function is: char *mysql_info(MYSQL *mysql) My question: how to call mysql_info() from Visual Basic ? When I use: myString = mysql_info() it returns an empty string. My system includes: Windows XP, MySQL 4.1.13 and MyODBC 3.51.11. Thanks in advance, Cor Vegelin Business Explorer BV
