|
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.
|
|
|
|
|
i can connect to the Server remotely in the Client Machine
Vuyiswa
|
|
|
|
|
Have you looked at this?:
http://support.microsoft.com/kb/842419
You always pass failure on the way to success.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Thank you it working localy, you are a star
Vuyiswa
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 .
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Thanks Luc,
I may just give that a go - it sounds like a neater solution than the one I have used.
Guy
You always pass failure on the way to success.
|
|
|
|
|
Hi!
I need to develop a Guest Book without Database support. Please help me how can i develop a Guest Book that do not use Database to store the information but .txt file use to store information and read data from a .txt file and show on the text boxes...........Please help me with Code Example
|
|
|
|
|
|
|
hi
my query is regarding Macros in Excelsheet! i have already an excel report
generated from an application. which is locked.. i mean it is unedittable. i want to add few more columns in that report .. depdending upon already existing columns in the excel report.
for example...
TimeIn TimeOut
above 2 r already existing fields in excel report. i want to generate two more columns depdendin upon the values in above 2 fields. First i want to ask is it possible to do this in locked excel report...if yes then how? if no then what is another alternative. Or as somebody adviced me to use macros, is it possible with macros? how to write such a macro... i haven't worked with macros!
thanx in advance..!
|
|
|
|
|
What was it that you were trying to do?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi how do I add user in windows users and groups with code?
Progress is a process , so value it
|
|
|
|
|
This depends on what provider you wish to use.
With the LDAP Provider, you perform the following:
Imports ActiveDS
Dim ObjOU As ActiveDs.IADsOU
Dim moNativeIADsObject As IADsUser
Dim mstrUsername as string = "NewUserName"
Dim mstrOUPath as string = "DC=MyDomain,DC=com"
Dim mstrPassword as string = "Asecret1"
'Connect to the Organisation Unit (OU) where the account is to be created using OrgUnit
ObjOU = GetObject("LDAP://" & mstrOUPath)
'Create the account
moNativeIADsObject = ObjOU.Create("User", "CN=" & mstrUsername)
moNativeIADsObject.Put("samAccountName", mstrUsername)
moNativeIADsObject.SetInfo()
' Ref: http://www.microsoft.com/technet/scriptcenter/guide/sas_ads_zjvb.mspx?mfr=true
moNativeIADsObject.SetPassword(mstrPassword)
moNativeIADsObject.SetInfo()
|
|
|
|
|
Hi
I have used WinNt. It works fine but now I need to add the user via a Web service. I have a web method that attemts to create the user but acess is denied which I expect but I need to side this problem
Progress is a process , so value it
|
|
|
|
|
A Web Service runs under an account that doesn't have any rights to the domain to add users. Your web service code has to get the username and password of a domain administrator account so it can use those credentials so it can Impersonate the user adding the account to the domain.
Google for "web service impersonation" for all kinds of info, pitfalls, examples, ...
|
|
|
|
|
Is there a simple way to group a bunch of SQL update statements (in VB.Net) together in a transaction scope?
The way that I used, is giving me ENDLESS hassles and problems with MSDTC services and firewalls and and and and and and AND AND AND , it requires that I change various system settings including components services on ALL clients and the server and that I do registry edits etc etc. And STILL it fails on some PC's!
It's just not worth all that hassle!
I am not looking for a solution that involves calling a stored procedure because I'm working with Datasets and their built-in functionality in .Net.
I would appreciate any help from anyone with prior knowledge of such a solution!
_______________________________________________________________________
http://www.readytogiveup.com/[ ^]
"you can't forget something you never knew..." M. Du Toit
|
|
|
|