Skip site navigation (1) Skip section navigation (2)

Re: BUG #5429: Driver issue

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: goutham <jgowtham(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5429: Driver issue
Date: 2010-04-20 15:12:26
Message-ID: 201004201512.o3KFCQ618543@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-odbc
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

In response to

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2010-04-20 15:24:25
Subject: Re: BUG #5429: Driver issue
Previous:From: kam thangDate: 2010-04-19 10:31:37
Subject: 64 bit Postgresql unicode odbc driver for windows 2003 sp2

pgsql-bugs by date

Next:From: Dave PageDate: 2010-04-20 15:24:25
Subject: Re: BUG #5429: Driver issue
Previous:From: Kevin GrittnerDate: 2010-04-20 13:48:15
Subject: Re: query related to pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group