Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: Analysis manager cube processing error

    I am trying to process a cube and during processing I get a message that " Data source provider error :[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified..." I set up my data connections and everything else as it appeared in the tutorial. I am running XP Professional and MS Server 2000.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    To validate your connection create a file on your desktop with UDL extension. Double-click on it and fill in the blanks. Once done, - rename the file to .TXT and open it in notepad. Modify as needed and use it.

  3. #3
    Join Date
    Aug 2003
    Posts
    328
    I did all this and still I don't get the cubes to process. Do I need to rename the file to UDL after everything? When I process now I get the message "Data Source Provider Error:[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed;IM006..." What should the provider name be in the UDL file? Mine says MSDASQL.1
    Last edited by exdter; 08-23-03 at 22:06.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    As an example, here is what I have in notepad after I create a connection:

    [oledb]
    ; Everything after this line is an OLE DB initstring
    Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="driver={sql server};server=l6064909;database=master;trusted_co nnection=true"

  5. #5
    Join Date
    Aug 2003
    Posts
    328
    I got the cube to process, now when I click on browse data I get a message that states "Unable to browse the cube 'Sales'. Unspecified error." Is this because of the service pack?
    Last edited by exdter; 08-25-03 at 11:28.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •