From sistemascmp@redynet4.com.ar Fri Jan 5 14:13:01 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id CE06F9FA311 for ; Fri, 5 Jan 2007 10:13:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 32406-08 for ; Fri, 5 Jan 2007 10:12:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp.redynet.com.ar (smtp.redynet.com.ar [200.69.11.15]) by postgresql.org (Postfix) with ESMTP id 616CA9FA31B for ; Fri, 5 Jan 2007 10:12:48 -0400 (AST) Received: (qmail 20131 invoked from network); 5 Jan 2007 14:11:30 -0000 Received: from unknown (HELO pcsistemas) (200.69.8.40) by smtp3 with ESMTP; 5 Jan 2007 14:11:30 -0000 Message-ID: <002401c730d3$c2a2f280$0d01a8c0@pcsistemas> From: "Sistemas C.M.P." To: Subject: Connectionstring Date: Fri, 5 Jan 2007 11:14:06 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0021_01C730BA.9D1D1E50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.23 tagged_above=0 required=5 tests=AWL, BAYES_80, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200701/32 X-Sequence-Number: 24188 This is a multi-part message in MIME format. ------=_NextPart_000_0021_01C730BA.9D1D1E50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can I specify the "Encoding" in the connectionString using pgOleDB = with Visual Basic.? ------=_NextPart_000_0021_01C730BA.9D1D1E50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
How can I specify the "Encoding" in the = connectionString using pgOleDB with Visual Basic.?
 
------=_NextPart_000_0021_01C730BA.9D1D1E50-- From andy.shellam-lists@mailnetwork.co.uk Fri Jan 5 14:22:31 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 61CB79FA31B for ; Fri, 5 Jan 2007 10:22:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 84232-09 for ; Fri, 5 Jan 2007 10:22:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id 32D3A9FA311 for ; Fri, 5 Jan 2007 10:22:15 -0400 (AST) Received: from [213.146.139.35] (port=50685 helo=[172.21.18.250]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1H2pxW-0008UW-L6 for pgsql-admin@postgresql.org; Fri, 05 Jan 2007 14:22:15 +0000 Message-ID: <459E5F42.5010403@mailnetwork.co.uk> Date: Fri, 05 Jan 2007 14:22:58 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Connectionstring References: <002401c730d3$c2a2f280$0d01a8c0@pcsistemas> In-Reply-To: <002401c730d3$c2a2f280$0d01a8c0@pcsistemas> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/33 X-Sequence-Number: 24189 Doing a quick Google search, it appears to be, you add "*Encoding*=UNICODE" or whatever you want your encoding to be, in your connection string. Try the pgsql-interfaces list - that's more appropriate for this sort of thing. Sistemas C.M.P. wrote: > How can I specify the "Encoding" in the connectionString using pgOleDB > with Visual Basic.? > > !DSPAM:37,459e5d08137101549039207! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" From andy.shellam-lists@mailnetwork.co.uk Fri Jan 5 14:24:20 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 32C799FA4D7 for ; Fri, 5 Jan 2007 10:24:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 85564-07 for ; Fri, 5 Jan 2007 10:24:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id 44E189FA311 for ; Fri, 5 Jan 2007 10:24:14 -0400 (AST) Received: from [213.146.139.35] (port=50838 helo=[172.21.18.250]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1H2pzR-0008WS-Pa for pgsql-admin@postgresql.org; Fri, 05 Jan 2007 14:24:14 +0000 Message-ID: <459E5FB9.2050703@mailnetwork.co.uk> Date: Fri, 05 Jan 2007 14:24:57 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Connectionstring References: <002401c730d3$c2a2f280$0d01a8c0@pcsistemas> <459E5F42.5010403@mailnetwork.co.uk> In-Reply-To: <459E5F42.5010403@mailnetwork.co.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/34 X-Sequence-Number: 24190 Excuse the asterisks - they were added in by my mail client - it should be "Encoding=UNICODE" Andy Shellam (Mailing Lists) wrote: > Doing a quick Google search, it appears to be, you add > "*Encoding*=UNICODE" or whatever you want your encoding to be, in your > connection string. > > Try the pgsql-interfaces list - that's more appropriate for this sort > of thing. > > > Sistemas C.M.P. wrote: >> How can I specify the "Encoding" in the connectionString using >> pgOleDB with Visual Basic.? >> >> > > -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834 From andy.shellam-lists@mailnetwork.co.uk Fri Jan 5 15:19:14 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 508DD9FA250 for ; Fri, 5 Jan 2007 11:19:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 45120-01 for ; Fri, 5 Jan 2007 11:19:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id 9C0619FA311 for ; Fri, 5 Jan 2007 11:19:03 -0400 (AST) Received: from [213.146.139.35] (port=55177 helo=[172.21.18.250]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1H2qqU-0000ww-1d; Fri, 05 Jan 2007 15:19:02 +0000 Message-ID: <459E6C8D.3060504@mailnetwork.co.uk> Date: Fri, 05 Jan 2007 15:19:41 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: "Sistemas C.M.P." , pgsql-admin@postgresql.org Subject: Re: Connectionstring References: <002401c730d3$c2a2f280$0d01a8c0@pcsistemas> <459E5F42.5010403@mailnetwork.co.uk> <459E5FB9.2050703@mailnetwork.co.uk> <000b01c730d6$73b27bc0$0d01a8c0@pcsistemas> In-Reply-To: <000b01c730d6$73b27bc0$0d01a8c0@pcsistemas> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/36 X-Sequence-Number: 24192 Hmm OK was worth a shot - probably best bet would be to ask on pgsql-interfaces. Andy. Sistemas C.M.P. wrote: > With or without asterisks it doesn't work. This string work on ODBC but not > with pgOLEDB > > ----- Original Message ----- > From: "Andy Shellam (Mailing Lists)" > To: > Sent: Friday, January 05, 2007 11:24 AM > Subject: Re: [ADMIN] Connectionstring > > > >> Excuse the asterisks - they were added in by my mail client - it should >> be "Encoding=UNICODE" >> >> Andy Shellam (Mailing Lists) wrote: >> >>> Doing a quick Google search, it appears to be, you add >>> "*Encoding*=UNICODE" or whatever you want your encoding to be, in your >>> connection string. >>> >>> Try the pgsql-interfaces list - that's more appropriate for this sort >>> of thing. >>> >>> >>> Sistemas C.M.P. wrote: >>> >>>> How can I specify the "Encoding" in the connectionString using >>>> pgOleDB with Visual Basic.? >>>> >>>> >>>> >>> >> -- >> Andy Shellam >> NetServe Support Team >> >> the Mail Network >> "an alternative in a standardised world" >> >> p: +44 (0) 121 288 0832/0839 >> m: +44 (0) 7818 000834 >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 2: Don't 'kill -9' the postmaster >> >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.432 / Virus Database: 268.16.6/617 - Release Date: 05/01/2007 >> > 11:11 a.m. > >> > > > !DSPAM:37,459e6166137101868784367! > > > -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834