Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Is there really no help out there for DAP?

Discussion in 'Information Technology' started by Mike Vance, Nov 7, 2005.

  1. Mike Vance

    Mike Vance
    Expand Collapse


    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.


    "LT" wrote:

    > Hi Gijs
    > Thank you for your answer, I'll try some of these possibilities.
    > "Gijs Beukenoot" skrev:
    > > 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.
    > > "
    > >
    > >
    > >
  2. Loading...

    Similar Threads Forum Date
    Opinion Feeling Of Turban On Head 'really Gratifying': Ben Kingsley Sikh Sikhi Sikhism May 26, 2016
    Who Are The Sikhs, Really ? Questions and Answers Feb 7, 2016
    The Illusion Of matter: Our Physical World Really Isn't Physical At All General Nov 26, 2015
    You have no idea how badass Trudeau's Defence Minister really is! Sikh Personalities Nov 7, 2015
    Controversial Raagmala - Is It Really Part Of Gurbani? Hard Talk Oct 14, 2015

Share This Page