classic asp to sql 2014 connection string

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I migrated to sql 2016 and it seems the connection is doing well, only i get no data back from the database. Here's my test script <code>

<%
Dim objConn
Dim strSQL
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT top 10 * FROM factuur"
objConn.Open "Provider=SQLOLEDB;Data Source=MYSERVER;User ID=sql_user;Password=password;Database=DBNAME;"
If objConn.errors.count = 0 Then
	Response.Write "Connected OK"
else 
	Response.Write "Connected NOT OK"
End If

objRS.Open objRS, objConn

If Not objRS.EOF Then
	Response.Write objRS.RecordCount
Else
	response.write "niks" 
End If
objRS.close
Set objRS=Nothing
objConn.close
Set objConn=Nothing
%>

</code>

then i get the message that my connection is ok, but i see no record count: Connected OKAn error occurred on the server when processing the URL. Please contact the system administrator. 
If you are the system administrator please click here to find out more about this error.

Am i missing something here?