Connect String to test ASP and MSSQL

by RameshKumar 2008-09-16 17:01:43

<%
DIM strDataSourceName, objConn

Set objConn = Server.CreateObject("ADODB.Connection")

strDataSourceName="Provider=sqloledb;Data Source=YOURDATABASESERVER;Initial Catalog=DBNAME;User Id=USERNAME;Password= YOUR PASSWORD;"

objConn.connectionstring = strDataSourceName
objConn.Open

%>

Tagged in:

2716
like
0
dislike
0
mail
flag

You must LOGIN to add comments