Visual Basic

Re: SQLClient and System.Security.SecurityException

10-Jun-04 20:16

Hi,

I'm trying to create a little service that connect to a SQL database.

I'm using USER ID and password for authentication and everytime I try to open the connection I receive the following error :

System.Security.SecurityException: Échec de la demande pour une autorisation de
type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
 Culture=neutral, PublicKeyToken=b77a5c561934e089.
   at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet granted
Set, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permT
oken)
   at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32
 unrestrictedOverride)
   at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, S
tackCrawlMark& stackMark)
   at System.Security.CodeAccessPermission.Demand()
   at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString const
r)
   at System.Data.SqlClient.SqlConnection.Open()
   at HEG_Console.Module1.Main() in P:\Mes Documents\Visual Studio Projects\HEG_
Console\Module1.vb:line 21

Here is my little little code :

<br />
        Dim cObjConn As SqlClient.SqlConnection<br />
        Try<br />
            cObjConn = New SqlClient.SqlConnection("Initial Catalog=Northwind;Trusted_Connection=true;USER ID=myUser; Password=myPassword;Data Source=myServer")<br />
            cObjConn.Open()<br />
<br />
        Catch se As System.Security.SecurityException<br />
            System.Console.Out.Write(se.ToString)<br />
        End Try<br />

Does any1 know where I'm wrong ?
thx

Dave Kreskowiak14-Jun-04 3:08

Re: SQLClient and System.Security.SecurityException

14-Jun-04 3:08

Try dropping the "Trusted Connection" portion of your connection string. Also, make sure that the UserName and Password is setup correctly in the SQL Manager so that the ID has the correct rights to the database it's supposed to.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

sybux200010-Aug-04 10:32

Re: SQLClient and System.Security.SecurityException

10-Aug-04 10:32

back from holiday....

The problem is not in that way. I've heard something about a policy that you have to create to establish a trust connection between the client and the server when there aren't running on the same computer.

Dave Kreskowiak10-Aug-04 13:05

Re: SQLClient and System.Security.SecurityException

10-Aug-04 13:05

It's not so much a policy ... I think this[^] is what your referring to...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

sybux200010-Aug-04 20:28

Re: SQLClient and System.Security.SecurityException

10-Aug-04 20:28

Your right but I've heard about a method to use with application.
I've got about 500 Pc and I don't want to add all one by one on my windows 2000 Server which is not an Active Dir.

Dave Kreskowiak11-Aug-04 1:31

Re: SQLClient and System.Security.SecurityException

11-Aug-04 1:31

In that case, you can't use a trusted connection. Since all of your machines are not in the same domain, you can't use the same username/password (or SID) for each user that accesses your SQL server. A better method to use, in your case, would be SQL authentication using an SQL user ID and password that is specific to the database you want. This actualy offers you better security because the SQL user ID doesn't have any rights to any other part of the server that is hosting your SQL server. This means that the ID can't be used to open any shares on that box, or anything else for that matter, just the database, tables, views, stored procedures, ... that you specify in the SQL Enterprise Manager.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

sybux200011-Aug-04 6:26

11-Aug-04 6:26

I'm already trying to connect with an SQL user.

this is why I don't understand the error I got !

another problem Datagrid

dotnet_cpp10-Jun-04 12:16

inser hyperlink at launching outlookexpress

10-Jun-04 12:16

I am reading this XMLnode file nad filerting with 2 id's I m getthing back rwoa but I want to make one CustomerID column as hyperlink so when user click on it . they can pass that CustomerID to next page ...

Dim node As XmlNode = ResultAllCustomers(ar)
'Dim ReadNode As XmlNode = node.SelectSingleNode("DATA")
Dim eventID As String
Dim venueID As String
Dim ReadNode As XmlNode = node.SelectSingleNode("//row[@EID='" & eID & "' and @VID='" & pID & "']")
Dim Reader As New XmlNodeReader(ReadNode)

Dim mydataset As New DataSet
mydataset.ReadXml(Reader)

DataGrid1.DataSource = mydataset
DataGrid1.DataBind()

any suggestions how to do that???

skoizumi2911010-Jun-04 9:31

skoizumi29110

10-Jun-04 9:31

I want to launch outlookexpress with hyperlink inside of body.
just like you might see when you select text and go insert -> hyperlink
to put the hyperlink.

ShellExecute Me.hWnd, "open", "mailto:dddd@mydomain.com?Subject="hello"&body="ClickHere", vbNull, vbNull, SW_SHOWNORMAL

When I run what only get simple text with ClickHere in outlookexpress
I want this to be hyperlink. how can I achieve this?

Development Environment : VB6

Shin

Forms Threading Question

Wingnut7410-Jun-04 7:49

Wingnut74

10-Jun-04 7:49

I am not sure if this is the proper forum...

I am looking to create a VB.NET based Forms App that will interact with a Web Service. I want to have a main/UI thread that spawns a thread to handle the web service. How do I then, communicate between the two once this is done? I will need to have the Web Service handling thread send information back to the UI, but also have the UI thread send new information back.

Can someone point me in the right direction or to some articles? I haven't had much luck and, with what I have found, have more questions than answers.

Re: Forms Threading Question

Dave Kreskowiak10-Jun-04 8:40

Re: Forms Threading Question

10-Jun-04 8:40

You don't need threading to handle this. You can use Asynchronous calls to call your WebService. Take a look at these articles on MSDN:
Coordinating Asynchronous Service Calls[^]
Asynchronous Method Execution Using Delegates[^]
Multithreading and Asynchronous Programming in Web Applications[^]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Wingnut7410-Jun-04 13:48

Wingnut74

10-Jun-04 13:48

Outstanding. Thanks!

Sendkeys to messagebox

Brent Lamborn10-Jun-04 7:32

Brent Lamborn

10-Jun-04 7:32

I have a VB6 app that needs to send keys to a message box. Is there a way to use the SendKeys method to do so or is there another way? Also..is there a way to execute the next line of code if a line is interupted by a message box... kind of like On Error Resume Next only instead of an error there is a message box?? Thanks for any help.

"Half this game is ninety percent mental."
- Yogi Berra

Re: Sendkeys to messagebox

Dave Kreskowiak10-Jun-04 8:33

Outlook Object Model Guard

10-Jun-04 8:33

You'll find that the method you've chosen to control another application is problematica at best...

You can use the AppActive function to switch the input focus to the window you want (all you need is the exact title of the window) immediately before using the SendKeys function to send the keystrokes. The problem is, the user or another app can steal the focus at any time after the AppActivate function returns. This means that the focus can be moved before OR DURING the SendKeys function. There is NO ERROR when this happens. There is no way you can catch this situation and handle it. Using SendKey, this is just something you have to leave to chance...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Brent Lamborn10-Jun-04 14:20

Brent Lamborn

10-Jun-04 14:20

Ok..now what I'm really trying to do is find a work around for the Outlook Object Model Guard. The vb6 app gets and sends email through outlook 2003. The Redemption[^] library works well but what about when its time to upgrade to Office 2005 or something?? We have a lot of apps (web and windows)that use Outlook 2003 and we dont want to have to go through each of those in a couple years and clean out all the redemption stuff if redemption doesnt happen to be around.We really need to find a work around without using third party software. Thats why I thought about using SendKeys. I need some code that "watches" for message boxes so I can SendKeys to them as needed.

Re: Outlook Object Model Guard

Dave Kreskowiak11-Jun-04 10:21

Windows service problem accessing network share

11-Jun-04 10:21

Your only work around is to disable the security through policies. But, that would also let the email worms do what they want to. There is no easy way around this. The "SendKeys" method is also not a method I would in production. It's just to unreliable...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Member 116497710-Jun-04 6:02

Member 1164977

10-Jun-04 6:02

I have a VB.Net Windows service that needs to access a network drive. The code works as desired as a console app on the server but fails on the network share access as a Windows service. I have used both the Local System account as well as the local admin account to run the service. Same results both times. In ASP.NET I know the work around is to use Identity Impersonate in the web.config file but this is a Windows app not a web app. Any suggestions are appreciated and I apologize for the cross post.

"Your destiny lies before you, choose wisely."

Re: Windows service problem accessing network share

Dave Kreskowiak10-Jun-04 6:27

10-Jun-04 6:27

You've used both the Local System account and the Local Admin account, neither of which has rights to the network share. You have to run the service under an account that has appropriate rights to the local system AND to the network. That's why the app ran fine in the debugger. It was running under YOUR account.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Simple .. Dropdownlist

dotnet_cpp10-Jun-04 6:02

10-Jun-04 6:02

I am not able to select the 1st item from the dropdownlist.

If I select any other item .. it recognice and i am able to see it in Dropdownlist1.selecteditem.item

any help please

Dave Kreskowiak10-Jun-04 6:29

10-Jun-04 6:29

There is no known problem with the DropDownList. You'll have to post the code your using to populate the list and handle the SelectedItem event so we can see what your doing wrong...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

dotnet_cpp10-Jun-04 7:01

10-Jun-04 7:01

I am reading XMlnode file and row tage have THISNAME AND THISID attributes

Dim NodeList As XmlNodeList = node.SelectNodes("//row")
Dim i = 0
Dim count = NodeList.Count

While (i < count)
Dim element As XmlElement
element = NodeList.Item(i)

Dim thisNameNode As XmlNode = element.Attributes.GetNamedItem("THISNAME")
Dim thisIdNode As XmlNode = element.Attributes.GetNamedItem("THISID")
If Not (thisNameNode Is Nothing) And Not (thisIdNode Is Nothing) Then
Dim thisNameValue As String = thisNameNode.Value
Dim thisIdValue As String = thisIdNode.Value

Dim item = New ListItem(thisNameValue, thisIdValue)
DropDownList1.Items.Add(item)
End If
i += 1
End While

Thanks,

Dave Kreskowiak10-Jun-04 7:27

10-Jun-04 7:27

So far, so good... What about the code that handles the SelectedItem event?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

dotnet_cpp10-Jun-04 8:13

10-Jun-04 8:13

private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged

If DropDownList1.SelectedItem.Selected = True Then
Label3.Text = DropDownList1.SelectedItem.Text
End If
End Sub

here i don't see anything when i select 1st item

Dave Kreskowiak10-Jun-04 8:26

10-Jun-04 8:26

Don't check for the status of the Selected item. I take it your supporting only one selected item at a time. So don't check for the Selected property, you don't need it. Just use this:

Private Sub DropDownList1_SelectedIndexChanged( _
        ByVal sender As System.Object, ByVal e As System.EventArgs) _
        Handles DropDownList1.SelectedIndexChanged
 
    ' This will check to see if an Item is really selected...
    If Not DropDownList1.SelectedItem Is Nothing Then
        Label3.Text = DropDownList1.SelectedItem.Text
    End If
End Sub

If the event that more than one item is selected, this code will return the selected item with the lowest index in the DropDownList Items collection.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

dotnet_cpp10-Jun-04 8:49