PC Review


Reply
Thread Tools Rate Thread

Cannot initialize Microsoft@ SQL analysis services

 
 
KK
Guest
Posts: n/a
 
      16th Jul 2009
'open the connection to the project file
Dim conData
Set conData = CreateObject("ADODB.Connection")

conData.ConnectionString = "Provider=MSOLAP.2;User ID="";Data
Source=C:\New Folder\Task Usage.cub;Location=C:\New Folder\Task
Usage.cub;Initial Catalog="";Client Cache Size=25;Auto Synch Period=10000"
conData.ConnectionTimeout = 30
conData.Open

'********************************************************************************************************
'*** locate tasks with durations greater than 10 day
'********************************************************************************************************

Dim rsData
Sql = "Select TaskID, TaskName, TaskDuration, TaskStart, TaskFinish,
TaskMilestone, TaskSummary,"
Sql = Sql & " TaskPredecessors, TaskSuccessors, TaskDurationElapsed,
TaskPercentComplete from tasks"
Sql = Sql & " Where TaskSummary=0 and TaskMilestone=0 and
TaskDuration > 48000 and TaskPercentComplete<100"
Sql = Sql & " Order by TaskID"
Set rsData = conData.Execute(Sql)


Why every time when i debug ,it will stop at condata.Open there ?Anyone can
help me ?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Add-in for Analysis Services Mike S Microsoft Excel Crashes 0 22nd Sep 2004 09:12 PM
excel add in for sql analysis services Microsoft Excel Misc 0 6th Sep 2004 04:31 PM
Services snap-in failed to initialize Jerry Windows XP Help 0 18th Apr 2004 04:12 PM
Analysis Services conflict Brad Coney Microsoft Dot NET 0 18th Nov 2003 08:01 PM
Services.exe failed to initialize Wendy Windblows Windows XP Networking 1 29th Sep 2003 11:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:51 AM.