Subject RE: [firebird-support] Re: OLEDB VERY SLOW. Need > 1000 transact ions /s
Author Epstein, Ed
I have all of the manuals. However it only seems to be for C++. I am using
VB6. I need to know how to reference the API functions themselves inside of
VB.

As an example I use a md5 dll to calculate all my MD5 file checksums. It
was written in C++, but was made so that VB6 could reference it. I don't
claim to know how. I just understand that you have write dll's in specific
ways to allow programming languages to access them.

Private Declare Sub MDFile Lib "aamd532.dll" (ByVal f As String, ByVal r As
String)
Private Declare Sub MDStringFix Lib "aamd532.dll" (ByVal f As String, ByVal
t As Long, ByVal r As String)

Also, i frequently use the Windows API functions. A typical reference looks
like:

Declare Function FileTimeToLocalFileTime Lib "kernel32" Alias
"FileTimeToLocalFileTime" (lpFileTime As FILETIME, lpLocalFileTime As
FILETIME) As Long

This is why i previously mentioned that I dont really have the skill to find
out all the statements to declare all the Interbase API functions. What the
manual does tell you is that isc_dsql_execute is a function that you can use
to execute a previously prepared dsql statement. It defines all the passed
parameters and how to use it. However, it does not tell me how to make the
reference statment inside of VB6.

I beleive that if I had all those statements, that I could, through trial
and error, eventually create a working frontend that would use classes built
around those functions.
It would no doubt, be at least one order faster then the OLEDB providers. I
can get from b to c, i just cant get from a to b here.

Edwin Epstein
> Continuity Partners Inc.
> 2753 S. Highland Dr.
> Suite 1010
> Las Vegas, Nevada 89109
> (702) 851-7850 Ext. 247
> eepstein@...
>
CONFIDENTIALITY NOTICE: The information contained in this message may be
privileged and confidential and protected from disclosure.
If the reader of this message is not the intended recipient, or an employee
or agent responsible for delivering this message
to the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer.




-----Original Message-----
From: David Johnson [mailto:d_johnson@...]
Sent: Friday, February 06, 2004 8:39 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: OLEDB VERY SLOW. Need > 1000
transactions /s


The API manual is one of many available online in PDF format at
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download#DOCS

[Non-text portions of this message have been removed]





Yahoo! Groups Links