Hi all,
I use SqlHelper to connect to database. I need to set a timeout to execute some sp because I don′t want to wait for this sp if it make me wait a lot. So I set the Connection TimeOut every time I execute a sp. But this seems not working properly. I set this value to 5 and I execute a sp than runs in 15 but It waits for it.
Any idea
Best regards
www.ITCubo.net
SqlCommands and SqlConnections both have timeout parameters. Maybe one of their values is interfering with what you want.
I just installed 2005 and have an instance of Enterprise on my local machine. My SSAS service appears to be working properly in Services. However, whenever I try to deploy a cube (simple one from tutorial) or try to connect from Management Console, I get rejected. The error message is:
No connection could be made because the target machine actively refused it (System).
I've tried about everything I can think of and can't get past this. Any guidance would be greatly appreciated.
If you have a named instance installed (you can tell by looking at the service name "SQL Server Analysis Services (INSTANCE_NAME)"), then you need to set the Target Server project property (right click on the Analysis Services project in VS, use Properties, go to Deployment tab and set Server to "localhost\INSTANCE_NAME").
If you are disconnected from the network, try using 127.0.0.1 instead of machine name.
Adrian Dumitrascu
|||I'm dealing with the same problem. But as I can se I don't have an instance of Analysis Service running. I have just an instance of Database Engine (my_host_name\SQLExpress). How can I create an instance of Analysis Services? Please!!!|||If you don't have the "SQL Server Analysis Services" service at all (default instance or named instance), you'll need to re-run Setup to install it.
Adrian Dumitrascu
