From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | goutham <jgowtham(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: BUG #5429: Driver issue |
Date: | 2010-04-20 15:24:25 |
Message-ID: | x2p937d27e11004200824g8fab07d6ic2c8e77057a58f27@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-odbc |
ODBC driver people I think you mean. CC'd.
On Tue, Apr 20, 2010 at 4:12 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> This has to be reported to the .Net driver people.
>
> ---------------------------------------------------------------------------
>
> goutham wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference: 5429
>> Logged by: goutham
>> Email address: jgowtham(at)gmail(dot)com
>> PostgreSQL version: 8.1.9
>> Operating system: Windows
>> Description: Driver issue
>> Details:
>>
>> I am using Driver = PostgreSQL UNICODE.
>> I am retrieving the dataset using this connection string.
>>
>> I am using .Net application.
>> when i try to user OdbcDataAdapter and fill the dataset its failing.
>>
>> code snippet:
>> OdbcDataAdapter odbcAdapt = new OdbcDataAdapter("Select * from
>> table1;"+"Select * from Table2", connection);
>>
>> odbcAdapt.Fill(dataset);
>>
>> dataSet.Count is 0.
>>
>> If I use Driver = postgres instead of Postgres Unicode. this is working.
>>
>>
>>
>>
>> DRIVER={PostgreSQL
>> UNICODE};UID=postgres;PASSWORD=password;UseServerSidePrepare=0;ByteaAsLongVa
>> rBinary=0;BI=0;TrueIsMinus1=0;DisallowPremature=0;Upd
>>
>> atableCursors=1;pga_;;LFConversion=1;ExtraSysTablePrefixes=dd_;CancelAsFreeS
>> tmt=0;Parse=0;UnknownsAsLongVarchar=0;TextAsLongVarch
>>
>> ar=1;BoolsAsChar=0;UseDeclareFetch=0;Ksqo=0;Optimizer=0;CommLog=0;Debug=0;Ma
>> xLongVarcharSize=8190;MaxVarcharSize=254;UnknownSizes
>>
>> =0;Socket=4096;Fetch=100;ConnSettings=;ShowSystemTables=0;RowVersioning=0;Sh
>> owOidColumn=0;FakeOidIndex=0;Protocol=6.4;Rea;Only=0;
>>
>> PORT=5433;SERVER=localhost;DATABASE=TESTDB
>>
>> --
>> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-04-20 15:29:57 | Re: BUG #5430: initdb fails due to permissions of /usr/share/pgsql |
Previous Message | Bruce Momjian | 2010-04-20 15:12:26 | Re: BUG #5429: Driver issue |
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2010-04-20 15:35:21 | Re: 64 bit Postgresql unicode odbc driver for windows 2003 sp2 |
Previous Message | Bruce Momjian | 2010-04-20 15:12:26 | Re: BUG #5429: Driver issue |