RE: fast access with VisualBasic?

[John Foley]

	ummmmmm, I've been calling DLL functions since Access Basic / MS
Access 2. What's to prevent you from declaring extern functions from the
mysqlclient .dll?
	A VBA 5 example from Access 97:
 ' Access the GetUserNameA function in advapi32.dll and call the function
GetUserName.
     Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA"
(ByVal lpBuffer As String, nSize As Long) As Long

	Call the function GenUserNameA and it returns a long . . . 


	Anybody (with stronger VB then I) have any thoughts?


> -----Original Message-----
> From:	Tim Sherrill [SMTP:Tim.Sherrill@stripped]
> Sent:	Wednesday, August 16, 2000 1:35 PM
> To:	win32@stripped; mysql@stripped
> Subject:	RE: fast access with VisualBasic?
> 
> Perl has direct interaction with mysql and also has the ability to create
> COM objects (active perl).  Make a light perl wrapper COM class that
> passes
> queries through to the DB?
> 
> Tim Sherrill
> 
> 
> > -----Original Message-----
> > From: Dana Powers [mailto:dana420@stripped]
> > Sent: Tuesday, August 15, 2000 4:42 PM
> > To: win32@stripped; mysql@stripped
> > Subject: Re: fast access with VisualBasic?
> >
> >
> > Why not just write a COM object that exposes a basic OO
> > interface to mysql
> > using the native API? I did this a long time ago with some
> > legacy database
> > who's name I cant recall right now. We wrote VB front ends as
> > well as ASP pages
> > using it (M$ likes COM) very easily.
> >
> > Dana
> >
> > On Tue, 15 Aug 2000, Ken Menzel wrote:
> > > Hi Matthais,
> > >    I haven't seen any reponse.  So I'll take a stab.  We
> > also use VB6 here
> > > for developement and I think the speed of application
> > creation can't be
> > > beat!  We are using ODBC and try to minimize the number of
> > queries and
> > > amount of data returned.  I too wish there was a direct
> > interface.  I think
> > > someone talked about writing it a while ago.  My opionion
> > is a wrapper
> > > around the C library would be the quickest and easiest way
> > to get soemthing
> > > going,  but I have not yet had time for this as I have had
> > threads problems
> > > on my platform.  We have integrated other C libs with
> > wrappers and this
> > > worked great.
> > > Who knows maybe we will get to this and be the first.  I see alot of
> > > questions with VB in the subject,  so I think someone will
> > come up with a
> > > better way eventually.
> >
> > ---------------------------------------------------------------------
> > Please check
> "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread3521@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
>