Unable to connect SQL server 2012 through classic ASP

See more:

VBScript

SQL-Server

OleDb

Hi,

I am using the following code to connect SQL server 2012 DB using classic asp.

<%
	On error Resume Next
	Dim connectionstring1, connectionstring2
	Dim cn,cmd, rs 	
	
	connectionstring1 = "Provider=sqloledb;Data Source=KALPESH;Integrated Security=SSPI;Initial Catalog=Practice"
	connectionstring2 = "Provider=SQLNCLI11;Data Source=KALPESH;Integrated Security=SSPI;Initial Catalog=Practice"
	
	Set cn = Server.CreateObject("ADODB.Connection")
	Set cmd = Server.CreateObject("ADODB.Command")
	Set rs = Server.CreateObject("ADODB.Recordset")
	
	cn.ConnectionTimeout = 90
	cmd.CommandTimeout = 180
	query = "Select * from Users"
		
	cn.ConnectionString = connectinstring1  
	response.write  "<br>OLEDB connection : " & cn.ConnectionString 
	
	cn.Open
	cmd.ActiveConnection = cn
	cmd.CommandText = query
	Set rs = cmd.Execute
	
	If Err.number > 0 Then
		Response.Write("<br>" & Err.Number & "  - " & Err.Description)
		cn.close
	End If
	
	cn.ConnectionString = connectinstring2
	
	cn.Open
	cmd.ActiveConnection = cn
	cmd.CommandText = query
	Set rs = cmd.Execute

	If Err.number > 0 Then
		Response.Write("<br>" & Err.Number & "  - " & Err.Description)
		cn.close
	End If	
%>

I am receiving following errors with both the cases.
Output :

3709 - The connection cannot be used to perform this operation. It is either closed or invalid in this context.
3709 - The connection cannot be used to perform this operation. It is either closed or invalid in this context.

However, I am able to connect from excel - VBA to SQL server 2012 using following connectionstring.

objMyConn.ConnectionString = "Provider=sqloledb;Data Source=KALPESH;Integrated Security=SSPI;Initial Catalog=Practice"

I've searched the internet and checked my code against other examples. I am not sure why I am getting this error message. Any help would be greatly appreciated.