Hi.

Um, It is a problem report about psqlODBC. I'm not sure of what as a result of basing it on a multi-statement, return becomes. Therefore, I had tried the environment to reproduce. Though it is necessary to acquire a certain amount of information, the point is not held yet....
Other someone may have an early reply.

Regards,
Hiroshi Saito

----- Original Message ----- From: "Bruce Momjian" <br...@momjian.us>



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

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

Reply via email to