Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  From Access to SQL

Author  Topic  znwpta Starting Member 12 Posts Posted - 2008-07-10 : 13:16:05 Question. I am currently workign on upgrading from Access to SQL. Right now in every ASP I have in my application, I have code like set cnERP=server.createobject("ADODB.Connection") cnERP.open "DSN=BLAHBLAH" set rsCustomers=server.createobject("ADODB.Recordset") rsCustomers.open "Select * from BLAHWHERE ID=" & SelCustomer, cnERP, adOpenDynamic, adLockReadOnly, adCmdText I am planning on making a 2 step transition into SQL. The first would be Upsizing the DB to SQL, and hopingfully reusing all my old code by using a new DSN to the SQL Server. Then the second would be creating Stored Procedures that would reaplce my old code slowly. Is this a viable approach? Andre