Hi
That makes 3 of us dabbling in lazarus as well as Dabo.
But i am in the mid-waters. To do some 'real' stuff, i need to get back
to Delphi.
regards
Nataraj
Zlatko Matic wrote:
Yes, that was me:)
DABO seems to be prommising...
----- Original Message ----- From: "johnf" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, July 26, 2006 12:51 AM
Subject: Re: [lazarus] Sqldb ,MySql and Transactions
Great - I noticed someone with the same name has been asking about
accessing
Postgres using python- is that you by chance. I have used psycopg with
success. You might also want to check out 'DABO' I wrote the postgres
interface.
John
On Tuesday 25 July 2006 14:53, Zlatko Matic wrote:
I would lke to try it:)
----- Original Message -----
From: "johnf" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, July 25, 2006 8:18 PM
Subject: Re: [lazarus] Sqldb ,MySql and Transactions
>I haven't used ODBC but have used SQLDB to connect, update,
>delete,select....
> etc.... Why use ODBC - just wondering?
> John
>
> On Tuesday 25 July 2006 09:26, Zlatko Matic wrote:
>> Has anybody successfully connected to PostgreSQL using ODBC?
>>
>> Zlatko
>>
>> ----- Original Message -----
>> From: "Bram Kuijvenhoven" <[EMAIL PROTECTED]>
>> To: <[EMAIL PROTECTED]>; <[email protected]>
>> Sent: Tuesday, July 25, 2006 1:20 PM
>> Subject: Re: [lazarus] Sqldb ,MySql and Transactions
>>
>> > Nataraj S Narayan wrote:
>> >> I havent succeeded in getting ODBC for MySQL working. But other
>> >> native SQLDB compos are working for MySql 4.1.1.
>> >
>> > The following (from your other mail)
>> >
>> > object MySQL41Connection1: TMySQL41Connection
>> > DatabaseName = 'weberp'
>> > Password = 'rambo1'
>> > UserName = 'ODBC'
>> > HostName = '192.168.1.77'
>> > ...
>> > end
>> >
>> > should be translated to (for Windows)
>> >
>> > object ODBCConnection1: TODBCConnection
>> > Driver = 'MySQL ODBC 3.51 Driver'
>> > Username = 'ODBC'
>> > Password = 'rambo1'
>> > // I don't know how this is put in a lfm file, but I'm sure you
>> > understand what I mean by the below
>> > Params = object TStringList Items = 'SERVER=192.168.1.77',
>> > 'DATABASE=weberp'
>> > end
>> > end
>> >
>> >> Joost has said that MySql 4.x.x dont support transactions.
>> >>
>> >> Will transactions work with ODBC? I have used
>> >> Database1.StartTransaction
>> >> and commit and Roll back with Delphi4 + MyODBC 3.51.
>> >
>> > The ODBC component does not support transactions (at the
moment). Of
>> > course ODBC supports transactions, but I haven't implemented it
yet,
>> > partially because it not entirely trivial.
>> >
>> > I need to use connection handles because there exist no
transaction
>> > handles in ODBC; i.e. there is always one transaction per >> >
connection.
>> > Luckily there is a connection cache in ODBC, but I'd need to
dive >> > into
>> > that a little bit to make sure transactions won't slow every
down >> > too
>> > much (because of an entire reconnects instead of connection cache
>> > reuses).
>> >
>> >> So, which is better - odbc compo or native compo?
>> >
>> > I don't know the native component very well, so I can't tell
you >> > much
>> > about that. If you need transactions, neither will suffice
actually,
>> > according to the above information. Of course you are welcome to
>> > create a
>> > patch implementing transaction support in either component!
>> >
>> >
>> > One advantage of ODBC over native mysql components is that the 4.x
>> > mysql
>> > client library (or higher) is GPLed, whereas the ODBC
components are
>> > not.
>> > This is particularly important if you are writing an
application >> > that
>> > is
>> > not open source, e.g. a commercial application.
>> >
>> > For precise details see >> >
http://www.mysql.com/company/legal/licensing/
>> > and
>> > in particular
>> >
http://www.mysql.com/company/legal/licensing/foss-exception.html >>
> (this
>> > page contains an important exception to the GPL; it has a list of
>> > licenses; if I understand it correctly, applications where each
part
>> > is licensed under one of those (open source!) licenses are
allowed >> > to
>> > use the MySQL client lib).
>> >
>> > Regards,
>> >
>> > Bram
>> >
>> >
>> > _________________________________________________________________
>> > To unsubscribe: mail [EMAIL PROTECTED] with
>> > "unsubscribe" as the Subject
>> > archives at http://www.lazarus.freepascal.org/mailarchives
>>
>> _________________________________________________________________
>> To unsubscribe: mail [EMAIL PROTECTED] with
>> "unsubscribe" as the Subject
>> archives at http://www.lazarus.freepascal.org/mailarchives
>
> _________________________________________________________________
> To unsubscribe: mail [EMAIL PROTECTED] with
> "unsubscribe" as the Subject
> archives at http://www.lazarus.freepascal.org/mailarchives
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
begin:vcard
fn:http://www.gsis.ac.in
n:S Narayan;Nataraj
org:Good Shepherd International School;Software
adr:Niligiris, ;;M.Palada;Ootacamund;TN;643004;INDIA
email;internet:[EMAIL PROTECTED]
title:Project Coordinator
tel;work:0423 2550371 - 307
x-mozilla-html:TRUE
url:http://www.gsis.ac.in
version:2.1
end:vcard
