Hi,<BR><BR>I have come across various ways in which to access my SQL Server 7.0 database. <BR><BR>1 DSN<BR>2 UDL (Microsoft Data Link)<BR>3 Provider<BR><BR>Which one is the fastest way to access my database? <BR><BR>I am using SP (Stored Procedure) and again there are different ways of accessing my SP.<BR><BR>1 connect1.Execute "Select_details" -- Select_details is my SP with parameters.<BR>2 rs.open "exec Select_details",connect1,adOpenStatic<BR>3 Using DE (MS Visual Interdev DataEnvironment Component)<BR><BR>Which one should be used and in which situations. Why there are so many methods available when we can directly use the SP as in case 1.<BR><BR>Please reply on mpt@bom7.vsnl.net.in <BR><BR>Thanks & Regards<BR><BR>Melvyn P. Taraporewalla<BR><BR>