Connecting to SQL server

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

Article #169

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

#169

From: Paul Mayer
Date: Mon, 10 Oct 2005 14:56

13 lines
1560 bytes

Hi

I have been trying to do a simple thing, following an example from dr bob,
to connect a dbwebgrid to an sql database. Should be simple. It all works
nicely at design time with all the data showing fine. But at run time i get
this error message :
Connection open failed. SQL State: 42000, SQL Error Code: 18456 

Now, I have set all the properties ok through the bdpconnection - all set
to os authentication. Thats all fine. So what I wonder is going wrong. 

Any help much appreciated or it goodbye delphi and hello my old friend
coldfusion

Technical Details

Message-ID: <dd0lx4fopnrx$.1ugdgeik95x0c$.dlg@40tude.net>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!meganewsservers.com!feeder2.on.meganewsservers.com!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,10f2e27d7bfc12a6,start
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Paul Mayer <p_c_mayer@yahoo.com>
Subject: 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
Date: Mon, 10 Oct 2005 15:56:32 +0100
Message-ID: <dd0lx4fopnrx$.1ugdgeik95x0c$.dlg@40tude.net>
NNTP-Posting-Host: 86.135.182.128
X-Trace: newsgroups.borland.com 1128956041 86.135.182.128 (10 Oct 2005 07:54:01 -0700)
Lines: 13
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!meganewsservers.com!feeder2.on.meganewsservers.com!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail