Re: MySQL via OLE DB

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

.

Relevant Pages

  • Re: Calculate the string statement
    ... verkn:(vkn:char; ... funkt:(fkt:string; ... var fkt,dfkt: p; ... var fehler: boolean; ...
    (comp.lang.pascal.borland)
  • Two new tests for MM B&V
    ... var RunningThreads: Integer; ... class function TStringThreadTest.GetBenchmarkDescription: string; ... function CheckPattern(const Dest: Pointer; const Size: Integer; const ...
    (borland.public.delphi.language.basm)
  • server-side JavaScript: Prototypes of built-in classes, objects and functins
    ... Session object (disk-based session variables for data persistence ... File class (manipulation of files on server, ie. open, close, read, ... //Methods Cgi.queryCgi.postCgi.anyby default return an empty string if requested var not found ...
    (comp.lang.javascript)
  • Re: [PHP] Image Generation
    ... the text, font, colour, maximum frame size (ie the width and height it ... var $xoffset, $yoffset, $margin; ... a string or array of strings. ... a float or an array of floats - which size to display the related text at. ...
    (php.general)
  • Re: Ajax -> javascript edit box display problems - please help
    ... Public Function GetUsernameList(ByVal testParam As String) As String ... successfully with the AutoComplete.js script. ... getLength: function{ ... var v = this.getValue); ...
    (comp.lang.javascript)