Results 1 to 6 of 6

Thread: deploying small app w/ sql server connection

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2001
    Location
    Austin
    Posts
    397

    deploying small app w/ sql server connection

    I made a small data entry program (1 form) that has a few SQL connections to our SQL Server. I hard-coded in the login and pass to the server and on the server side gave the login read / write access to the database. I then built the project and moved the .exe file to a network folder.

    The problem now is when the users launch the app they get the following error:

    "request for the permission of the type System.Data.SqlClient.SqlClientPermission, System.Data, Version-1.0.5000.0, Culture=neutral, Publickey Token=.......... failed."


    HELP!?

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: deploying small app w/ sql server connection

    You probably only copied the EXE file.... you also need to copy over the dlls in there, and any client using the app must have the .NET Framework installed.

    Tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3
    Frenzied Member Zakary's Avatar
    Join Date
    Mar 2005
    Location
    Canada, Quebec, Montreal
    Posts
    1,654

    Re: deploying small app w/ sql server connection

    If you plan to run the App from the NetWork, then must add some trusty to the App or some NameSpace Objet will raise some security error.
    You may do so, with the "Configuration .NET Wizards" form the control panel

    I think there other way to do so, but i don't know more about it ...

    Hope this will help ......
    Using VS 2010 on Fw4.0

  4. #4

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2001
    Location
    Austin
    Posts
    397

    Re: deploying small app w/ sql server connection

    I dont see any dll files in the project folder.


  5. #5

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2001
    Location
    Austin
    Posts
    397

    Re: deploying small app w/ sql server connection

    Quote Originally Posted by Zakary
    You may do so, with the "Configuration .NET Wizards" form the control panel

    I think there other way to do so, but i don't know more about it ...

    Hope this will help ......

    i found info about the "Configuration .NET Wizards" on microsofts site but i dont want to run around to building to each computer that needs access to this app....

  6. #6
    Frenzied Member Zakary's Avatar
    Join Date
    Mar 2005
    Location
    Canada, Quebec, Montreal
    Posts
    1,654

    Re: deploying small app w/ sql server connection

    I've search the forum and fall on these tread, it might help ...

    http://www.vbforums.com/showthread.php?t=338047&highlight=Deployment

    http://www.vbforums.com/showthread.p...cation+network

    http://www.vbforums.com/showthread.p...cation+network

    Many person have this "problem" and not much solution about this
    Probably on Google you'll find some solution
    Using VS 2010 on Fw4.0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width