All,
I'm having a problem with browser data from the cube in BI studio. the error MSG is " a connection cannot be made, make sure the server is running"
in fact , the server is running, and I can see anything within that cube with Management studio, where I went wrong? and what should I do to fix it?
Thanks.
Please do reprocess and reconnect on the browser tab.sqlMy problem is that i'm doing the check algorithm when the click event is pressed (set all buttons false, if EOF is false, enabled last and next buttons, if BOF is false, enable first and previous buttons. However, when i test it and click next until it reaches the last record, i have to click it one more time for it to be disabled:
rs a recordset object
Private Function checkRecord() As Boolean
checkRecord = True
tsbLast.Enabled = False
tsbNext.Enabled = False
tsbFirst.Enabled = False
tsbPrevious.Enabled = False
If Not rs.EOF Then
rs.MoveNext()
If Not rs.EOF Then
tsbLast.Enabled = True
tsbNext.Enabled = True
Else
checkRecord = False
End If
rs.MovePrevious()
End If
If Not rs.BOF Then
rs.MovePrevious()
If rs.BOF Then
checkRecord = False
Else
tsbFirst.Enabled = True
tsbPrevious.Enabled = True
End If
rs.MoveNext()
End If
End Function
Is there a cursor location property that returns a integer identifying location of the record? I really hate how BOF and EOF returns true only if the current cursor location is after the last or before the first (its like starting an index at -1, and not 0, and i can't add or subtract from the EOF and BOF indices) or a much more efficient way of doing this?
You might want to look into using the recordset object's AbsolutePosition property. Combined with the Recordcount property, you should be able to determine your current location at all times. Note this depends on the underlying OLEDB provider you are using. For more information please visit http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdproabpos.asp
Regards, Uwa.
|||Hello,
What I've done in the past with ado to get around this is to create a member variable, called say "_CurrentPosition" that I set to 0 when I first populate the RS, then increment/decrement when MoveN is called. This way, you can just check the _CurrentPosition variable to achieve what you want:
if (CurrentPosition == rs.RecordCount)
{
// disable move next button etc
}
else if (CurrentPosition = 0) //or 1 if you didn't create it as zero-based!
{
// disable move first button etc
}
I know it's not exactly what you're after, but there is no native property/method that ado exposes. As you may have discovered, the EndOfRecordset event fires only after you attempt to move beyong EOF...
Cheers,
Rob
|||Hello,
Just seconding what Uwa said: be careful using the AbsolutePosition property as this is provider dependent and I have never been able to utilise it with any degree of confidence.
Cheers,
Rob
|||You can try using ADO Data Control. You can find an example at - http://www.devarticles.com/c/a/Visual-Basic/Implementing-An-ADO-Data-Control-With-VB6/|||Thanks for all the replies, it seems that using OleDB as the provider instead of ADODB would make the most sense. It is a bit more coding, but not enough to persuade me to mess with ADOi 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.
I assume you use Analysis Manager or DSO program to connect, and you change the "Repository Connection String" property from Analysis Manager. Can you check whether you can open msmdrep.mdb repository file from Access ? Or try to migrate repository to SQL Server - will you get the same error ?Hello All,
I have a SSIS package, desgined in such a way that, there is a table called connection which hold the connection name i.e similar to my DSN connection name & a ID for each DSN there is a unique ID. Now i want if there is a 10 record in the table & i have only 5 DSN connection then i'll work for 5 & for other 5 it 'll skip the process. my task is running success fully for 1 connection. i have used foeach loop container & 3 varibable for that 2 for holding the table value & 1 for refereing the recordset
thanks
So are you saying that the table holds 10 records but only 5 of them are valid for the particular package that you are currently executing?
Then you need to filter the list of connections that you want to "use". Can you not hardcode that filter per package?
Sorry, I don't really understand the requirement.
-Jamie
|||
take a example
i have a table table1(id,DsnConnectionName,.) table has 20 records. that means there is a information for 20 DSN connection. But my machine has only 5 DSN Connection. That is in that table. i have first i'm collecting these record in a record set then connect that data flow task with foreach loop. i have 2 variable 1 hold the ID & another DSNConnectionName.
in that foreach loop container i have placed a script task which is setting the connection according to the DSN name assign in that variable. but when the dsn connection with that name is not available in my system then i gives error. for that i use try catch but due to this it;'s running & inserting data each time.
|||Why can you not just create all the required DSNs?
Why would you try andrun something against a DSN that does not exist?
If you're not going to create the DSNs then, like I said before, you need some way of filtering the list of connections that you iterate over.
-Jamie
|||
Thanks for your keen interest in my problem.
I got the solution,
solution is very simple i used try catch mathod & set dts.taskresult = dts.results.failure for error condition
Hello!
I have problem when opening a package or running it through SQL Server Agent and the Server in the Connection is not available. (I have tried with (M) SSIS > Work Offline, it helps opening it, but not running it).
The package has a Foreach Loop Container that loop through several Companies. Each Company have different Connection.
It exist one ODBC and one OLEDB connection. They have the Expression “ConnectionString” set to an variable (@.[User::varODBCConnectionString]/ @.[User::varOLEDBConnectionString]).
The Foreach Loop Container property ForceExectionResult is set to Completion. This results in that if one company is not available when trying to access it, the loop will continue with the next Company.
But the variables have a value from the beginning. If the server in the variables is not available, it is not possible to open the package or execute it through SQL Server Agent.
I tried to set the Property DelayValidation to True on the Connections, but this did not help.
Dose anyone have any ide how get around this problem?
Best regards,
Tina
Hi Tina,
You need to set DelayValidation=TRUE on the tasks that use those connection managers, not on the connection managers themselves.
Regards
Jamie
|||Hello Jamie!
Thank you very much, it works now, bouth SQL Server Agent and in SSIS. (I also need to set Delay Validation = TRUE for att least the ODBC connection.).
Best regards,
Tina
The report server cannot process the report. The data source connection information has been deleted
I want to make a copy of a report. I go into report properties on the SSRS, click edit and download the .rdl to my computer.
I then upload the report, using a different name.
I then get the above error.
If I copy the report to the same location as the shared data source, and the above error disappears.
But now the report doesn't work - no parameters in the dropdown lists.
My question is : Why does a copy of a report, uploaded to the SSRS, not work, when the original is sitting right next to it, with the same rdl definitin, in a working state?
Are all the datasets using a single shared data source? Check that no private data sources are being used. After re-uploading the report with a different name, go to the properties page in report manager and in the data sources section make sure that you check all the datasources being used. Repoint it to the shared datasource and retype any connection strings and usernames and passwords for the data sources. I think for security reasons these are ommitted when you export the RDL.|||
Adam,
You are right. I checked the Data Sources, and there were two shared data sources that were marked invalid. However, I notice that the parameters have also been messed up. In the original report, there was no default parameter specified, whereas the new report (copied and uploaded) indicates a default parameter, which happens to be an invalid value. Because the dropdown boxes for the other parameters are linked, these dropdown boxes don't populate. My reasoning says that the uploaded .rdl should be the same as the copy I downloaded. I can see that it has been changed when referencing Data Sources. Why is there this difference in the parameters? Is this "by design"?
Question : Why does the parameter default value change when I upload the .rdl using a different name?
Question: How do I fix the problem?
|||I notice that the new report (copy) has two problems with the parameters:
1. Parameter is no longer marked "hidden", but is marked "prompt the user"
2. Parameter contains an invalid default value.
I have changed the parameter so that it is now marked "hidden", and so that the default value is the same as the original report (which was empty). The report now works.
Perhaps somebody has an answer to the problem below (repeated from previous post):
Question : Why does the parameter default value change when I upload the .rdl using a different name?
