Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #5429: Driver issue

BUG #5429: Driver issue

From
"goutham"
Date:
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

Re: BUG #5429: Driver issue

From
Bruce Momjian
Date:
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

Re: BUG #5429: Driver issue

From
Dave Page
Date:
ODBC driver people I think you mean. CC'd.

On Tue, Apr 20, 2010 at 4:12 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
> 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
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>



--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

Re: BUG #5429: Driver issue

From
"Hiroshi Saito"
Date:
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" <bruce@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:      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
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs