While in the cube editor I received an error when trying to create a Calculated Member.
"Unable to obtain meta data. Unspecified error".
I am trying to get through the Northwind OLAP tutorial and this error has stopped me cold. Any help would be appreciated.
I installed OLAP Services on my SQL Server 2000 server and it comes up and runs just fine. When I open SQL Enterprise Manager the OLAP Services do not show up in the the tree.
What have I failed to do to get this service to appear?
I changed the connection string to:
strconnect = "DSN=cavion;Database=CMC3;Provider=SQLOLEDB;UID=" & _
txtUserID.Text & ";PWD=" & txtPassword.Text
And got this error:
1)
Invalid connection string attribute
(Source: Microsoft OLE DB Provider for SQL...
MDAC was updated. I also tried changing the connection string to include Provider:
strconnect = "Data Source=cavion;Database=CMC3;Provider=MSDASQL;UID=" & _
txtUserID.Text & ";PWD=" & txtPassword.Text
The original message I received used this code:
Dim errLoop As Object
Dim strError, strRet As String
On Error GoTo ErrorHandler
Set m_Connection = New ADODB.Connection
strconnect = "Data Source=xxxxxx;Database=XXXX;UID=" & txtUserID.Text & _...
I have an existing VB 6 application running SQL Server 6.5. After installing a newer version of the application on an NT 4.0 workstation, I get the message listed in the subject, "Invalid connection string attribute". This does not happen from win 2000 or win 98. Any help on this...
Chad, Thanks for your response.
I checked my code and I am using a clientside cursor. It is a dynamic cursor. I do have a global connection object. I close the recordset after the retrieve, but not the connection.
Those were all good things to recheck though.
The problem I seem to have is...
I have an application that builds a SQL statement based on search criteria, and displays the results. The first retrieve runs rather quickly, subsequent searches tend to run very slow. This happens even when the exact same search criteria is used.
One distinct difference between the first...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.