da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: MSSQL login

Forum List » AnyDAC » v 1.x General English

zapata
User

Fresh Boarder

Posts: 7

Karma: 0

MSSQL login

Posted: 2008/01/31 07:18

Hi Diman!

I wish to use a custom login form to connect mssql servers in my firm. How can I detect server name and database name, and how can i set authentication method?

thx in andvance

Diman

Admin

Posts: 1461

Karma: 18

Re:MSSQL login

Posted: 2008/01/31 07:35

Hello

Why dont just use TADGUIxFormsLoginDialog ? Drop it on the form and set TADConnection.LoginDialog to the dropped component.

Regards,
Dmitry

zapata
User

Fresh Boarder

Posts: 7

Karma: 0

Re:MSSQL login

Posted: 2008/01/31 11:34

Hi Diman!

Because my users are cubic headed. They can't remember anything and they wish to uses accustomed forms.

Regards

Diman

Admin

Posts: 1461

Karma: 18

Re:MSSQL login

Posted: 2008/02/01 02:03

1) See daADPhysMSSQL unit, EnumerateServers function for details of how to get server list. Similar code may be used to get database list.
2) Set OSAuthen=Yes to use win authentification, and set to No or just avoid parameter to use DBMS authentification.

zapata
User

Fresh Boarder

Posts: 7

Karma: 0

Re:MSSQL login

Posted: 2008/02/01 10:29

Thx Diman!

I will try it.

Regards Zapata

Forum List » AnyDAC » v 1.x General English