Recent

Author Topic: MS SQL Connection Bug?  (Read 1895 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
Lazarus 2.0.4/FPC 3.0.4/Win 64

LacaK

  • Hero Member
  • *****
  • Posts: 691
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.

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 »
Lazarus 2.0.4/FPC 3.0.4/Win 64

 

TinyPortal © 2005-2018