Re: DMX cmd can't see Access db

You are using SQL Server Management Studio, right?
It looks like the error is coming from the Access provider. Is it possible
that the server cannot see the Access MDB file?

--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

"Dean Garrett" <DeanGarrett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F54F30B6-89A9-4938-8906-6FF10EC3B628@xxxxxxxxxxxxxxxx
OK, that error went away, but now I get this error:

The connection either timed out or was lost.

The error occurred immediately. I looked at the Advanced properties for
AS,
but there are many time-out related properties. Do I have to set one of
these?

I'm trying to follow the examples from Chapter 5 of "Data Mining With SQL
Server 2005" by Jamie LacLennan and ZhaoHui Tang, but the book certainly
doesn't mention these important details.

Any clues? Thanks!!!


"Bogdan Crivat [MSFT]" wrote:

You will also have to change the value of the
DataMining\AllowedProvidersInOpenRowset property (visible after you check
"Show Advanced (All) Properties")
The value of this property shoul dbe a list of supported providers,
"microsoft.jet.oledb" in your case, or "[All]" to allow any OLE DB
provider
--
--
--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

"Dean Garrett" <DeanGarrett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5E1192BA-4E22-4AFF-B02B-966170AD8A0B@xxxxxxxxxxxxxxxx
Hello,

Yes, this property is set to True, although the default value is
False, I
recall setting to True manually. It seems to complaining about the
OLEDB
provider I'm trying to use in order to read data from an Access
database.
I
made sure the Access db is there. In fact, I used the same database as
a
data
source in the BI studio ... no problem there. Its just when using DMX.

Thanks!!


"Dejan Sarka" wrote:

Dean,

Have you checked wheteher the AllowAdHocOpenRowsetQueries server
property
is
set to true (in SSMS; right-click on your AS and slect Properties)?

--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view
of
the
sender.
This message does not imply endorsement from Solid Quality Learning,
and
it
does not represent the point of view of Solid Quality Learning or any
other
person, company or institution mentioned in this message

"Dean Garrett" <DeanGarrett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:AED28F7D-E375-449A-9B4A-55E949CBC070@xxxxxxxxxxxxxxxx
When I execute the DMX command below to train a decision tree model,
I
keep
getting this error about the OLEDB provider. What's wrong???

Thanks!!

Error (Data mining): This server is not configured to support the
'provider=microsoft.jet.oledb' provider used in the OPENROWSET
clause.
Exe


insert into CollegePlan_DMX1
(studentid, gender, iq,parentencouragement, parentincome,
collegeplans)
openrowset('Provider=Microsoft.Jet.OLEDB',
'data source=c:\mydrive\ms sql server data mining
book\appendixa\collegeplans.mdb;',
'select StudentId, Gender, IQ, ParentEncouragement, ParentIncome,
CollegePlans from CollegePlans')









.

Relevant Pages

  • Re: DMX cmd cant see Access db
    ... I'm trying to follow the examples from Chapter 5 of "Data Mining With SQL ... provider I'm trying to use in order to read data from an Access database. ... Have you checked wheteher the AllowAdHocOpenRowsetQueries server property ... CollegePlans from CollegePlans') ...
    (microsoft.public.sqlserver.datamining)
  • Linked server to ODBC DSN
    ... Server, and want to create a linked server to this same ODBC DSN: ... Provider = "Microsoft OLE DB Provider for ODBC Driver" ... Then i connect to the SQL Server using QA, and try to run my query (that ...
    (microsoft.public.sqlserver.server)
  • Re: Implementing ASP.NET to get the result of the Data Mining
    ... Your web application is running as some user that has no permissions on the ... Analysis Services server. ... I have installed the SQL Server 2005. ... of examples in Jamie/Zhao book DATA MINING SQL SERVER 2005. ...
    (microsoft.public.sqlserver.datamining)
  • Re: oledb Foxpro provider question.
    ... Your first post threw me off: "Note When you use Visual FoxPro OLE DB ... Provider as a SQL Server-linked server, ... I didn't know that actually used sql server. ...
    (microsoft.public.data.ado)
  • Re: SQL 2005 64bit ODBC Connections to AS400
    ... Finally had success using the ISeries OLE DB provider MSDASQL ... server using Management studio and check the behavior. ... "An error has occurred while establishing a connection to the server. ... connecting to SQL Server 2005, this failure may be caused by the fact ...
    (microsoft.public.sqlserver.connect)