Change ASP Connection String Access to SQL

[dglienna]

Changing a connection string on Web Site.

They were using an Access connection to connect, and I want to substitute the SQL Server connection string. Just wanted to make sure I do it right.

This is the Acces Connection that I have:

Dim cn 
Set cn=server.createobject("adodb.connection")
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\") & "\data\kallenrs.mdb;"
cn.open

This is the SQL Connection that I want for LOCAL testing, and I can change that later:

Driver={SQL Server Native Client 10.0};Server=.\SQLEXPRESS; Database=tracking2010;Trusted_Connection=yes;

I'll use "Select fID as FileNumber, x as a, y as b, z as c" to keep the naming convention the same.

Thanks!