Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-07 Thread Rainer Bauer
Alvaro Herrera wrote: Rainer Bauer wrote: Andrej Ricnik-Bay wrote: On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote: That's nice to hear. But I respect licences as they are and the ODBCng driver is licenced under the GPL. That doesn't mean that you're not allowed to use

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-07 Thread Rainer Bauer
Andrej Ricnik-Bay wrote: On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote: That's nice to hear. But I respect licences as they are and the ODBCng driver is licenced under the GPL. That doesn't mean that you're not allowed to use it with commercial applications; it just means that

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-07 Thread Andrei Kovalevski
Rainer Bauer wrote: Alvaro Herrera wrote: Rainer Bauer wrote: Andrej Ricnik-Bay wrote: On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote: That's nice to hear. But I respect licences as they are and the ODBCng driver is licenced under the GPL.

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-07 Thread Alvaro Herrera
Rainer Bauer wrote: Andrej Ricnik-Bay wrote: On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote: That's nice to hear. But I respect licences as they are and the ODBCng driver is licenced under the GPL. That doesn't mean that you're not allowed to use it with commercial

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-07 Thread Greg Smith
On Wed, 7 Nov 2007, Rainer Bauer wrote: The way I read this section is that linking to a GPL ODBC driver would imply that I have to release my program under a GPL (compatible) licence. What you actually link against is the ODBC implementation for your platform. If you're on something

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-07 Thread Peter Cai
Thanks. I have tried your program. But it seems that it has trouble with EUC_CN. It returns unrecoginzed value of empty columns. BTW: I've solved this problem. Every one using odbc on windows shuold read this mail: psqlODBC with Visual Studio 2005 and Connection Pooling for

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-07 Thread Rainer Bauer
Greg Smith wrote: On Wed, 7 Nov 2007, Rainer Bauer wrote: The way I read this section is that linking to a GPL ODBC driver would imply that I have to release my program under a GPL (compatible) licence. What you actually link against is the ODBC implementation for your platform. If you're

[GENERAL] Npsql is much faster than ODBC ?

2007-11-06 Thread 一首诗
Hi all, Recently I found my C/S program becomes slow. So I analysed the tcp traffic between my program and the Postgresql database. I found there are occasionally tcp re-transmission and that's why my porgram slow down. But when I changed to npsql, the tcp traffic was cut off to only 1/4 and

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-06 Thread Ilan Volow
I've never used Npsql and I'm not a C# developer (so take this response with more than a few grains of salt) but from what I remember reading somewhere, Npsql implements postgres protocols natively, with the protocol handling done directly in C# and getting the raw data without going

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-06 Thread Alvaro Herrera
? wrote: Hi all, Recently I found my C/S program becomes slow. So I analysed the tcp traffic between my program and the Postgresql database. I found there are occasionally tcp re-transmission and that's why my porgram slow down. But when I changed to npsql, the tcp traffic was

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-06 Thread Rainer Bauer
Alvaro Herrera wrote: FYI there's another Postgres ODBC driver that is said to have better performance. https://projects.commandprompt.com/public/odbcng (Yes, my company maintains it) psqlodbc is licenced under LGPL, but ODBCng uses the GPL. That means that commercial software cannot use the

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-06 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 06 Nov 2007 22:03:52 +0100 Rainer Bauer [EMAIL PROTECTED] wrote: Alvaro Herrera wrote: FYI there's another Postgres ODBC driver that is said to have better performance. https://projects.commandprompt.com/public/odbcng (Yes, my

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-06 Thread Rainer Bauer
Joshua D. Drake wrote: psqlodbc is licenced under LGPL, but ODBCng uses the GPL. That means that commercial software cannot use the ODBCng driver. Are there any plans to release it under LGPL licence? The only time this would be an issue is if you tried to embed the driver. Other than that,

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-06 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 07 Nov 2007 02:40:08 +0100 Rainer Bauer [EMAIL PROTECTED] wrote: That's nice to hear. But I respect licences as they are and the ODBCng driver is licenced under the GPL. So is this an _official_ statement from CommandPrompt that the

Re: [GENERAL] Npsql is much faster than ODBC ?

2007-11-06 Thread Andrej Ricnik-Bay
On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote: That's nice to hear. But I respect licences as they are and the ODBCng driver is licenced under the GPL. That doesn't mean that you're not allowed to use it with commercial applications; it just means that you need to be happy to