🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Problems! :((

#5098
From: Henrik Franz�n
Date: Wed, 11 Jul 2001 09:10
55 lines
2357 bytes
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;
    }

}

dec.

TADOConnection *MainConnection;
TADOTable *XMLRecordHolder;
TADOQuery *Query_XMLLoader;
TQuery *Query_Updater;

A 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.. ..
'


I hope someone can help me!

/wr Henrik Franz�n
Technical Details
Message-ID: <3b4c1818$1_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!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,680b5d3503692f29,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-07-11 02:12:16 PST
Reply-To: "Henrik Franz�n" <xhfr@wayne.se>
From: "Henrik Franz�n" <xhfr@wayne.se>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problems! :((
Date: Wed, 11 Jul 2001 11:10:50 +0200
Lines: 57
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: <3b4c1818$1_1@dnews>
X-Trace: dnews 994842648 193.15.214.81 (11 Jul 2001 02:10:48 -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!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews