Re: Infos about the embedded server dll

2003-06-23 Thread Derick Smith
The function are in chapter 8.4.5 of the manual. I tried using the embedded library in C, then calling it from VB through a DLL without any luck. The libmysql.dll seems to work better. Eric From: Wavyx <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Infos about the embedded server dll Date: Mo

RE: suggestions - server options/mysql variables

2003-06-19 Thread Derick Smith
ake a big difference. Thanks Eric From: "Mike Hillyer" <[EMAIL PROTECTED]> To: "Derick Smith" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: RE: suggestions - server options/mysql variables Date: Thu, 19 Jun 2003 09:13:33 -0600 If y

suggestions - server options/mysql variables

2003-06-19 Thread Derick Smith
Hi! Does anyone know any mysql options I can change in the my.ini file or mysql variables to increase the speed of select statements? About database: -uses only select statements for queries -no transactions -if database becomes corrupt in anyway, not a big deal I can recreate it -it is a small d

Compiling:Not a valid library (invalid magic number).Possibly a 64-bit PA archive library (Mismatched ABI).

2003-06-05 Thread Derick Smith
Hi! I am porting a program from windows to UNIX and I cannot get it to compile on the UNIX version. Any suggestions?? Are the libraries shipped with mysql correct? Am I compiling it correctly? Any help is appreciated! Thanks Eric Error exit code 1 /opt/ansic/bin/c89 -o bin/ceagtest obj/ce

performance - speed - length of char field

2003-06-03 Thread Derick Smith
Hi! Can anyone tell me if a shorter char field will increase the speed of SELECT queries? (The char field will be indexed). This field is not a varchar. Thanks Eric _ Tired of spam? Get advanced junk mail protection with MSN 8. htt

Re: HELP mysql_server_init embedded in a DLL?

2003-02-28 Thread Derick Smith
#x27;setup the return value End Function I myselve created an dll (in vb) which encapsulates all the stuff to connect to the database, use recordsets, (as close as possible to the ADO object model: so with connection, recordset - objects, bookmarks, fields, ...) Hope this helps. From: &qu

Re: HELP mysql_server_init embedded in a DLL?

2003-02-27 Thread Derick Smith
rivate Sub cmdmysq_server_init_Click() Dim argv(0) As Byte, groups(0) As Byte Dim i As Long argv(0) = Asc("0") groups(0) = Asc("0") i = mysql_server_init(0, argv, groups) End Sub From: "Derick Smith" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]

mysql_server_init embedded in a DLL?

2003-02-26 Thread Derick Smith
Hi! I am trying to create a DLL that will hide embedded mySQL functions for use with VB. I am using mysqlserver.lib. I am able to compile and execute the following code. This has to be done in C because VB is too slow :-( If mysql_server_init function is run in the DLL from Visual Basic. I get

Visual Basic Embedded VC++ DLL

2003-02-24 Thread Derick Smith
Hi! Has anyone created a DLL in VC++ the uses the embedded mysqlserver.lib library? Is it possible to do this? Is there any special settings that are needed? I have compiled a DLL that does this, but then I run a function wich encapsulates mysql_server_init(), I get a memory error and my VB pro

libmysqld.lib

2003-02-19 Thread Derick Smith
Hi! I want to emebed libmysqld.lib into a DLL I am making for Visual Basic. I need to make the DLL in C because it is going to perform other functions (i.e I do not want to use the "Public Declare" in VB to access the DLL). I need the libmysqld.lib library. I could use LoadLibrary to load it d