Click here to Skip to main content
12,950,284 members (66,756 online)
Rate this:
 
Please Sign up or sign in to vote.
I use this Connection Code to insert, update & delete the content
Dim constr As String = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath("../databasename.mdb;")& "Jet OLEDB:Database Password=mypassword;"


Which Work Fine,


Now when I Load the Data into Some Page from Database, the Webpage Display Error & Redirect to Error Page.

For Load Data I use Following code :

<asp:AccessDataSource ID="ADSource" runat="server" DataFile="~/databasename.mdb" SelectCommand="SELECT * FROM [Table]"></asp:AccessDataSource>


1) Why, Its because I didn't add password into above code? If Yes, How to Add Password into Above Code?

2) How to Set above Connection Code into Web.config & Use it into Webpage?
Posted 10-Sep-12 23:54pm
s1a2b3643
Updated 11-Sep-12 0:01am
v3

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

The AccessDataSource will not connect to an Access database that is password-protected; to retrieve data from a password-protected Access database, use the SqlDataSource control.

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource(v=vs.100).aspx[^]
  Permalink  
Comments
s1a2b3 11-Sep-12 6:14am
   
that means i have to convert my database in MS SQL?
Can you Give Me Sample Code for SqlDataSource with Above Parameters?
Kuthuparakkal 11-Sep-12 6:25am
   
http://msdn.microsoft.com/en-us/library/ms247233(v=vs.80).aspx

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,829
CHill60 3,460
Maciej Los 2,953
Jochen Arndt 1,975
ppolymorphe 1,820


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 11 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100