Re: \n converted to \r\n - Mailing list pgsql-odbc

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.campbell@us.michelin.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@vale-housing.co.uk> wrote:
> >
> >
> >>
> >>
> >>>-----Original Message-----
> >>>From: pgsql-odbc-owner@postgresql.org
> >>>[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jeff Eckermann
> >>>Sent: 01 October 2004 14:57
> >>>To: Amir Zicherman; pgsql-odbc@postgresql.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@postgresql.org
>
>
>
>
>