Robert Citek <rwcitek@stripped> wrote on 04/06/2005 10:55:07
AM:
>
> On Monday, Mar 7, 2005, at 16:04 US/Central, SGreen@stripped wrote:
> > It would be happy to try to help if I worked in or on either of those
> > platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript)
> > using MyODBC as my connection library.
>
> Is using MyODBC the accepted way to connect to a MySQL database from
> within an ASP/VBScript page? Or is there some other way? For example,
> PHP has a connector that can directly connect to a MySQL database.
>
> Regards,
> - Robert
> http://www.cwelug.org/downloads
> Help others get OpenSource software. Distribute FLOSS
> for Windows, Linux, *BSD, and MacOS X with BitTorrent
>
MyODBC is but one way to connect code to server. I am not running ASP.NET
servers so I don't use the .NET Connector. There was another project or
two (like the .Net Connector) that was written for VB. I found a copy of
the source of one of them but all of the projects I have found seem to be
abandoned (which means, you are responsible for your own support). The C++
API is packaged with the server)
Since I don't have time to update these legacy connectors to keep up with
the new server technology (Views, SPROCS, INFORMATION_SCHEMA, 4.1+
password hashing, etc) and I don't have enough time to debug it when I get
it wrong (which everyone does), I decided to go with the tested and
prepackaged MyODBC.
Now, if anyone else has or knows of a product that will work from ASP (not
ASP.Net) or VB (not VB.NET) and doesn't require the .NET runtime library
to be installed I would love to hear from you. Please respond to the list
so that everyone has a chance to get in on it, too.
Thanks,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
PS. I am sure that if I tried really hard, I could call a compiled version
of the C++ API from VB but I don't want to go through the motions of
converting all of the APIs function calls into VB "declare" statements. I
have thought about it, but decided against it. Once again, it's a matter
of time and support. - S
