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 9 1083
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 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" <no*@non.com> wrote in message
news:up****************@TK2MSFTNGP12.phx.gbl... 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" <ba*****@2hps.com> schreef in bericht
news:er******************@tk2msftngp13.phx.gbl... 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" <no*@non.com> wrote in message news:up****************@TK2MSFTNGP12.phx.gbl... 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.
............................
Cor,
* "Cor" <no*@non.com> 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" <no*@non.com> 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" <no*@non.com> 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> This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Wes |
last post by:
I am trying to secure different files, mostly pdf, so only the person
suppose to see the file that was designed for that individual can see it. I
am using sessions to secure the actual web pages,...
|
by: Shea Martin |
last post by:
Which of the following do I use delete instead of just delete.
//1.)
// not sure about this one, as char is of size 1
char *str = new char;
//2.)
//not sure about this one, as it is a...
|
by: John D. Sanders |
last post by:
I have just upgraded MySQL from version 3.23 to version 4.1.8 and now I
am getting the following error when I try to run a script that worked:
install_driver(mysql) failed: Can't load...
|
by: Ethan |
last post by:
This is a clarification of a previous message, which was not expressed
very well. I have a set of checkboxes near the bottom of the page and
a function that checks or unchecks all of them. But when...
|
by: Adam |
last post by:
Hi,
I am having problems having an include file rendered in my browser
(IE6).
The include file contains <A href> tags to be used as a navigation bar
in the footer of a .html file.
I am...
|
by: ma740988 |
last post by:
Consider the 'C' source.
void myDoorBellISR(starLinkDevice *slDevice, U32 doorBellVal)
{
doorBellDetected = doorBellVal;
}
void slRcv()
{
starLinkOpenStruct myOpenStruct;
|
by: solomon_13000 |
last post by:
> Wonthaggi Civic Theatre 'WCT' Case Study
>
> The town of Wonthaggi has a theatre which is owned and
> operated by the local council, it is called the
> Wonthaggi Civic Theatre (WCT) and a wide...
|
by: chanchito_cojones |
last post by:
Hi there,
I was searching the net for some guidance in putting together a query that
would select random records from the main table. I came across this and it
works like a charm.
SELECT TOP...
|
by: Sai Kit Tong |
last post by:
In the article, the description for
"Modiy DLL That Contains Consumers That Use Managed Code and DLL Exports
or
Managed Entry Points"
suggests the creation of the class ManagedWrapper.
If I...
|
by: ravir |
last post by:
Hi,
I am new to this group. I am working in Perl and shellscripts.
I have a clarification regarding perl grep and pattern matching.
I am writing a perl script to automate the process of code...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |