🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: ADO Connection

#4025
From: Aris
Date: Sun, 21 Apr 2002 16:52
39 lines
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!dnews
References: <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