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: jgowt...@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 <br...@momjian.us> http://momjian.us EnterpriseDB http://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