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?