Clarification in COM

  • Thread starter Thread starter Carify Me
  • Start date Start date
C

Carify Me

Hi

I am new for developing component. Please advise me for the following
problem.

I have created the component (DLL) for opening dbconnection Using Oracle,
using the below statement to use the connection in my application.

--------------------------Standard EXE--------------------

Private oDB As My_Database_Connections.DBConn
Private adoConn As ADODB.Connection

If oDB.OpenDBConnection("ADMIN", "ADMIN") = 0 Then
Set adoConn = New ADODB.Connection
Set adoConn = oDB.mcnIBEW
MsgBox "Connection Established Successfully"
Else
MsgBox "Connection not Established"
End If

'I have another component (DLL) for checking some value in Database. I have
to use the same connection for that. Below coding is written also it is
working.

'In the below lines of coding, I am assigning the db connection adoConn to
the component (DLL)

Private Sub Command1_Click()
Dim sPatValue as String
Set myComVali = New My_General_Validations.Validations
Set myComVali.adoValidConn = adoConn

sPatValue = myComVali.FindDataAvailable("M", "Patient_Relation", "CODE")

End Sub
-----------------------------------------------------------------

for the above code I have declared 3 connection object.
1. Standard application Privatr adoConn
2. DBConnection (DLL) Public mcnIBEW
3. Validation logic (DLL) Public adoValidConn

----------------------------------------------------------------------

Every thing is working.

But I think this is not right way to do this,

Please advise me how to do this in better way.

Thanks & Regards

Balaji N
 
Hi Carify,

Have a look in the newsgroup that I pointed you on, there are a lot of
questions about Oracle answered there by Miha. (The one who knows the most
form it in my opinion).

Oracle has special things (errors that happens, which he knows the best from
the ones in this dotnet newgroup in my opinion, or gives the most answers).

Cor
 
Just to correct this terrible sentence
">
What I have seen is the one who knows the much from this problems related to
Oracle in this newsgroups Miha.
Click to expand...
As for what I have seen is the one who knows the most from problems related
to newsgroups Miha active in the newsgroup.

............................
 
Hi Mr. Cor,

Thanks for the reply with solution.

My question is, Is the methodology is correct or can I do in any other
simple and best way.

Thanks

Balaji
 
Hi Herfried,

Thanks I have looked at it, but I have already the latest.

This happens when I copy the link from a textfile, what I did in this case.

By the way I looked to that newsgroup US where you was talked about
yesterday.

This is even worse than those anouncements from chats in this newsgroups
where they tell there is a time table referencing to the GMT time, but do
not tell at what GMT time it start.

:-)

Cor
 
* "Cor said:
Thanks I have looked at it, but I have already the latest.
OK.

This happens when I copy the link from a textfile, what I did in this case.
:-)))

By the way I looked to that newsgroup US where you was talked about
yesterday.
Click to expand...

The .NET Compact Framework group?
 
The .NET Compact Framework group?
Click to expand...

No all the groups, when you live in Canada, I thought that there is only a
Xbox group now that you can visit if you look at that webpage.

Did you examine it?

Cor
 
* "Cor said:
No all the groups, when you live in Canada, I thought that there is only a
Xbox group now that you can visit if you look at that webpage.

Did you examine it?
Click to expand...

Mhm... Currently I am not able to reach the site at all because
Microsoft's servers are blocking requests from my ISP.
 
Back
Top