Re: \n converted to \r\n
От | Amir Zicherman |
---|---|
Тема | Re: \n converted to \r\n |
Дата | |
Msg-id | 27a5b7d104100111361bbf027c@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: \n converted to \r\n ("Greg Campbell" <greg.campbell@us.michelin.com>) |
Список | 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 > > > > >
В списке pgsql-odbc по дате отправления:
Следующее
От: Xiang ZhangДата:
Сообщение: How to Access the MS SQL Server via ODBC from Redhat Linux