SQL - Structured Query Language (.sql)

Connecting to SQLServer via IP
	Where: - xxx.xxx.xxx.xxx is an IP address - 1433 is the default port number for SQL Server. - "Network=DBMSSOCN" tells ODBC to use TCP/IP rather than Named Pipes (Q238949) For more information, see: SQLDriverConnect (ODBC)
	<% dim ConStr, dbConn,rs function getConnection() set dbConn = Server.CreateObject("ADODB.Connection") ConStr = "Driver={SQL Server}; SERVER=xxx.xxx.xxx.xxx; ADDRESS=xxx.xxx.xxx.xxx,1433; NETWORK=DBMSSOCN; UID=sa;PASSWORD=password; DATABASE=YourDatabase" dbConn.Open ConStr end function ' CloseConnectionFunction function closeConnection() if ucase(TypeName(dbConn)) = "CONNECTION" then dbConn.Close set dbConn = nothing end if end function ' Kill RecordSet function closeRecordSet(rs) 'rs.close set rs = nothing end function dim sql call getConnection() sql = "SELECT * FROM YourTable" set rs = dbConn.Execute(sql) do while not rs.EOF response.write rs("YourFieldName") & "<br>" rs.MoveNext Loop call closeRecordSet(rs) call closeConnection() %>
Go Back