sql server data mining: Openrowset -- sql server data mining

Re: Openrowset

Dejan Sarka
10/25/2006 12:00:00 AM

sql server data mining: Hi!

Check the AllowedProvidersInOpenRowset server property. You can learn about
all server properties from a whitepaper "SQL Server 2005 Analysis Services
(SSAS) Server Properties" at
http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx.

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

[quoted text, click to view]

Openrowset

newton610 NO[at]SPAM yahoo.com
10/25/2006 1:40:05 AM

my DMX is:
INSERT INTO [Analyze Shipments]
(
SKIP,
[Store Id],
[Vendor Name],
[Product Type],
[Days Since Last Shipped],
[Quantity]
)
OPENROWSET('Microsoft.Jet.OLEDB.4.0','Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\data mining va XML\0212025_0212279\DATABASE\Access\SavingsMart\SavingsMart.mdb;Persist Security Info=False',
'SELECT DISTINCT
"vw_Shipments"."ShipmentID"
AS "Shipment Id",
"vw_Shipments"."DaysSinceLastShipped"
AS "Days Since Last Shipped",
"vw_Shipments"."StoreID"
AS "Store Id",
"vw_Shipments"."Quantity"
AS "Quantity",
"vw_Shipments"."VendorName"
AS "Vendor Name",
"vw_Shipments"."ProductType"
AS "Product Type"
FROM "vw_Shipments"')

and error:
Executing the query ...
Error (Data mining): This server is not configured to support the 'microsoft.jet.oledb.4.0' provider used in the OPENROWSET clause.