Re: [fpc-pascal] MySQL insert, load data

2008-02-15 Thread Wolfram Kläger
5.1.1' only. Guess this is a config issue. Now what about LOAD DATA? I still have no idea where to look for it. I learned TSQLQuery is descending Tbufdataset <- TDBDataSet <- TDataset <- TComponent and assume there is somewhere an option to load from a CSV text file or stream. But how

[fpc-pascal] MySQL insert, load data

2008-02-14 Thread Wolfram Kläger
Along Joost's examples I managed to get connected, create a table, put a query, get the result, and insert a single row. But when I try to insert several rows at once, I get an EDatabaseError "near" to first char of second row. ... q.SQL.Clear; q.Add('insert into MYTABLE(c1, c2, ..) values '); q.A

Re: [fpc-pascal] remote mysql connection

2008-02-13 Thread Wolfram Kläger
// Mattias Gaertner, 13.02.2008 19:51 >> plink ... -L 3306:127.0.0.1:3306 ... > > Maybe > plink ... -L 3306:server_name:3306 ... > > ? You mean 'localhost'? Fails, too. FPC still returns 'EDatabaseError, Server connect failed.' and in the plink window I see an additional 'Opening forwarded co

Re: [fpc-pascal] remote mysql connection

2008-02-13 Thread Wolfram Kläger
// Michael Van Canneyt, 12.02.2008 20:08 > > On Tue, 12 Feb 2008, Wolfram Kläger wrote: > >> I am trying to get access to a remote MySQL database via sqldb and >> mysql50conn, ending up with 'EDatabaseError, Server connect failed.' ... > Make sure that >

[fpc-pascal] remote mysql connection

2008-02-12 Thread Wolfram Kläger
I am trying to get access to a remote MySQL database via sqldb and mysql50conn, ending up with 'EDatabaseError, Server connect failed.' Probably naive to assume, the fcl-db units work with a remote server as well as with localhost. For FTP up-/downloads I am using the Synapse toolkit successfully.