Results 1 to 7 of 7

Thread: (RESOLVED) ADO - Whats wrong? pls have a look

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    May 2001
    Location
    Köln
    Posts
    395

    (RESOLVED) ADO - Whats wrong? pls have a look

    Greetings,

    What is wrong with the following code?

    Every time run it I get in the line

    an error message (see below)
    Code:
    Option Explicit
    
    ' The database connection.
    Private m_Conn As ADODB.Connection
    
    Private Const CONNECT_STRING  As String = "Provider=OraOLEDB.Oracle.1;Password=XXXX;Persist Security Info=True;User ID=XXXX;Data Source=XXXX"
    
    Public Function GetStatusSTR(ByVal vName As String, ByVal vPW As String) As Integer
    Dim rs As ADODB.Recordset
    Dim strSQL As String
        strSQL = "SELECT S.USER_Status FROM ST_USER_STATUS S, ST_USER_ACCESS A WHERE "
        strSQL = strSQL & "A.STATUS = S.USER_STATUS_ID AND A.USERNAME = '" & vName
        strSQL = strSQL & "' AND A.PASSWORD = '" & vPW & "';"
        Set rs = m_Conn.Execute(strSQL)
        If rs.RecordCount > 0 Then
            GetStatusSTR = rs(0)
        Else
            GetStatusSTR = 0
        End If
        rs.Close
        Set rs = Nothing
        Exit Function
    End Function
    
    Private Sub Class_Initialize()
        ' Open the database connection.
        Set m_Conn = New ADODB.Connection
        m_Conn.ConnectionString = CONNECT_STRING
        m_Conn.Open
    End Sub
    
    Private Sub Class_Terminate()
        m_Conn.Close
        Set m_Conn = Nothing
    End Sub
    The error message is
    RunTime Error "-2147217900 (80040e14)
    ORA-00911:

    strSQL containes the following value when Set rs = m_Conn.Execute(strSQL) is executing
    "SELECT S.USER_Status FROM ST_USER_STATUS S, ST_USER_ACCESS A WHERE A.STATUS = S.USER_STATUS_ID AND A.USERNAME = 'zzz13204' AND A.PASSWORD = 'admin';"

    Many thanks in advance
    Last edited by Bongo; Jul 31st, 2002 at 08:22 AM.

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