error: odbc in vista (with asp)
- From: MiltonPT@xxxxxxxxx
- Date: Sat, 20 Oct 2007 08:48:20 -0700
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?
.
- Prev by Date: error: odbc in vista (with asp)
- Next by Date: SQL Server conection with AttachDBFilename
- Previous by thread: error: odbc in vista (with asp)
- Next by thread: SQL Server conection with AttachDBFilename
- Index(es):
Relevant Pages
|
Loading
