🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #5097

Re: ADO connect..!?

#5097
From: Henrik Franz�n
Date: Wed, 11 Jul 2001 08:12
71 lines
2878 bytes
TADOConnection *MainConnection;
TADOTable *XMLRecordHolder;
TADOQuery *Query_XMLLoader;
TQuery *Query_Updater;

I ADOQuery don't seem to support ParamByName().. .. or SQL server conflicts
with ADOQuery's Parameters.. hum I dono whats wrong. i just want it to
work.. ..
'


Formentz <francesco@leotron.com> wrote in message news:3b4c04ea_2@dnews...
> What is Query_Updater which you assign DatabaseName?
> A BDE TQuery? Why don't you use TADOQuery?
>
> Ciao
>     Formentz
> "Henrik Franz�n" <xhfr@wayne.se> ha scritto nel messaggio
> news:3b4bf906$1_2@dnews...
> > Hi!
> > I have one class called DBHandler. In this class i have three ADO
objects.
> I
> > also have a frame. There is one button in this frame. I got some strange
> > exception when pressing this button.. I should call a function in my
> > DBHandler called ConnectTo(AnsiString Database), and connect to a
> database,
> > whats the problem ??
> >
> > .. here is my code. :
> >
> > void __fastcall TForm1::Button3Click(TObject *Sender)
> > {
> >     DBHandler->ConnectTo("nucleusdb");
> > }
> >
> >
> > bool __fastcall TDBaseHandler::ConnectTo(AnsiString Database)
> > {
> >     try{
> >         FDatabase = Database;
> >
> >         AnsiString Def("Provider=MSDASQL.1;Persist Security
> Info=False;Data
> > Source=");
> >         AnsiString ConnectionString(Def + FDatabase);
> >
> >         MainConnection->ConnectionString = WideString(ConnectionString);
> >         MainConnection->Open();
> >         Query_Updater->DatabaseName = FDatabase;
> >         Query_Updater->OpenDatabase();
> >         XMLRecordHolder->Connection = MainConnection;
> >         Query_XMLLoader->Connection = MainConnection;
> >         return true;
> >
> >     }catch(Exception &E)
> >     {
> >         return false;
> >     }
> >
> > }
> >
> >
> >
> > I hope someone can help me!
> >
> > /wr Henrik Franz�n
> >
> >
>
>
Technical Details
Message-ID: <3b4c0a6b_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews
References: <3b4bf906$1_2@dnews> <3b4c04ea_2@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,411507ca9a8fef65
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-07-11 01:18:45 PST
Reply-To: "Henrik Franz�n" <xhfr@wayne.se>
From: "Henrik Franz�n" <xhfr@wayne.se>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3b4bf906$1_2@dnews> <3b4c04ea_2@dnews>
Subject: Re: ADO connect..!?
Date: Wed, 11 Jul 2001 10:12:28 +0200
Lines: 73
Organization: Dresser Wayne
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 193.15.214.81
Message-ID: <3b4c0a6b_1@dnews>
X-Trace: dnews 994839147 193.15.214.81 (11 Jul 2001 01:12:27 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews