Article View: borland.public.cppbuilder.database.ado
Article #4025Re: ADO Connection
From: Aris
Date: Sun, 21 Apr 2002 16:52
Date: Sun, 21 Apr 2002 16:52
39 lines
2191 bytes
2191 bytes
Many thanks for the suggestion. But I have done all these and it doesn't
work here is my code:
ADOConnection1->Connected = false;
ADOConnection1->LoginPrompt = false;
ADOConnection1->ConnectOptions = coConnectUnspecified;
ADOConnection1->ConnectionString = AnsiString("Provider=SQLOLEDB.1;
Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MyDatabase;
Data Source=RXC;");
ADOConnection1->DefaultDatabase= " MyDatabase";
ADOConnection1->Open();
ADOConnection1->Connected = true;
(RXC is the server name). The error message is by the SQL server indicating
that it cannot login to the database MYDatabase. I am doing everything by
the book. Where is the error?
"Aris" <ashokooh@centennialpr.net> wrote in message news:3cc228d0_2@dnews...
> I am having difficulty making run-time connection to MS SQL Server 7
> (SQLOLEDB.1 provider) using ADOConnectionString in BCB5. I need concrete
> help: C++ statements showing clearly how to do it. Will appreciate it
> greatly.
>
> Aris
>
>
Technical Details
Message-ID:
<3cc2ed68$1_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!207.217.77.43.MISMATCH!newsfeed1.earthlink.net!newsfeed.earthlink.net!news-hog.berkeley.edu!ucberkeley!logbridge.uoregon.edu!sfo2-feed1.news.algx.net!allegiance!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3cc228d0_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,f7dc40439631c1c0 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-04-21 10:01:29 PST From: "Aris" <ashokooh@centennialpr.net> Newsgroups: borland.public.cppbuilder.database.ado References: <3cc228d0_2@dnews> Subject: Re: ADO Connection Date: Sun, 21 Apr 2002 12:52:37 -0400 Lines: 41 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 64.213.238.113 Message-ID: <3cc2ed68$1_2@dnews> X-Trace: dnews 1019407720 64.213.238.113 (21 Apr 2002 09:48:40 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!207.217.77.43.MISMATCH!newsfeed1.earthlink.net!newsfeed.earthlink.net!news-hog.berkeley.edu!ucberkeley!logbridge.uoregon.edu!sfo2-feed1.news.algx.net!allegiance!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews