We've made changes to support @ parameter prefix exactly to easy porting of sqlserver client queries to postgresql. This way you may need minimum changes to your code. Just to those specific sql calls. On Fri, Nov 5, 2010 at 19:40, mike stanton <mike.stanton@xxxxxxxxxxxxxxx> wrote: > > Dann, perhaps the a better question would be.....if we use, for example, > npgsql, we'd have to adapt code andÂuse the toolsÂownÂcalls. And that means > rewriting. Is this true?. > > Cheers > Mike > > ----- Original Message ----- > From: Dann Corbit > To: 'mike stanton' ; pgsql-general@xxxxxxxxxxxxxx > Cc: mike stanton > Sent: Friday, November 05, 2010 5:12 PM > Subject: Re: Access postgresql data base from .net > > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of mike stanton > Sent: Friday, November 05, 2010 12:08 PM > To: pgsql-general@xxxxxxxxxxxxxx > Cc: mike stanton > Subject: Access postgresql data base from .net > > > > Hello all; weÂve got a project where we have a system built originally for > .net/sql-server. Now we want to changeÂsql-server for a postgresql database. > And preferably without using the ODBC driver which we have heard is prone to > errors. > >>> > > What specific errors did you hear about? > > I suggest testing the rumors. If there really is some problem, then submit > a bug report. > > Sometimes, people want you to use their tools, and so they will exaggerate > the problem with competitive tools. > > << > > > > Is there a producto which we can use which does not imply a major rewrite of > all the SQL ?. > >>> > > Probably most interface tools will work if you are using ISO standard SQL. > Any place where you are using SQL language extensions you will have to do > some work. > > You can find interfaces here: > > http://pgfoundry.org/softwaremap/trove_list.php?form_cat=310 > > > > There are also a very large number of commercial interfaces for PostgreSQL > available. You can find out about those here: > > http://www.sqlsummit.com/DataAcce.htm > > << > > > > Obviously we may have problemas with differences between Sql-server and > Postgresql syntax, but we donÂt want to de a rewrite. > >>> > > What specific problems are you having? > > << > > > > Hope to hear soon, any help appreciated. > > > > Mike Stanton W. > Santiago Chile > > __________ InformaciÃn de ESET NOD32 Antivirus, versiÃn de la base de firmas > de virus 5575 (20101029) __________ > > ESET NOD32 Antivirus ha comprobado este mensaje. > > http://www.eset.com > > __________ InformaciÃn de ESET NOD32 Antivirus, versiÃn de la base de firmas > de virus 5575 (20101029) __________ > > ESET NOD32 Antivirus ha comprobado este mensaje. > > http://www.eset.com > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
