Re: OleDbLiteral

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 12/28/04

Next message: W.G. Ryan eMVP: "Re: PRIMARY KEY required for WRITING data to SQL DATABASE using DA"
Previous message: W.G. Ryan eMVP: "Re: URGENT:Viewing MULTIPLE RECORDS from database using DATASET"
In reply to: Edward Diener: "Re: OleDbLiteral"
Next in thread: Edward Diener: "Re: OleDbLiteral"
Reply: Edward Diener: "Re: OleDbLiteral"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 28 Dec 2004 15:53:17 -0600

On Tue, 28 Dec 2004 13:22:26 -0500, "Edward Diener"
<diener_no_spam_ok@ORsoftware.com> wrote:

､ > ､ > ､ > ､ Does System.Data.OleDb.OleDbLiteral have a purpose or is it just
､ > ､ > there
､ > ､ > ､ > to
､ > ､ > ､ > ､ look good, as if it is used by something when it is not, or will
､ > be
､ > ､ > used
､ > ､ > ､ > in
､ > ､ > ､ > ､ something in the future ?
､ > ､ > ､ > ､
､ > ､ > ､ >
､ > ､ > ､ > I guess it depends upon how much you work with OLEDB interfaces.
､ > It's
､ > ､ > ､ > simply a constant enumerator
､ > ､ > ､ > that maps to a corresponding enumerator in OLEDB. Similar to
､ > ､ > ､ > System.Data.OleDb.OleDbType.
､ > ､ > ､ >
､ > ､ > ､
､ > ､ > ､ It does not appear that there is anything in ADO .NET which uses it
､ > ､ > since
､ > ､ > ､ there are no db properties in ADO .NET. Is it meant to be used by
､ > ､ > calling
､ > ､ > ､ ADO from ADO .NET code ? That would be a novel design idea.
､ > ､ > ､
､ > ､ >
､ > ､ > I've not used it but it appears to be for interfacing with OLEDB, not
､ > ADO.
､ > ､
､ > ､ How is one supposed to interface with OLEDB from within ADO .NET, even
､ > ､ considering one is using the System.Data.OleDb set of classes ? I do not
､ > see
､ > ､ anything in those classes which allows one to access OLEDB ActiveX
､ > objects
､ > ､ from the System.Data.OleDb classes of ADO .NET.
､ > ､
､ >
､ > I don't think that is what I'm saying. The System.Data.OleDb managed
､ > provider
､ > interfaces with OLEDB using several classes. If you're looking for the
､ > specific
､ > .NET mechanism I would have to say it's schema related, probably the
､ > GetOleDbSchemaTable method.
､
､ Getting schema information gets information about a particular database but
､ I do not see how this interfaces with OleDbLiteral nor do I see how schema
､ information gets me the sort of RDBMS specific information to which
､ OleDbLiteral refers.
､

They are literal values returned when you query the database schema using
OleDbSchemaGuid.DbInfoLiterals:

http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemdataoledboledbschemaguidclassdbinfoliteralstopic.asp?frame=true

The corresponding usage in ADO is OpenSchema with adSchemaDBInfoLiterals.

､ I am not looking for information about database objects but rather about the
､ RDBMS itself. This is what OleDbLiteral implies. If you can find any usage
､ for OleDbLiteral in order to obtain information about the RDBMS, it would be
､ appreciated, otherwise I will assume that it is in there just to look good.
､

If you're looking for specific information about the RDBMS you may want to
specify what those are, and identify the methods that were used in ADO. I don't
understand the distinction you're making between the RDBMS and it's objects.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Next message: W.G. Ryan eMVP: "Re: PRIMARY KEY required for WRITING data to SQL DATABASE using DA"
Previous message: W.G. Ryan eMVP: "Re: URGENT:Viewing MULTIPLE RECORDS from database using DATASET"
In reply to: Edward Diener: "Re: OleDbLiteral"
Next in thread: Edward Diener: "Re: OleDbLiteral"
Reply: Edward Diener: "Re: OleDbLiteral"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Python database access questions
... I want to write an application that will talk to a RDBMS. ... system and database backend point of view. ... lower level than say ADO and I feel this may potentially cause me more ... ADO allows you to reference field objects when manipulating records ...
(comp.lang.python)
Re: OleDbLiteral
... Getting schema information gets information about a particular database ... I do not see how this interfaces with OleDbLiteral nor do I see how ... This is a good way of getting some RDBMS ...
(microsoft.public.dotnet.framework.adonet)
Re: Data provider run-time information
... Creating wrappers for some database systems and then giving up on all others ... ADO .NET, still some subset of all the possible areas of information should ... that it uses C++-like interface polymorphism and specific RDBMS ... But OleDb is not a specific provider set ...
(microsoft.public.dotnet.framework.adonet)
Re: OleDbLiteral
... anything in those classes which allows one to access OLEDB ActiveX ... > You can retrieve schema information about any number of database objects, ... RDBMS itself. ... is that ADO .NET dropped the ability to generically get RDBMS specific ...
(microsoft.public.dotnet.framework.adonet)
Re: Specifying fields data type in select statement
... When ADO returns the dataset, it creates a schema based on the SQL. ... ShortInt to what should really be a boolean field. ... important is that I have a data grid which looks at the schema and decides ...
(microsoft.public.access.queries)