Post reply

analysis server 2000 connection string issues

  • November 13, 2006 at 4:36 am

    #115078

     

    i have just installed a new version of analysis services 2000 on a test machine. when i try to connect to the local host i get the error "Datasource name is too long". I have set the datasource string to

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\MsOLAPRepository$\msmdrep.mdb

     

    This is the same string as i have on other analysis servers, bar the server name, but it still does not work. any ideas?

     

    The olap service is running correctly, just in case its a detail you need to know.

  • November 13, 2006 at 8:07 am

    #671366

    Have you tried testing this connection string in anoher application (like excel) to connect to the repository?  I remember seeing something about this error indicating a malformed connection string.

     

    Steve.

  • November 13, 2006 at 8:11 am

    #671369

    You could also try this suggestion if all else fails. 

     

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply