From: | "goutham" <jgowtham(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5429: Driver issue |
Date: | 2010-04-19 02:38:49 |
Message-ID: | 201004190238.o3J2cnoB082767@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2010-04-19 07:59:41 | Re: bugs that have not been replied-to on list |
Previous Message | Jaime Casanova | 2010-04-19 02:36:18 | Re: bugs that have not been replied-to on list |
From | Date | Subject | |
---|---|---|---|
Next Message | goutham jalakam | 2010-04-19 03:02:22 | ODBC Driver |
Previous Message | Andreas | 2010-04-17 14:34:42 | problem with big varchars and adodb |