Tuesday, July 14, 2009

ASP 2.0 C# Access Connection String?

Can someone post a sample connection string to connect to an Access mdb file (not using SQL) in C#? I am using ASP.NET 2.0, but can only find SQL connection strings. Thanks.

ASP 2.0 C# Access Connection String?
http://www.carlprothman.net/Default.aspx...





You will always use a SQL statement to gather your info from the db.
Reply:Here is a sample.





Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\rebuilt.MDB





You can click on the top menu "tools" selection and select


"Connect to Database..." Select "Microsoft Access Database File", click Continue, browse to the database to open, and the connection will be added to your project.

jasmine

No comments:

Post a Comment