error: odbc in vista (with asp)

error: odbc in vista (with asp)

Post by MiltonP » Mon, 22 Oct 2007 00:48:20


i dont connect db (sql server 2005) in vista. why?
i have a cod in asp and no conect database.

the error is:

"Microsoft SQL Native Client Version 09.00.3042

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]TCP Provider: No connection could be
made because the target machine actively refused it.

[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing
a connection to the server. When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections.

TESTS FAILED!"

The code asp:

<%@ Language=JScript %>
<html><head><title>....</title></head><body>
<%
var CS = Data Source=FONTEZ-AF96F4F1\SQLEXPRESS;Initial
Catalog=mydb_2;Integrated Security=True;
var myConnection = Server.CreateObject("ADODB.Connection");
myConnection.open(CS);

myRecordSet = myConnection.Execute("select * from aluno");
%>
<table border="1">
<%
while(!myRecordSet.eof){ %>
<tr><%
for(Index=0; Index < (myRecordSet.fields.count); Index++) {
%> <td> <%= myRecordSet(Index) %> </td><%
}
myRecordSet.MoveNext();
%>
</tr><%
}

myRecordSet.Close();
myConnection.Close();
%>
</table>

</body></html>

the problems? where?