RE: MySQL and VB - Garrison, Kerry - com.mysql.lists.win32

3 messages in com.mysql.lists.win32RE: MySQL and VB

From	Sent On	Attachments
Chris Priestman	22 Nov 2000 02:40
Miguel Angel Solórzano	22 Nov 2000 07:25
Garrison, Kerry	22 Nov 2000 10:47

Subject:	RE: MySQL and VB
From:	Garrison, Kerry (KGar...@xo.com)
Date:	11/22/2000 10:47:59 AM
List:	com.mysql.lists.win32

I have done several projects with VB and MySQL, I use simple ADO to handle it as follows:

<% strConnection = "driver={MySQL};server=localhost;uid=benoneill;pwd=mypassword;database=datab asename" Set adoDataConn = Server.CreateObject("ADODB.Connection") adoDataConn.Open strConnection %>

I actually use code written by Ben O'Neill and available online at: http://askasp.com/articles.asp?ArtID=41

It works for both ASP and VB. -Kerry

-----Original Message----- From: Chris Priestman [mailto:chr...@sports.com] Sent: Wednesday, November 22, 2000 2:40 AM To: Win32 Subject: MySQL and VB

Hi.

I don't know if this is the best place for this query, if not my apologies.

I'm trying to connect to MySQL on a Linux server via VB and have found that using the MyODBC drivers are pretty slow for what I need (it took 4 secs to retrieve 400 records). I stumbled across the libmysql.dll and wondered if anyone had any examples of using this with VB, or if anyone has any other suggestions.

Thanks...