SCM

[#1000394] c# GetOleDbSchemaTable Error

View Trackers | Bugs | Download .csv | Monitor

Date:
2005-09-26 11:37
Priority:
3
State:
Open
Submitted by:
olivier fize (fize)
Assigned to:
Nobody (None)
Category:
Group:
Resolution:
None
 
Summary:
c# GetOleDbSchemaTable Error

Detailed description
Hello,
I want to retreive table informations of my database (postgres 7 or 8) but when i call GetOleDbSchemaTable i have folowing error : Unspecified error E_OUTOFMEMORY (0x8007000E)

my C# code is below :
OleDbConnection connection = new OleDbConnection(ConnectionStringDatabase);
connection.Open();
MessageBox.Show ("OleDbConnection OK");
new OleDbCommand("Select * from [Client]", connection );
MessageBox.Show ("OleDbCommand OK");
DataTable schemaTable = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"});
MessageBox.Show ("schemaTable OK"); //never display !!!

What do you think about this ?

Followup

Message
Date: 2006-07-04 17:15
Sender: tommaso gastaldi

Hi Shachar,
I did not mean to sound offensive. Sorry if sounded as such. I though you were happy to be notified about bugs.

When I develop something I am always looking for someone who tells me my bugs. You know, I spent all day struggling with postgres. And only now I found this is a known bug.

Well, frankly, I would never expect that an OleDb driver does not support OleDbSchemaGuid. It's just impossible.

I just wanted to stress how important is this matter. It's not just a little bug. It's the basis of the OleDb philosophy.

As to sponsorship, sorry I am just a poor developer...
but in case I make money, be sure I will keep Postgres on my list

:)

Anyway. Congratulation for the (voluntary) effort and the nice interface !

Tom
tommaso.gastaldi@uniroma1.it
Date: 2006-07-04 16:33
Sender: Shachar Shemesh

Whenever I see replies such as yours, Tom, I can't help but wonder whether you realize that you get something that is worked on by me on purely volunteer basis, unless someone is willing to sponsor the action.

Yes, it is on my to do list to fix Schema support. No, it will not happen unless either YOU implement it, or you decide to sponsor such development.

I will, in all likelyhood, get around to it eventually. I have no idea when.

Use the mailing list if you want more info.

Shachar
Date: 2006-07-04 16:19
Sender: Nobody

Yes!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I have the same problem.

This issue need to be fixed immeditely. This is the most important feature of an OleDb driver. Without this stuff its unusable.

IMPORTANT!!!!!!!!!!!!!
As a programmer I cannot even thing to support Postgres in my applications until this has not been fixed. This is a very serious limit.

Please, correct it ASAP!!!!!!!!!
I would like to be informed as soon this crucial bug is corrected.

You do not have to enable all the possible schemaguids but make sure to do the following (in order of importance):

OleDbSchemaGuid.Provider_Types
OleDbSchemaGuid.Columns
OleDbSchemaGuid.Tables
OleDbSchemaGuid.Views
OleDbSchemaGuid.Foreign_Keys
OleDbSchemaGuid.Procedures
OleDbSchemaGuid.Catalogs

Tom
tommaso.gastaldi@uniroma1.it

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge