Recent

« previous next »
Pages: [1]

Author Topic: MS SQL Connection Bug?  (Read 2047 times)

kpeters58

  • Sr. Member
  • ****
  • Posts: 267
MS SQL Connection Bug?
« on: December 18, 2014, 10:15:16 pm »
#1.2.6  32bit on Win 7 Prof:

I get immediate access when I should not...

Setting the LoginPrompt property of MSSQLConnection to True fails to invoke the login dialog - instead my SQL Servers grant me access based on ??? since both UserName & Password fields at design time are empty.

Anybody knows why?

Thanks,
Kai
Logged
Lazarus 2.0.4/FPC 3.0.4/Win 64

LacaK

  • Hero Member
  • *****
  • Posts: 696
Re: MS SQL Connection Bug?
« Reply #1 on: December 19, 2014, 08:48:39 am »
In current implementation LoginPrompt only chacks if there is set OnLogin event handler and if is set, that invokes it.

Probably you have enabled trusted authentication, so SQL server authenticated you as user currently  logged in Windows.
Logged

kpeters58

  • Sr. Member
  • ****
  • Posts: 267
Re: MS SQL Connection Bug?
« Reply #2 on: December 19, 2014, 05:41:18 pm »
Hmm - I tried that - still no login dialog; whether I supply (in OnLogin event) no username & password, a correct username & password or deliberately incorrect username & password ......

K
« Last Edit: December 19, 2014, 05:58:38 pm by kpeters58 »
Logged
Lazarus 2.0.4/FPC 3.0.4/Win 64
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018