ASP. NET 2.0 beta2 learning Tour (2) -- a small difference between sqldatasource and accessdatasource

We studied sqldatasource and accessdatasource data yesterday and today.

The main functions of the sqldatasource control are:UsedSQL Server,OLE DB,ODBC,OracleAnd other data sources, including the access database. The accessdatasource control is specially usedSlaveMicrosoft AccessSearch data in the database. From this perspective, both the sqldatasource and accessdatasource controls can access and operate the ACCESS database.

however, there is a difference between the two. The sqldatasource control uses the connectionstring attribute to connect to the database, while the accessdatasource uses the datafile attribute to directly connect to access through the file address. In addition, other differences are relatively small.

A problem is found now. If the sqldatasource control is used, you can set the Database Password and other security information through the connectionstring attribute. If the accessdatasource control is used to process access files with passwords, how can we set security information? Currently, I have not found any solutions.

Source: http://blog.aspcool.com/polaris/archive/2005/06/16/2455.html