[#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