E
Empire City
Set Conn = Server.CreateObject( "ADODB.Connection" )
Conn.Open( "DSN = mydsn; UID = myuserid; PWD = mypassword;" )
sql = "select * from customers"
Set RS = Conn.Execute( sql )
Preferably with a SqlDataAdapter not an OleDbDataAdapter
Conn.Open( "DSN = mydsn; UID = myuserid; PWD = mypassword;" )
sql = "select * from customers"
Set RS = Conn.Execute( sql )
Preferably with a SqlDataAdapter not an OleDbDataAdapter