We help IT Professionals succeed at work.

Data Provider Could Not Be Initialized Error using MS Data Access Page

dyarosh
dyarosh asked
on
2,916 Views
Last Modified: 2012-06-21
I have a MS Data Access Page that works fine when previewed in a web browser from within MS Access.  I published the page to my web server and received the Data Provider Could Not Be Initialized error followed by Not A Valid File Name error.  I researched the problem and found a posting on this site that had a similar problem and I followed those instructions which basically talked about setting the connection string properly.  Right now I have the connection string referencing the database as Meals.mdb without any path specified (should look for the database in the same directory where the Data Access Page resides which it does).  I still get the same error.  I published the Data Access Page to my local server running IIS v5.1 and I get the same error.  In doing additional research I found something that talked about permissions on the MSADC virtual directory.  I can't seem to find the MSADC virtual directory which leads me to believe I may not be running something that I need.  If this is so, what should I be running?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Hi dyarosh,
please post your connection string.  (**** out the password if it's in there).

Author

Commented:
Here is the top portion of the Data Access Page up to the functions.  I put a blank line where the connection string starts.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:x =
"urn:schemas-microsoft-com:office:excel" xmlns:a =
"urn:schemas-microsoft-com:office:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>Meals</TITLE><LINK
href="Meals_files/filelist.xml" type=text/xml rel=File-List>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content=10.00.2225 name=DesignerVersion>
<META content="HTML 4.0" name=vs_targetSchema>
<OBJECT id=MSODSC tabIndex=-1
classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE="<xml xmlns:a=&quot;urn:schemas-microsoft-com:office:access&quot;>&#13;&#10; <a:DataSourceControl>&#13;&#10;  <a:OWCVersion>10.0.0.6619         </a:OWCVersion>&#13;&#10;  

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=Meals.mdb;Mode=Share Deny None;Extended Properties=&amp;quot;&amp;quot;;Persist Security Info=False;Jet OLEDB:System database=&amp;quot;&amp;quot;;Jet OLEDB:Registry Path=&amp;quot;&amp;quot;;Jet OLEDB:Database Password=&amp;quot;&amp;quot;;Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=&amp;quot;&amp;quot;;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>&#13;&#10;  <a:MaxRecords>10000</a:MaxRecords>&#13;&#10;  <a:GridX>24</a:GridX>&#13;&#10;  <a:GridY>24</a:GridY>&#13;&#10;  <a:OfflineType>2</a:OfflineType>&#13;&#10;  <a:XMLLocation>0</a:XMLLocation>&#13;&#10;  <a:XMLDataTarget></a:XMLDataTarget>&#13;&#10;  <a:ConnectionFile></a:ConnectionFile>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>MealsNavLabel</a:ElementID>&#13;&#10;   <a:RecordsetLabel>Meals |0 of |2;Meals |0-|1 of |2</a:RecordsetLabel>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>date</a:ElementID>&#13;&#10;   <a:ControlSource>date</a:ControlSource>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>name</a:ElementID>&#13;&#10;   <a:ControlSource>name</a:ControlSource>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>phone</a:ElementID>&#13;&#10;   <a:ControlSource>phone</a:ControlSource>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>email</a:ElementID>&#13;&#10;   <a:ControlSource>email</a:ControlSource>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   <a:ElementID>meal</a:ElementID>&#13;&#10;   <a:ControlSource>meal</a:ControlSource>&#13;&#10;  </a:ElementExtension>&#13;&#10;  <a:GroupLevel>&#13;&#10;   <a:RecordSource>Meals</a:RecordSource>&#13;&#10;   <a:DefaultSort>[date] ASC</a:DefaultSort>&#13;&#10;   <a:HeaderElementId>HeaderMeals</a:HeaderElementId>&#13;&#10;   <a:FooterElementId></a:FooterElementId>&#13;&#10;   <a:CaptionElementId></a:CaptionElementId>&#13;&#10;   <a:RecordNavigationElementId>NavigationMeals</a:RecordNavigationElementId>&#13;&#10;   <a:DataPageSize>10</a:DataPageSize>&#13;&#10;   <a:GroupFilterControl></a:GroupFilterControl>&#13;&#10;  </a:GroupLevel>&#13;&#10;  <a:Datamodel a:version=&quot;0816&quot;>&#13;&#10;   <a:SchemaRowsource a:id=&quot;Meals&quot; a:type=&quot;dscTable&quot;>&#13;&#10;    <a:SchemaField a:id=&quot;id&quot; a:datatype=&quot;3&quot; a:size=&quot;0&quot; a:iskey=&quot;1&quot;/>&#13;&#10;    <a:SchemaField a:id=&quot;date&quot; a:datatype=&quot;7&quot; a:size=&quot;0&quot;/>&#13;&#10;    <a:SchemaField a:id=&quot;name&quot; a:datatype=&quot;130&quot; a:size=&quot;20&quot;/>&#13;&#10;    <a:SchemaField a:id=&quot;phone&quot; a:datatype=&quot;130&quot; a:size=&quot;12&quot;/>&#13;&#10;    <a:SchemaField a:id=&quot;email&quot; a:datatype=&quot;130&quot; a:size=&quot;50&quot;/>&#13;&#10;    <a:SchemaField a:id=&quot;meal&quot; a:datatype=&quot;130&quot; a:size=&quot;255&quot;/>&#13;&#10;   </a:SchemaRowsource>&#13;&#10;   <a:RecordsetDef a:id=&quot;Meals&quot;>&#13;&#10;    <a:PageField a:id=&quot;id&quot;/>&#13;&#10;    <a:PageField a:id=&quot;date&quot;/>&#13;&#10;    <a:PageField a:id=&quot;name&quot;/>&#13;&#10;    <a:PageField a:id=&quot;phone&quot;/>&#13;&#10;    <a:PageField a:id=&quot;email&quot;/>&#13;&#10;    <a:PageField a:id=&quot;meal&quot;/>&#13;&#10;   </a:RecordsetDef>&#13;&#10;  </a:Datamodel>&#13;&#10; </a:DataSourceControl>&#13;&#10;</xml>"></OBJECT>
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
see also http://support.microsoft.com/?kbid=300699 and look for the section about "UseRemoteProvider" which may also help you towards a resolution.
I'd try reinstalling JET first though.

Author

Commented:
How do I determine if the provider is installed?  I went to the link and downloaded the latest patch and when I installed it it says that it is not compatible with my OS (Win XP Pro).  It says that the components are part of the OS.  I had already looked at the second link you provided which is why I wanted to know where the MSADC virtual directory is.

Sorry about supplying the information in the format that I did.  I wasn't sure if something was embedded that I missed which is why I gave you all of the info.

Author

Commented:
I want to thank alimu for helping me with this problem.  Although his information didn't solve my problem it at least helped me to determine where the problem is (it has to do with permissions on the database file or at least being able to find it via the Connection String).  I still can't use the Data Access Page on my site but I don't have any more time to play with it to try and get it working.  At this point it seems it will be faster if I just code it myself using SQL.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.