Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help overcoming security error on deployed
Message
General information
Forum:
ASP.NET
Category:
Security
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01164775
Message ID:
01164829
Views:
12
Richard (and everyone else)

two things.

1. I rewrote the code without the vfptoolkit, that did not solve the problem, still have the same thing, but the toolkit is now one less layer.

2. (A) It still runs perfect on my development machine, with the datbase located another machine.
(B) I had be attempting to run the application with it stored on a file server and still receive the same error.
(C) When I copied the application directory to the individual workstation, it ran fine.

That doesn't make too much since to me, I changed the rights on the directory where it's stored to everyone full, and the same error.
    Public Shared Function GetDataView(ByVal tcSQLCMD As String) As DataView
        Dim cnn As New SqlClient.SqlConnection
        Dim cmd As New SqlClient.SqlCommand
        Dim da As New SqlClient.SqlDataAdapter
        Dim ds As New DataSet

        cnn.ConnectionString = AppGlobals.AppConnString
        Try
            cnn.Open()
        Catch ex As SqlClient.SqlException
            MsgBox("Can't Open" & vbCr & ex.Message, MsgBoxStyle.Critical, "Title")
        End Try
        cmd = cnn.CreateCommand
        cmd.CommandText = tcSQLCMD
        da.SelectCommand = cmd
        da.Fill(ds)
        Dim dv As New DataView(ds.Tables(0))
        cnn.Close()
        Return (dv)
    End Function
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform