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
