Visual Basic

9-Jul-07 0:52

i have fnished my VB.net Application. i want to install the Application to a System that has not .net Framework installed. and some other system have .Net installed. my application is a database application that connects to a SQL server that is in another Building. when i run my applicatin in another system, even if .Net framework is installed it gives me the Following Error

<br />
Request for the Permission of Type System.Data.SQlClient.SQlClientPermission, System.data, Version= 1.0.5000.0, Culture=Neutral, PublicKeyToken=b77a5c561934e089 failed.<br />

Thank you

Vuyiswa

GuyThiebaut9-Jul-07 1:04

9-Jul-07 1:04

This looks like a permissions issue from the error message.

The user you are running the application under will need to be registered both on the server and the SQL database.

Have you checked this?

You always pass failure on the way to success.

Vimalsoft(Pty) Ltd9-Jul-07 1:11

Re: How to Deploy a Vb.net Application [modified]

9-Jul-07 1:11

so does it mean i have to create a User for every peson who has to use the application?
if i create my application in my connection strng i pass the user iD of an Admnistrator and the password, Doesnt it uses that credentials to run on any machine?

thanks

Vuyiswa

GuyThiebaut9-Jul-07 1:24

9-Jul-07 1:24

Yes you are correct SQL server will pick up the connection settings you send. So it looks like you should get a connection to SQL server.

What I wonder is this - can you see the server i.e computer over the network from the client machine? It may be that although SQL server side you are ok - on the windows server side you may not be.
Having said all of that I am not a windows server expert - it is more something I would look at.

Have a look at this link as well.

-- modified at 7:35 Monday 9th July, 2007

You always pass failure on the way to success.

Vimalsoft(Pty) Ltd9-Jul-07 1:35

9-Jul-07 1:35

i can connect to the Server remotely in the Client Machine

Vuyiswa

GuyThiebaut9-Jul-07 1:37

9-Jul-07 1:37

Have you looked at this?:

http://support.microsoft.com/kb/842419

You always pass failure on the way to success.

Dave Kreskowiak9-Jul-07 4:34

Dave Kreskowiak

9-Jul-07 4:34

Vuyiswamb wrote:
i want to install the Application to a System that has not .net Framework installed.

You have no choice but to install the .NET Framework on the workstation you want this app to run on. If you used VB.NET 2005, you MUST install the .NET Framework 2.0.

Vuyiswamb wrote:
Request for the Permission of Type System.Data.SQlClient.SQlClientPermission, System.data, Version= 1.0.5000.0, Culture=Neutral, PublicKeyToken=b77a5c561934e089 failed.

Is your application installed on the workstation or is the code running from a network source, like a file share on a server? If the code is running from ANY source other than the hard drive in the local workstation, you can get this error message. This is because of Code Access Security (look it up on MSDN). Code running from any non-local source is run in a heavily restricted sandbox by default.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Vimalsoft(Pty) Ltd9-Jul-07 5:26

9-Jul-07 5:26

In my Organisation the Users dont have Access to their Local harddisk, now for me to see the Exe to Execute them, i had to install it to the Network drive so i can Access the Exe. the reason is that ma new to VB.NEt, when i Deploy my Application. it creates shortcuts that are not executables, and when i click them they just taking me to the Explorer.

Thank you Dave

Vuyiswa

Dave Kreskowiak9-Jul-07 5:45

Dave Kreskowiak

9-Jul-07 5:45

Vuyiswamb wrote:
In my Organisation the Users dont have Access to their Local harddisk

Lousy policy. It doesn't serve any real purpose other than to infuriate admins and developers...

Vuyiswamb wrote:
i had to install it to the Network drive so i can Access the Exe. the reason is that ma new to VB.NEt, when i Deploy my Application. it creates shortcuts that are not executables, and when i click them they just taking me to the Explorer.

You have no choice but to read up on Code Access Security[^]. It affects every single corner of your application if you have to run the code from an non-local source.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Vimalsoft(Pty) Ltd10-Jul-07 23:59

How do I update my app.config file in code?

10-Jul-07 23:59

Thank you it working localy, you are a star

Vuyiswa

MatthysDT9-Jul-07 0:50

MatthysDT

9-Jul-07 0:50

How do I update my app.config file?

The following code works, but it doesn't save the xml file changes to the disk, when the app is started up again all old values are once again loaded.

My.Settings.Item("NewConnectionString1") = TryConnectionString
My.Settings.Save()

(PS. This is all done in runtime)

_______________________________________________________________________
http://www.readytogiveup.com/[^]
"you can't forget something you never knew..." M. Du Toit

Re: How do I update my app.config file in code?

Vader_Oz9-Jul-07 3:58

Vader_Oz

9-Jul-07 3:58

You have to set the scope of variable to 'User' not 'Application'. Once that is done, you can save your value.

To slightly modify the above, I would perform the following:

My.Settings.NewConnectionString = TryConnectionString

Re: How do I update my app.config file in code?

MatthysDT9-Jul-07 5:50

MatthysDT

9-Jul-07 5:50

Thank you!

One problemthough , my TYPE is (Connection string) which can only be in the Application scope.

_______________________________________________________________________
http://www.readytogiveup.com/[^]
"you can't forget something you never knew..." M. Du Toit

Disable cursor in RichTextBox

GuyThiebaut9-Jul-07 0:35

9-Jul-07 0:35

I have a number of rich text boxes that I want to disable the cursor for.
I make the boxes readonly but if I disable them they turn grey Mad | :mad:

.

The background to this is that I need scrollable text boxes in which error messages will appear. So the user cannot update the data, however it just looks messy having a flashing cursor in a text box if the user clicks on the text when the text cannot be edited.

Any help appreciated

Guy

You always pass failure on the way to success.

SHatchard9-Jul-07 1:59

SHatchard

9-Jul-07 1:59

You can change the cursor in the appearance section in the property grid to type 'cursor'. I only have VS2005 so I dont know for sure if this is exposed in 2003.

Hope that helps.

GuyThiebaut9-Jul-07 2:48

9-Jul-07 2:48

Thanks,

In the end I have decided to allow the blinking cursor to remain as users may want to cut text from the error boxes.

I solved it by setting the TabStop property to false so that a cursor does not blink in the box until the user clicks on the box.

Cheers

Guy

You always pass failure on the way to success.

Luc Pattyn9-Jul-07 2:34

Luc Pattyn

9-Jul-07 2:34

Hi, for showing a list of line-oriented text messages, I prefer a ListBox,
since that one is really line-oriented, and much more efficient in handling
lots of lines. It does not show a cursor, and you can choose whether and how it
supports line selection.

If you need any fancy feature (available in RichTextBox but not in TextBox/ListBox)
you may choose to set the DrawMode to OwnerDraw.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

GuyThiebaut9-Jul-07 2:49