MySQL via OLE DB

[Fred Seymorh]

Hi!

I am using Delphi i2005 Win32 to access a MySQL 5.0.12 Database. I want
to use ADO and not ODBC. But I could not find an OLE DB Provider for
MySQL. Some googling pointed me to http://dev.mysql.com/downloads/ but
there is no OLE DB provider for use with ADO.

I am not using ADO.NET.

Does anybody know where I can download an OLE DB Provider for MySQL 5?

Thanks!

Fred

[Viatcheslav V. Vassiliev]

http://www.mysql.com/Downloads/Win32/MyOLEDB.exe
http://www.mysql.com/Downloads/Win32/MyOLEDB.chm - help file

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Fred Seymorh" <bqu...@quark.com> ???????/???????? ? ???????? ?????????:
news:43f35fa5$1...@newsgroups.borland.com...

[Fred Seymorh]

Thank you! I got the setup from there. Unfortunately it does not work. I
use that snippet of code.

var s : string;
begin
s:= 'Provider=MySqlProv.2.5;Data Source=test;Password=myone;';
s:=s + 'User ID=root;Server=localhost;'; // DB=localhost don't work
ADOConnection1.ConnectionString:=s;
ADOConnection1.LoginPrompt:=False;
ADOConnection1.Open; // raises "Unknown Error" exception

I have looked up the help file (chm) for other options in the connection
string, but it did not work in any way.

Fred

Viatcheslav V. Vassiliev schrieb:

> http://www.mysql.com/Downloads/Win32/MyOLEDB.exe
> http://www.mysql.com/Downloads/Win32/MyOLEDB.chm - help file
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
>
>

[Guillem]

Fred Seymorh wrote:

> Thank you! I got the setup from there. Unfortunately it does not
> work. I use that snippet of code.
>
> var s : string;
> begin
> s:= 'Provider=MySqlProv.2.5;Data Source=test;Password=myone;';
> s:=s + 'User ID=root;Server=localhost;'; // DB=localhost don't work
> ADOConnection1.ConnectionString:=s;
> ADOConnection1.LoginPrompt:=False;
> ADOConnection1.Open; // raises "Unknown Error" exception
>
>
> I have looked up the help file (chm) for other options in the
> connection string, but it did not work in any way.
>
> Fred
>
>
>

see following URLs

http://www.connectionstrings.com

http://dev.mysql.com/doc/refman/5.0/en/connection-parameters.html

Still, I'm curious about how it will work as I tried a long time ago
(with version 4.0.12) and had a lot of problems. Finally decided to do
it without OLE DB provider :(

Good luck
--
Best regards :)

Guillem Vicens Meier
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam