Article View: borland.public.delphi.database.dotnet
Article #172Re: Connecting to SQL server
From: Bob Swart
Date: Wed, 12 Oct 2005 06:02
Date: Wed, 12 Oct 2005 06:02
20 lines
1718 bytes
1718 bytes
Hi Paul,
> Now, I have set all the properties ok through the bdpconnection - all set
> to os authentication.
You cannot use OS Authentication with SQL Server in ASP.NET. You need to
supply a username and password to get access to the database.
> Any help much appreciated or it goodbye delphi and hello my old friend
> coldfusion
This is actually a SQL Server issue, so unless coldfusion uses it's own
database engine, you will have the same issue there ;-)
Groetjes,
Bob Swart (aka Dr.Bob - www.DrBob42.com)
--
Bob Swart Training & Consultancy (eBob42) - Borland Technology Partner
Delphi 2005 PDF manuals available from http://www.drbob42.com/training
Technical Details
Message-ID:
<434CA6FD.2102F2E0@chello.nl>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!colt.net!nntp.theplanet.net!inewsm1.nntp.theplanet.net!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<dd0lx4fopnrx$.1ugdgeik95x0c$.dlg@40tude.net>Show Full Headers
Complete Article Headers
X-Google-Thread: 1effe6,10f2e27d7bfc12a6 X-Google-Attributes: gid1effe6,public X-Google-Language: ENGLISH,ASCII-7-bit Message-ID: <434CA6FD.2102F2E0@chello.nl> Date: Wed, 12 Oct 2005 08:02:37 +0200 From: Bob Swart <b.swart@chello.nl> Organization: Bob Swart Training & Consultancy X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: borland.public.delphi.database.dotnet Subject: Re: Connecting to SQL server References: <dd0lx4fopnrx$.1ugdgeik95x0c$.dlg@40tude.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 62.108.13.72 X-Trace: newsgroups.borland.com 1129096748 62.108.13.72 (11 Oct 2005 22:59:08 -0700) Lines: 20 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!colt.net!nntp.theplanet.net!inewsm1.nntp.theplanet.net!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail