Before you begin you should check to make sure that you have MDAC v2.1 SP2 or later installed on yourserver. To get the latest MDAC goto http://www.microsoft.com/data. If you are unsure which version of MDAC you have installed Microsoft provides a tool called ComCheck which will tell you.
A basic OLEDB Connection String looks like this:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db1.mdb"
Of course you will have to replace the path above ("c:\db1.mdb") with the path and filename of your own database. If the database is lo...[ 查看全文 ]