error: odbc in vista (with asp)

error: odbc in vista (with asp)

Post by MiltonP » Mon, 22 Oct 2007 00:47:28


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?
 
 
 

error: odbc in vista (with asp)

Post by OpenlinkEm » Wed, 24 Oct 2007 04:18:02


Hello,

Is this problem specific to the vista operating system?
Is sqlserver configured to accept tcp connections?
Have you verified the sqlserver tcp listening port?
Is this a local or remote connection?
Are there firewalls around your sqlserver box?
On the server -- use a combination of "netstat -ano|findstr <port>"
and the sqlserver error log to check that sqlserver is listening on
the port that you think it is .
On the client -- try "telnet <serverip><sqlserver port>" and see if
this works


Best Regards