even simpler, thanx dave.
On Fri, 1 Oct 2004 21:11:33 +0100, Dave Page <dpage@vale-housing.co.uk> wrote:
>
>
> > -----Original Message-----
> > From: Amir Zicherman [mailto:amir.zicherman@gmail.com]
> > Sent: 01 October 2004 18:27
> > To: Dave Page
> > Cc: Jeff Eckermann; ben.trewern@mowlem.com; pgsql-odbc@postgresql.org
> > Subject: Re: [ODBC] \n converted to \r\n
> >
> > Hi, thax for your help. Took me a while to see where the
> > configuration options are because i'm not using a DSN. I
> > then put in a DSN to see if it comes with configuration
> > options and found what you guys were talking about. If i'm
> > just using a connection string in my code, is there any way
> > to configure this option? My code needs to be more generic
> > than to rely on me settign up DSNs for each database i want
> > to connect to. This is what i'm using to connect in the code:
> >
> > "DRIVER={" + DB_DRIVER +
> > "};DATABASE=" + dbName_ +
> > ";SERVER=" + dbIP_ +
> > ";PORT=" + dbPort_ +
> > ";UID=" + dbUser_ +
> > ";PWD=" + dbPassword_;
> >
> > thanx, amir
>
> The easy way to get the connection string is to create a DSN with the
> settings you want, switch on the commlog and then connect. The resulting
> logfile will show you the full connection string built.
>
> In pgAdmin II which used ODBC, we used to use the following:
>
> DRIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN
> =0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=409
> 6;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1
> ;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=0;BO
> OLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;
>
> Obviously we would add the database, server, username, password and port
> options to that.
>
> Regards,Dave.
>