Integrated login to MSSQL using BDE

[Nordlund]

Hi there.

I'm trying to log on to a MSSQL Server with BDE using Integrated login.

Is there a way to do that, or is this only possible with ADO?




//Nordlund

 

[svanels]

Integrated login? what do you mean?
Whit the BDE the logical step would be to use a TDatabase, and to connect your tables, queries, stored procedures etc to the Tdatabase. Login would be handled by the TDatabase only 1 time.

Steven van Els
SAvanEls@cq-link.sr

 

[VintageWine]

Agree with Steven, use TDatabase in all situations. In it you can specify login parameters.

Also you can set up SQL Server to accept the NT Login. Anyone who is logged into the NT domain is accepted without further password entry into SQL Server.

 

[Nordlund]

Ok. I solved it.

Assume the MS SQL server is added into the AD.

then connect to the server with a TDatabase component, and remove the Username and Password.

Note: You have to remove it in the default settings in the "BDE administrator" tool as well (In the drivers\native\mssql part)

__ A star to myself __


//Nordlund