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,

2 answers, you are using adodb, while in dotnet the oracle provider can be
used or the Oledb.
(The oracle is prefered I thought)

What I have seen is the one who knows the much from this problems related to
Oracle in this newsgroups Miha.

He is very active in the newsgroup

Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>


I hope this helps a little bit?

Cor

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

"Carify Me" <(E-Mail Removed)> schreef in bericht
news:er2%23AZG%(E-Mail Removed)...
> 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
>
>
> "Cor" <(E-Mail Removed)> wrote in message
> news:upsX62F%(E-Mail Removed)...
> > Hi Carify,
> >
> > 2 answers, you are using adodb, while in dotnet the oracle provider can
be
> > used or the Oledb.
> > (The oracle is prefered I thought)
> >
> > What I have seen is the one who knows the much from this problems
related
> to
> > Oracle in this newsgroups Miha.
> >
> > He is very active in the newsgroup
> >
> > Adonet
> > <news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>
> >
> > Web interface:
> >
> >
>
<http://communities2.microsoft.com/co...s/?dg=microsof
> > t.public.dotnet.framework.adonet>
> >
> >
> > I hope this helps a little bit?
> >
> > 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.
>
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


"Cor" <(E-Mail Removed)> wrote in message
news:upsX62F%(E-Mail Removed)...
> Hi Carify,
>
> 2 answers, you are using adodb, while in dotnet the oracle provider can be
> used or the Oledb.
> (The oracle is prefered I thought)
>
> What I have seen is the one who knows the much from this problems related
to
> Oracle in this newsgroups Miha.
>
> He is very active in the newsgroup
>
> Adonet
> <news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>
>
> Web interface:
>
>
<http://communities2.microsoft.com/co...s/?dg=microsof
> t.public.dotnet.framework.adonet>
>
>
> I hope this helps a little bit?
>
> Cor
>
>

Cor,

* "Cor" <(E-Mail Removed)> scripsit:
> <http://communities2.microsoft.com/co...s/?dg=microsof
> t.public.dotnet.framework.adonet>

Just a thought: Why not install the mondo patch which will prevent OE
from breaking long links?

OLEXP: An Overview of the Cumulative Update for Outlook Express 6.0 SP1
<http://support.microsoft.com/?scid=kb;EN-US;q331923>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

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" <(E-Mail Removed)> scripsit:
> 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.

The .NET Compact Framework group?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

>
> The .NET Compact Framework group?

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" <(E-Mail Removed)> scripsit:
>> The .NET Compact Framework group?
>
> 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?

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

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>