Is there really no help out there for DAP?

[Guest]

I have tried to get help for a pretty general problem with DAP. Many people
ask this question, but I haven't found a useable answer yet.

I have created an access database on my local drive and I have created some
access pages for it. The purpus of the database is to allow partners to
register their use of a product and to order new ones. Therefore the database
and access pages have been moved to an internet server and the references in
the access page have been modified accordingly.

When I try to access the data in the datadase via the access page I get the
following error: “data provider could not be initializedâ€.
Why is that? What can I do about it?

 

[Gijs Beukenoot]

From LT :

I have tried to get help for a pretty general problem with DAP. Many people
ask this question, but I haven't found a useable answer yet.

I have created an access database on my local drive and I have created some
access pages for it. The purpus of the database is to allow partners to
register their use of a product and to order new ones. Therefore the database
and access pages have been moved to an internet server and the references in
the access page have been modified accordingly.

When I try to access the data in the datadase via the access page I get the
following error: “data provider could not be initializedâ€.
Why is that? What can I do about it?

Could be the wrong version of MDAC/JET or (from the MS-KB):

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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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.
"

 

[Guest]

Hi Gijs
Thank you for your answer, I'll try some of these possibilities.

"Gijs Beukenoot" skrev:

 

[Guest]

LT,

I have had problems with the provider in the past and there are many
reasons. I typically go into control panel and set up an ODBC DSN just to
make sure I can connect, more than once I could not - eliminating my DAP.
Out of date WEB components, MDAC and possibly computer name to IP resolution
is at fault. For instance I can open a DAP using a computer name but can not
pass cookies, if I determine the IP of that same computer cookies pass just
fine. So little in the debugging area is available for DAP's. Another
problem I have seen was the inability to see the fields in an SQL database
within the Field List, the tables were present but not fields. I killed the
connection and created another exactly as the original and all was fixed - go
figure, no error messages before either.

 

[aaron.kempf]

DAP rock.

what you should do is create a SQL Server - Access Data Project and use
DAPS with that. it has proven to be quite reliable in my opinion.

catch me on msn instant messenger if you need more help
(e-mail address removed)