Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ConnLocation = "LOCATION=C:test.cub;"
- ConnDSN = "SOURCE_DSN=DSN=TEST;UID=test;PWD=pass;"
- ConnCreateCube = _
- "CREATECUBE=CREATE CUBE [TestCube] (" & _
- "DIMENSION [account_code]);"
- Connection = CreateObject("ADODB.Connection")
- Connection.Provider = "msolap"
- Connection.ConnectionString = _
- ConnLocation & _
- ConnDSN & _
- ConnCreateCube
- ConnDSN = "SOURCE_DSN=""DSN=TEST;UID=test;PWD=pass;"""
- ConnLoc = "C:test.cub"
- ConnDSN = "DSN=TEST;UID=test;PWD=pass"
- ConnSQL = "CREATE CUBE [TestCube] (DIMENSION [account_code])"
- Connection = CreateObject("ADODB.Connection")
- Connection.Provider = "msolap"
- Connection.ConnectionString = "LOCATION=""" & ConnLoc & """;" & _
- "SOURCE_DSN=""" & ConnDSN & """;" & _
- "CREATECUBE=""" & ConnSQL & """;"
Add Comment
Please, Sign In to add comment