MySQL ODBC/OLE DB Drivers

[CJM]

I've just started playing with MySQL.

Most of my current apps are either ASP or VB6, using SQL Server. Obviously,
in order to use MySQL in these apps, I need appropriate drivers.

However, they dont provide the necessary ODBC/OLE DB files as Windows
binaries on the MySQL site - they only have BitKeeper source code.

Does anyone have the necessary compiled binaries? What do others use for
connectivity? Are ther alternatives?

Thanks in advance...

Chris

[Sguindaw]

Hello CJM

You can download MySQL ODBC Driver from
[url]http://www.mysql.com/downloads/api-myodbc-3.51.html[/url]

You can use ADO trought ODBC to connect to MySQL Server

Sguindaw

CJM wrote:

> I've just started playing with MySQL.
>
> Most of my current apps are either ASP or VB6, using SQL Server. Obviously,
> in order to use MySQL in these apps, I need appropriate drivers.
>
> However, they dont provide the necessary ODBC/OLE DB files as Windows
> binaries on the MySQL site - they only have BitKeeper source code.
>
> Does anyone have the necessary compiled binaries? What do others use for
> connectivity? Are ther alternatives?
>
> Thanks in advance...
>
> Chris
>
>

[CJM]

Oops.. I was looking at the development release!

Cheers

[Mike Collier]

> You can download MySQL ODBC Driver from

> [url]http://www.mysql.com/downloads/api-myodbc-3.51.html[/url]

Check out MyOLEDB provider there too

--
Mike Collier
FREE ADO Inspector tool when you register at ADO forum.
[url]www.adoanywhere.com[/url]
[url]http://www.adoanywhere.com/forum[/url]

[Mike Walsh]

"Mike Collier" <noemail@noemail> wrote in message
news:un6gvfq6DHA.3804@tk2msftngp13.phx.gbl...

> > You can download MySQL ODBC Driver from
> > [url]http://www.mysql.com/downloads/api-myodbc-3.51.html[/url]

>
> Check out MyOLEDB provider there too
>

I am embarking on a project to talk to my MySQL database with Visual Basic.

Just to get started I wanted to use the sample on the MySQL web site:

[url]http://www.mysql.com/products/myodbc/manual.html#ODBC.NET(VB[/url])

I am unable to get the example to compile successfully. Specifically, I am
unable to resolve the reference "Imports Microsoft.Data.Odbc".

Anyone have any suggestions on how to get the sample to compile?

Thanks,

Mike


--
Mike Walsh - mike_walsh at mindspring.com