This is a migrated thread and some comments may be shown as answers.

[Solved] HelpDesk demo app... where?

6 Answers 222 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

6 Answers, 1 is accepted

answered on 21 May 2009, 11:40 AM

helpdesk.zip

Hello Steve,

Please find attached a previous version of the Help Desk sample. We have removed the online demo as the new Web Mail sample implementation is much more useful for customers.

Regards,
Ivo
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 21 May 2009, 11:12 PM

Thanks for the code!
Of course, I tried it straight away <g> . got a bit of a problem though, when I first try to run it:-

Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Documents and Settings\Steve Bywaters\My Documents\Visual Studio 2005\WebSites\HelpDesk\App_Data\HelpDesk2.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:


            Line 34:         Dim dbCon As New SqlConnection(connstr)
Line 35: 
Line 36: dbCon.Open()Line 37:         Dim strSelect As String = " SELECT UserID,Name,Image From Users ORDER BY Name"
Line 38:         Dim adapter As New SqlDataAdapter(strSelect, dbCon)

In the local App_Data folder there is HelpDesk2.mdf and HelpDesk2_log.ldf, so...??

Steve

answered on 22 May 2009, 11:22 AM

Hello Steve,

This is working OK on our side. It seems to be a problem related to the local SQL instance. Have you experienced any similar problems with other demos? Is the demo running as expected on another machine? What SQL server are you using?

There are a couple of suggestions here that you can try:
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/6dfdcc22-7a81-4e8f-a947-c1ce6982d4b3

Sincerely yours,
Ivo
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 23 May 2009, 05:54 AM

This is working OK on our side. It seems to be a problem related to the local SQL instance

What happens if you run it there, not using VS, but instead running from a browser, and using IIS as the local 'server'?
i.e. like a standalone site

I changed the |DataDirectory| for the real path like this:

add name="HelpDesk2ConnectionString" connectionString="Data Source=STEVE830\SQLEXPRESS;AttachDbFilename=.\App_Data\HelpDesk2.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

Still no good...