General discussion


VB6 to SQL Server Connection ( Windows Authentication mode)

By kavithaee ·
I would like to connect to SQLServer2000 from VB6 ,my SQLServer is using Windows Authentication mode , can any body tell me how to establish a connection

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Instead of putting

by Tony Hopkinson In reply to VB6 to SQL Server Connect ...

user and password in.

Put "Persist Security Info=False; Integrated Security = SSPI"
aLong with the usual "Data Source=MyServer; Initial Catalog=MyDatabase"

Course the account that is running the program has to have access to the data base.

You dio that from Enterprise Manaager by adding a Logon and mapping it to a database user in each database that the program requires access to.

Related Discussions

Related Forums