Re: BUG #5429: Driver issue

ODBC driver people I think you mean. CC'd.

On Tue, Apr 20, 2010 at 4:12 PM, Bruce Momjian wrote:
>
> This has to be reported to the .Net driver people.
>
> ------------------------------------------------------------ -------------=
--
>
> goutham wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference: =A0 =A0 =A05429
>> Logged by: =A0 =A0 =A0 =A0 =A0goutham
>> Email address: =A0 =A0 =A0jgowtham@gmail.com
>> PostgreSQL version: 8.1.9
>> Operating system: =A0 Windows
>> Description: =A0 =A0 =A0 =A0Driver issue
>> Details:
>>
>> I am using Driver =3D 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 =3D new OdbcDataAdapter("Select * from
>> table1;"+"Select * from Table2", connection);
>>
>> odbcAdapt.Fill(dataset);
>>
>> dataSet.Count is 0.
>>
>> If I use Driver =3D postgres instead of Postgres Unicode. this is workin=
g.
>>
>>
>>
>>
>> DRIVER=3D{PostgreSQL
>> UNICODE};UID=3Dpostgres;PASSWORD=3Dpassword;UseServerSidePre pare=3D0;Byt=
eaAsLongVa
>> rBinary=3D0;BI=3D0;TrueIsMinus1=3D0;DisallowPremature=3D0;Up d
>>
>> atableCursors=3D1;pga_;;LFConversion=3D1;ExtraSysTablePrefix es=3Ddd_;Can=
celAsFreeS
>> tmt=3D0;Parse=3D0;UnknownsAsLongVarchar=3D0;TextAsLongVarch
>>
>> ar=3D1;BoolsAsChar=3D0;UseDeclareFetch=3D0;Ksqo=3D0;Optimize r=3D0;CommLo=
g=3D0;Debug=3D0;Ma
>> xLongVarcharSize=3D8190;MaxVarcharSize=3D254;UnknownSizes
>>
>> =3D0;Socket=3D4096;Fetch=3D100;ConnSettings=3D;ShowSystemTab les=3D0;RowV=
ersioning=3D0;Sh
>> owOidColumn=3D0;FakeOidIndex=3D0;Protocol=3D6.4;Rea;Only=3D0 ;
>>
>> PORT=3D5433;SERVER=3Dlocalhost;DATABASE=3DTESTDB
>>
>> --
>> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs
>
> --
> =A0Bruce Momjian =A0 =A0 =A0 =A0 =A0http://momjian.us
> =A0EnterpriseDB =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 h=
ttp://enterprisedb.com
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>



--=20
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

--=20
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs