What is the best way to grant login and database access toan end user in a ClickOnce application?

Thanks

Hi Giggiehurtz,

Based on my understanding, the database file of a ClickOnce application is installed to the ClickOnce Data Directory and is not the same directory as the application. Thus we should get the database from the Data Directory. The following thread might help you with the correct connection string.

• http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2400064&SiteID=1

For more details about data file in ClickOnce, please check:
http://msdn.microsoft.com/en-us/library/d8saf4wy(VS.80).aspx
http://msdn.microsoft.com/en-us/library/bb756885.aspx

Best regards.
Rong-Chun Zhang

Windows Forms General FAQs
Windows Forms Data Controls and Databinding FAQs

An attemp to access the database included in a ClickOnce download retruns an "attempt to auto-attach database" failure message.

File.Exists(<database name and path>) returns false, but I can see that the file does exist by looking on the hard drive.

As File.Exists will return false if the caller does not have the required permsissions, so I believe that this must be the cause of the problem.

What's the best way to give the required permissions?

Hi Giggiehurtz,

Based on my understanding, the database file of a ClickOnce application is installed to the ClickOnce Data Directory and is not the same directory as the application. Thus we should get the database from the Data Directory. The following thread might help you with the correct connection string.

• http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2400064&SiteID=1

For more details about data file in ClickOnce, please check:
http://msdn.microsoft.com/en-us/library/d8saf4wy(VS.80).aspx
http://msdn.microsoft.com/en-us/library/bb756885.aspx

Best regards.
Rong-Chun Zhang

Windows Forms General FAQs
Windows Forms Data Controls and Databinding FAQs

What database are you using? SQLServer, SQLServerExpress, SQLServerCE, Access, Oracle, Sybase?

Are you deploying it with the ClickOnce application? How are you deploying it? It is an included file?

RobinS.

GoldMail.com