Re: ADO, MS Access and MS SQL Server 2000

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

Article #1586

Back to borland.public.cppbuilder.database.ado Previous Next

#1586

From: Simon Elliott
Date: Wed, 26 May 2004 10:51

23 lines
1870 bytes

On 26/05/2004, Viatcheslav V. Vassiliev wrote:

> > Silly question: How do I tell what authentication I'm using?
> 
> Connection string with Windows authentication:
> 
> Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=DbName;
> 
> Connection string with user name and password:
> 
> Provider=SQLOLEDB;User ID=sa;Password=XXX;Initial Catalog=DbName;
> 
> DbName is name of database. You may need to add "Data Source=XXX" if
> MSDE is not installed as default server. XXX is name of the server.
> 
> You can use TADOConnection and TADOQuery (or better, TADODataSet).
> You will need to create database with CREATE DATABASE statement. Does
> MSDE installs Books Online - help files? If so, all SQL is described
> there. If not - use MSDN, it contains help for MS SQL Server.

Excellent. Thanks for all your help!
-- 
Simon Elliott    http://www.ctsn.co.uk

Technical Details

Message-ID: <40b476bc$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<40b3af1d$1@newsgroups.borland.com> <40b43aaf@newsgroups.borland.com> <40b45285$1@newsgroups.borland.com> <40b46792@newsgroups.borland.com> <40b46a56@newsgroups.borland.com> <40b472ea@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,8abf2d740f25af17
X-Google-Attributes: gid10698b,public
From: "Simon Elliott" <Simon at ctsn.co.uk>
Subject: Re: ADO, MS Access and MS SQL Server 2000
Newsgroups: borland.public.cppbuilder.database.ado
Reply-To: "Simon Elliott" <News at ctsn.co.uk>
References: <40b3af1d$1@newsgroups.borland.com> <40b43aaf@newsgroups.borland.com> <40b45285$1@newsgroups.borland.com> <40b46792@newsgroups.borland.com> <40b46a56@newsgroups.borland.com> <40b472ea@newsgroups.borland.com>
User-Agent: XanaNews/1.16.3.1
NNTP-Posting-Host: 82.152.41.49
Message-ID: <40b476bc$1@newsgroups.borland.com>
Date: 26 May 2004 03:51:40 -0700
X-Trace: newsgroups.borland.com 1085568700 82.152.41.49 (26 May 2004 03:51:40 -0700)
Lines: 23
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message