Re: Connecting to SQL server

Article View: borland.public.delphi.database.dotnet

Article #176

Back to borland.public.delphi.database.dotnet Previous Next

#176

From: Paul Mayer
Date: Thu, 13 Oct 2005 14:45

30 lines
1881 bytes

On Wed, 12 Oct 2005 08:02:37 +0200, Bob Swart wrote:

> 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)



Hi Bob

I have figured out the problem and its silly really. Should kick myself. I
didnt realise that sql server needed to have an ASPNET login account. Makes
all the difference. Still dont know why it was happy at design time though.

Cheers

Paul

Technical Details

Message-ID: <1ua8kve4bwgv2$.ziy19y0q7y1g$.dlg@40tude.net>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!fr.ip.ndsoftware.net!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <dd0lx4fopnrx$.1ugdgeik95x0c$.dlg@40tude.net> <434CA6FD.2102F2E0@chello.nl>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,10f2e27d7bfc12a6
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Paul Mayer <p_c_mayer@yahoo.com>
Subject: Re: Connecting to SQL server
Newsgroups: borland.public.delphi.database.dotnet
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Sender: Paul Mayer <>
Reply-To: p_c_mayer@yahoo.com
Organization: PM Software
References: <dd0lx4fopnrx$.1ugdgeik95x0c$.dlg@40tude.net> <434CA6FD.2102F2E0@chello.nl>
Date: Thu, 13 Oct 2005 15:45:25 +0100
Message-ID: <1ua8kve4bwgv2$.ziy19y0q7y1g$.dlg@40tude.net>
NNTP-Posting-Host: 86.135.176.133
X-Trace: newsgroups.borland.com 1129214570 86.135.176.133 (13 Oct 2005 07:42:50 -0700)
Lines: 30
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!fr.ip.ndsoftware.net!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message