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@gmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com