Web Development

Ask something
Discussion Locked

SQL Server Security in ADO Connection

0 helpful
5 replies

by munrrob

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am writing a site using ASP pages (VBScript, ADO 2.5) and would like to create a connection to a SQL Server 2k database that will use the users NT security to log in and give permissions.

How do I code this?

5 replies

by abc

Dim strConnect, Conn, Rs

strConnect = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=;Password=;Initial Catalog=;Data Source="

Set Conn = server.CreateObject("adodb.connection")
Conn.Open strConnect

Set Rs = server.CreateObject("adodb.recordset")

Rs.Open , Conn

Note: Ommit <> wherever you find in above connection string

by abc

Sorry, Disregard my previous answer.. this is the correct one.

Dim strConnect, Conn, Rs

strConnect = "Provider=SQLOLEDB.1;Persist Security Info=True;Trusted_Connection=yes;User ID=;Password=;Initial Catalog=;Data Source="

Set Conn = server.CreateObject("adodb.connection")
Conn.Open strConnect

Set Rs = server.CreateObject("adodb.recordset")

This discussion is closed to new replies.