I tried to create a local cube (.cub) from SQL 2000 database like following, i alway got an error message " Error# 3001 was generated by ADODB.Connection, Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.".
Need help badly about this, i struggled ith it for the whole morning.
Dim g_sCnn as String
Dim cnCube As New ADODB.Connection
Dim strConnection As String
Dim strProvider As String
Dim strDataSource As String
Dim strSourceDSN As String
Dim strCreateCube As String
g_sCnn = "Provider=SQLOLEDB; Data Source=SVR1; Initial Catalog=DB1; UserId=sa; Password="