Migrating ASP.NET 2.0 with Access to SQL Server.

[rnooraei]

Hi
I have a small application which has been built with ASP.NET 2.0 and Access database. Now I want to move this application to SQL Server, Should I rebuilt the datasource with SQL Server? I did change the connection string but didn't work for me. any help appreciated.

here the sample of my compiler error message

Me._commandCollection = New System.Data.SqlClient.SqlCommand(3) {}
Me._commandCollection(0) = New System.Data.SqlClient.SqlCommand
Me._commandCollection(0).Connection = Me.Connection
Me._commandCollection(0).CommandText = "SELECT tblDeptDivSects.*"&Global.Microsoft.VisualBasic.ChrW(13)&Global.Microsoft.VisualBasic.ChrW(10)&"FROM tblDeptDivSects"
Me._commandCollection(0).CommandType = System.Data.CommandType.Text
Me._commandCollection(1) = New System.Data.OleDb.OleDbCommand
Me._commandCollection(1).Connection = New System.Data.OleDb.OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("BarConnectionString").ConnectionString)


Thanks

 

[Kalisto]

    Me._commandCollection(1) = New System.Data.OleDb.OleDbCommand
            Me._commandCollection(1).Connection = New System.Data.OleDb.OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("BarConnectionString").ConnectionString)

try using the objects in the System.Data.SqlClient namespace, not the OleDb ones...