DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    45

    Invalid proc call or argument : Urgent

    Invalid proc call or argument : Urgent
    Hi
    My Project consisits of 3 layers prjAL,prjBL and prjDL. These 3 are implemented as DLL.
    prjDL is taking care of DB connectivity.

    When db server is stopeed it throws run time error :
    Dl method raises err to BL. here err no is 10303.
    Now BL throws it to AL for handling . But here it is coming as error number 5(invalid proc call or argument)

    Code line in AL:
    Set m_objBLT = CreateObject("prjBL.clsT")

    Code line in BL where the err appears:
    m_dalT.Intialize Provider=MSDASQL.1;Data Source=xx;User ID=xx;Pwd=xx;

    Definition in DL:
    Public Sub Intialize(ByVal ConnectionString As String)
    On Error GoTo errHandler
    Dim Errs1 As ADODB.Errors


    If m_bInitialize = False Then

    Set m_Conn = New Connection

    With m_Conn
    .ConnectionString = ConnectionString
    .CursorLocation = adUseClient
    .CommandTimeout = 0
    .Open
    End With

    Set m_rsRecords = New Recordset
    With m_rsRecords
    .CursorLocation = adUseClient
    .CursorType = adOpenKeyset
    End With
    m_bInitialize = True
    Else
    Err.Raise STR_ERR_OBJ_INIT_FAIL, CLS_NAME, LoadResString(STR_ERR_OBJ_INIT_FAIL), , STR_ERR_OBJ_INIT_FAIL
    End If
    Exit Sub
    errHandler:
    Dim errLoop As Error
    Set Errs1 = m_Conn.Errors
    If Errs1.Count > 0 Then
    For Each errLoop In Errs1
    objErrInfoDgb.TraceMsg errLoop.SQLState & ": " & errLoop.Description
    Next
    SQLStateErrorHandler Errs1.Item(0).SQLState, Errs1.Item(0).Source
    Else
    Err.Raise Err.Number, Err.Source, Err.Description, , Err.HelpContext
    End If
    End Sub


    Can anybody tell me the reason behind this? ANd how to handle it?

    Thks
    Vidhi

  2. #2
    Join Date
    Dec 2005
    Posts
    92
    Vidhi,what kind of an object is "m_dalT" & how is the Intialize property associated with it?You must declare m_dalT.

Similar Threads

  1. Learning Help
    By Carlos in forum Java
    Replies: 3
    Last Post: 07-31-2005, 05:17 PM
  2. how to call ProC or C exe file from Java program
    By n_yerramaneni in forum Java
    Replies: 1
    Last Post: 04-05-2005, 10:24 AM
  3. Replies: 0
    Last Post: 08-23-2001, 07:24 PM
  4. NetUserEnum Api
    By Mike in forum VB Classic
    Replies: 2
    Last Post: 04-24-2000, 03:30 PM
  5. NetUserEnum Api
    By Mike in forum VB Classic
    Replies: 0
    Last Post: 04-24-2000, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links