clickonce accessing a sql server

Hot Topic

Sorting problem in DataGridView
User Control
DataGridView DefaultValuesNeeded
What's the best desktop db for a windows forms app?
Passing credentials to internet deployed winform application
Form Based on one record
DataFormatString in GridView
Does "ClickOnce" download the entire application every-time I update it?
Image ListView Control
opening .xls and .csv files

Windows Forms

Center form?
Which data provider do I use for Sybase?
Prevent Flickering
TabIndexChanged event not firing? (VB.NET 2003)
FillWeight and binding (DataGridView)
128 Bar Code Printing
Databound Combobox Problems minor correction to earlier post
Functions in Expressions
Localized resources for Controls
Abort Startup, when Error occurs in Me.Startup

clickonce accessing a sql server

I have read that you can have a direct connection to SQL server with a clickonce application.  But there is nothing out there about how to do it.  I'm curious to know the restrictions on this, are we allowed a direct connection or do we have to move to an application server. If you have to move to an app server are both .net remoting and web services allowed

Thanks
T

Answer this question

clickonce accessing a sql server

  • Matthew Devine

    So you would setup the connection to the SQL server just like you would a normal form.  I am trying to make a easy deploy for remote users that use a relatively simple app that needs a sql connection.  We have almost completed our tranfer from VS2003 to VS 2005 and at that point will be working on this project.  Could you give me any helpful tips on the permissions that it will take to access SQL server through a clickonce deployed app....

    Thanks
    T

  • MagicCity33

    ClickOnce is just the deployer technology for the Application and has no special feature or restriction when it come to accesing an SQL server.

    You can perform any action withing an ClickOnce deployed app (It will have to be deployed requesting LocalMachine permissions) that you would do if you just copied the App locally to the machien and ran it. 

  • IJay

    Just set it up like you would on a normal form.

    The only thing you might need to do is give permissions to the app... which you can request by going to the security page of the project properties. One of the permissions is SQLClientPermission.

     

    HTH...



  • clickonce accessing a sql server
Answer this question