Re: error: odbc in vista (with asp)
- From: OpenlinkEmma@xxxxxxxxx
- Date: Mon, 22 Oct 2007 19:18:02 -0000
On Oct 20, 11:47 am, Milto...@xxxxxxxxx wrote:
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?
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
.
- References:
- error: odbc in vista (with asp)
- From: MiltonPT
- error: odbc in vista (with asp)
- Prev by Date: important
- Next by Date: Relationship between odbc driver with .net data provider
- Previous by thread: error: odbc in vista (with asp)
- Next by thread: important
- Index(es):
Relevant Pages
|
Loading
