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?
On Oct 20, 11:47 am, Milto...@gmail.com 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
