clickonce accessing a sql server

Hot Topic

XML Serialization on Windows Forms
trackbar
Column Header Names
what tables have changed
Connect to MS Exchange 2000
only 1 record
highlight the contents of textbox
MenuStrip and Toolstrip Sound
Best way to create a PDF from data
Force slection in ListView?

Windows Forms

msvcp77.dll
Please Any help (MdiWindowListItem)
why my Lines disappear
Cross-thread operation not valid...
Slow processing for Databound Combobox
Setting up IIS for Web-Deployed
Add ins
Visual Inheritance Issues
Length of Turn - Microseconds
Data Binding

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

  • Angelito

    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

  • Robert Wishlaw

    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...



  • Alexandre M

    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. 

  • clickonce accessing a sql server
Answer this question