|
|
Connecting to a Microsoft Access database with ASP.NET - Windows
|
Views : 1139
|
|
Tagged in : Windows
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
To use a Microsoft Access Database (.mdf file), you will need to create a folder in your web space (inside the httpdocs folder) and give this folder full write permissions using the file manager in your Plesk control panel (click the padlock icon next to the folder you have created to set the permissions).
There is a tutorial to show you how to use the file manager here.
Once the database has been uploaded, you may wish to setup an ODBC connection to the database for easier connection.
If you want to connect to the database using your scripts, you can use:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Inetpubvhostsyourdomain.comhttpdocsfolderyourcreateddatabase.mdf" '## MS Access 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskCreatingConnectionToAccessDatabase.asp
http://www.basic-ultradev.com/articles/ADOConnections
http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/2/ |
|
By RameshKumar, On - 2008-07-16 |
|
|
|
