SQL Database Connection Help

Hi there,

Could someone let me know what exactly the difference is between the following sql database connections please ) And when one each should be used...

Thank you


Connection A

set conex8 = Server.CreateObject("ADODB.Connection")

dns = "Driver={SQL Server};" & _
"Server=000.45.125.21;" & _
"Address=000.45.456.23,1434;" & _
"Network=DBMSSOSM;" & _
"Database=pl003;" & _
"Uid=pl003;" & _
"Pwd=test;"

conex8.Open dns


Connecion B

set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = "Driver={SQL Server};" & _
"Server=000.45.125.21;" & _
"Address=000.45.456.23,1434;" & _
"Network=DBMSSOSM;" & _
"Database=pl003;" & _
"Uid=pl003;" & _
"Pwd=test;

rs.CursorType = 1
rs.CursorLocation = 2
rs.LockType = 3


rs.Source = "SELECT * FROM Clients ORDER BY ID ASC"
rs.Open()

rs.MoveLast
advert = CInt(rs("ID")) + 1

rs.Close