Checking status of DLL in Com Object
-
Hello All, :rolleyes: I wrote a com object to suck all the information and process in the dll including submission into database. My code is: Dim myobj As New clsMyObj with myobj .name = CStr(FirstName) and so on .ConnectionString = strConnection .mySubmission end with mySubmission calls the function and submit to the database. What I gathered is that my dll is breaking because of the difference of the datatype. My question is any way I can check the status of the myobj if the data process is not been submit? If yes How? I can check the database state by : Dim myconnection, stat myconnection = As New ADODB.Connection If myconnection .State Then stat = true else stat = false end if Any thoughts please?? Most greatful. :-D Bravo Two Zero A pen is mighter then a sword.