Tuesday, March 17, 2009

SQL Server Database connection source code in classic ASP

Connection Code

Dim strConnection,objConn
Set objConn = Server.CreateObject("ADODB.Connection")


strConnection ="Provider=SQLOLEDB;Data Source=671.151.47.212; Database=DBNews; uid=sample;pwd=sample@123;"
objConn.open strConnection

End Connection Code

No comments: