When using ASP to connect to SQL Server, if one computer connects to sql server the second computer receives page cannot be displayed until the first computer is done. I have SQL Server running on Windows 2003 and IIS running on Windows 2000. Any help would be greatly appreciated. Thanks
What is the ASP page doing? It might be that you are performing a query that locks the data so the other page has to wait until the first one is done.
Best regards,
Sami Samir
Hi all
i am trying to connect to a AS2005 cube from excel.
On my computer (Excel2003+sp1) i am able to see and broswe the cube.On the user's Pc (excel2003+sp1) I istalled the msolap9.dll but i got this error when i try to connect to the OLAPserver:
"Unable to connect to data source.Reason: Unable to locate database server"
Both me and the user are in the Cube's Role Membership.....
Any idea?
Thx in advance
Are you using this addin or not?: http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en
The message "Unable to connect to data source.Reason: Unable to locate database server".,can mean that the service is down or you can have a firewall problem.
Many causes. Can you supply more details?
Regards
Thomas Ivarsson
|||Thank you so much Thomas, that is was i forgot to install....
thx
