Error 80004005 : OLE DB or ODBC error

[jepe666]

My code like :
strProvider = "PROVIDER=MSOLAP.3"
strLocation = "LOCATION=c:\DocumentCube.cub"
strSourceDSN = "Data Source=localhost;Initial Catalog=AdventureWorksDW;Integrated Security=SSPI"

Set cn = New ADODB.Connection
s = strProvider & ";" & strLocation & ";" & strSourceDSN & ";" & strCreateCube & ";" & strInsertInto & ";"
Screen.MousePointer = vbHourglass
cn.Open s

Error in the line : cn.Open s

I don't know why is it error?

 

[genomon]

Here is one of the 13,000 articles returned by Google, using your subject as the search criteria:

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_14521

If this is no help, try searching, and hopefully one of the other 12,999 might be of use.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[PeterWallace]

hsve you used debug

and found out what S = ... actually Is ?

 

[jepe666]

I already found out what the incorrect is..
But have another problem..
I got error : cannot conenct to the datasource 'cannot connect to server localhost'.The server is either not started or too busy.
I check MSSQLServer is running and MSSQLOLAP is running too..
Now,can help me with this problem?

Thanks for advance..

rgds JP.

 

[BobRodes]

Ok. So the first problem was that you didn't understand what values needed to be in the connectionstring. The next problem is that you can't connect to your local host server. You'll need to work with your administrator to find out why. Just because it's running doesn't mean the server will automatically let you connect to it.