"Data provider could not be initialized"?

[Guest]

I have almost an identical problem to the following threads (none seem to be
resolved):

http://www.experts-exchange.com/Web...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

I creates a DAP using Access connecting to a mdb. All the files are located
in a folder in the inetpub directory. The DAP points to the database using
the UNC path(local path doesn't work). All this is in a virtual website in
IIS.

When my colleague or I access the DAP through iexplorer it works (much
slower for him) but, when I try to access the page from any other user
account I get:

"Data provider could not be initialized" followed by another popup saying:
"The microsoft jet database engine cannot open the file <UNC path>. It is
already opened exclusively by another user, or you need permission to view
it's data"

I'm pretty sure it's not an "in use" problem the db isn't locked and both of
us can access it in many instances at once. This leads me to focus on the
permision issue. We're the only 2 who can access it and we're both domain
admins. No other users can access it. Another problem is if we log in as THE
domain admin account we can't access it either. What's special about our 2
accounts that's preventing anyone else from accessing the page? All users
(including anonymous web account) have full ntfs folder/file as well as IIS
permissions.

Thanks,

Steve

 

[Tom Wickerath]

Hi Steve,

Just a guess on my part....I found the following in KB # 300699.


Tom

Common data access page deployment Errors
http://support.microsoft.com/?id=300699

NOTE: Before you receive these error messages, you may first receive the following error message:
Data provider could not be initialized.
These errors occur when the database cannot be found because of a data source that is not valid in the ConnectionString for the page, or when the UseRemoteProvider property is not configured properly. For additional information about valid connection strings for data access pages, click the following article number to view the article in the Microsoft Knowledge Base:

304324 HOW TO: Change the connection string for an Access 2002 data access page

For additional information about which OLE DB providers can be used with data access pages, click the following article number to view the article in the Microsoft Knowledge Base:
304521 ACC2002: Supported providers for data access pages

When you set the UseRemoteProvider property to False, the data access page checks on the local computer for the data source. When you set the UseRemoteProvider property to True, the data access page checks the Web server for the data source. This is known as three-tier data access. To configure the UseRemoteProvider property, follow these steps:
1. Start Microsoft Access, and then open the data access page that you are deploying in Design view.
2. On the View menu, click Properties to view the property sheet if it is not already visible.
3. On the Edit menu, click Select Page to view the properties for the page.
4. On the Data tab, set the UseRemoteProvider property to True.
5. Close and then save the data access page.IMPORTANT: As soon as you set the UseRemoteProvider property to True, data can no longer be viewed when the page is opened from the file system. Do not set the property until you are ready to publish the page from a properly configured IIS Web server.


_______________________________________________


I have almost an identical problem to the following threads (none seem to be
resolved):

http://www.experts-exchange.com/Web...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

I creates a DAP using Access connecting to a mdb. All the files are located
in a folder in the inetpub directory. The DAP points to the database using
the UNC path(local path doesn't work). All this is in a virtual website in
IIS.

When my colleague or I access the DAP through iexplorer it works (much
slower for him) but, when I try to access the page from any other user
account I get:

"Data provider could not be initialized" followed by another popup saying:
"The microsoft jet database engine cannot open the file <UNC path>. It is
already opened exclusively by another user, or you need permission to view
it's data"

I'm pretty sure it's not an "in use" problem the db isn't locked and both of
us can access it in many instances at once. This leads me to focus on the
permision issue. We're the only 2 who can access it and we're both domain
admins. No other users can access it. Another problem is if we log in as THE
domain admin account we can't access it either. What's special about our 2
accounts that's preventing anyone else from accessing the page? All users
(including anonymous web account) have full ntfs folder/file as well as IIS
permissions.

Thanks,

Steve