-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: LovedJohnySmith
Message 2 in Discussion
Dynash: When you are suppose to use OPENROWSET in OLEDB Provider, the Catalog
and schema names are required if the OLE DB provider supports multiple catalogs
and schemas in the specified data source. Values for catalog and schema can be
omitted if the OLE DB provider does not support them. If the provider supports
only schema names, a two-part name of the form schema.object must be specified.
If the provider supports only catalog names, a three-part name of the form
catalog.schema.object must be specified.OPENROWSET does not accept variables
for its arguments. see the example; USE DBSample
GO SELECT R.*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'', Orders)
AS R thanx, Smith
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
