BUG #3288: Select command giving error

Started by Srinivasalmost 19 years ago2 messagesbugs
Jump to latest
#1Srinivas
srinivasthouta@yahoo.com

The following bug has been logged online:

Bug reference: 3288
Logged by: Srinivas
Email address: srinivasthouta@yahoo.com
PostgreSQL version: 8.2
Operating system: Win XP
Description: Select command giving error
Details:

Hi, We are using PGOleDB drivers with ASP.Net C# code. We could connect and
give the Insert, Update and Delete commands successfully. When we give a
Select command, it is giving the following error.
'PostgreSQL' failed with no error message available, result code:
-2147221163(0x80040155).

Can anyone please help.

regards
Srinivas

#2Magnus Hagander
magnus@hagander.net
In reply to: Srinivas (#1)
Re: BUG #3288: Select command giving error

Srinivas wrote:

The following bug has been logged online:

Bug reference: 3288
Logged by: Srinivas
Email address: srinivasthouta@yahoo.com
PostgreSQL version: 8.2
Operating system: Win XP
Description: Select command giving error
Details:

Hi, We are using PGOleDB drivers with ASP.Net C# code. We could connect and
give the Insert, Update and Delete commands successfully. When we give a
Select command, it is giving the following error.
'PostgreSQL' failed with no error message available, result code:
-2147221163(0x80040155).

Any specific reason you're using pgoledb from C#? You will likely get
much better results using the native npgsql driver.

It's been my experience that you often get this kind of unhelpful error
messages from the oledb layer regardless of what db you're using - I see
it all the time with the sqlserver and AD providers. Never really found
a good way to deal with it :( So if you can change, I very much
recommend you look at npgsql.

//Magnus