Re: MySQL via OLE DB

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.


"Fred Seymorh" <bquark@xxxxxxxxx> ???????/???????? ? ???????? ?????????: news:43f35fa5$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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
.

Relevant Pages

  • Re: ODBC or OLE DB
    ... There is also a managed MySQL Data provider that works very well. ... It is not difficult to write a badly performing OLE DB ... provider that is slower than its ODBC counterpart. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Delphi 7, MySQL and ADO
    ... The problem lies in the fact that the OLE DB ... provider from www.MySQL.com is from year 2001 and does not work correctly. ... want to use MySQL with ADO you'll have to do it through the ODBC, ... To be more concrete, when you create your connection string, you should ...
    (borland.public.delphi.database.ado)
  • Re: Recommended OleDB driver for MySQL?
    ... Should I be using a more recent driver? ... I am not even sure this is an OLE DB provider, ... In fact, considering how new I am to MySQL, I am not even sure that *any* ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MySQL via OLE DB
    ... But I could not find an OLE DB Provider for MySQL. ... no OLE DB provider for use with ADO. ... Does anybody know where I can download an OLE DB Provider for MySQL 5? ...
    (borland.public.delphi.database.ado)
  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)