Re: \n converted to \r\n

Awesome, it works! i dig the method of using the udl file to show all
available connection string properties. thanx a lot for your help.

amir

On Fri, 01 Oct 2004 13:50:32 -0400, Greg Campbell
<greg(dot)campbell(at)us(dot)michelin(dot)com> wrote:
> If you are using a sufficiently up-to-date windows machine, you can make
> the tools available on it tell you. I'm not sure if this requires VB or
> Studio,.. but here goes.
>
> 1.Create a DSN entry to your database.
>
> 2. On your desktop create a new file -- text if fine.
> 3. Save or Rename the file to test.udl -- don't worry when it barks
> about changing the file extension or association.
> 4. Right click on test.udl and choose open. It will open a wizard to
> help you form an datasource connection string. You may have to choose
> that you wish to use connection string. All the options available to
> your ODBC driver will be placed into a string.
>
> When the wizard is complete, open the udl file with notepad -- or drag
> and drop it onto a Notepad shortcut to open it.
>
> To your specific question the option parameter is
> LFConversion=0 for no
> LFConversion=1 for yes
>
>
>
>
> Amir Zicherman wrote:
>
> >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
> >
> >
> >On Fri, 1 Oct 2004 15:10:10 +0100, Dave Page <dpage(at)vale-housing(dot)co(dot)uk> wrote:
> >
> >
> >>
> >>
> >>>-----Original Message-----
> >>>From: pgsql-odbc-owner(at)postgresql(dot)org
> >>>[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Jeff Eckermann
> >>>Sent: 01 October 2004 14:57
> >>>To: Amir Zicherman; pgsql-odbc(at)postgresql(dot)org
> >>>Subject: Re: [ODBC] \n converted to \r\n
> >>>
> >>>I don't believe that there is any user-settable option to
> >>>disable that functionality.
> >>>
> >>>
> >>There is an 'LF <-> CR/LF Conversion' option on the second options
> >>dialog.
> >>
> >>Regards, Dave
> >>
> >>
> >>
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 8: explain analyze is your friend
> >
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>
>
>