Re: Deploying Access Data Pages

From: Mary Chipman (mchip_at_nomail.please)
Date: 08/24/03

  • Next message: Gary L: "RE: SQL server failed to call Excel's library after ms03-026 patch applied" 
    Date: Sun, 24 Aug 2003 11:13:07 -0400

    You'll most likely have better luck getting an answer to this one by
    posting on microsoft.public.access.dataaccesspages than here. I doubt
    most SQLS developers have ever even heard of DAPs, much less used them
    in an application.
     
    -- Mary
    MCW Technologies
    http://www.mcwtech.com

    On Fri, 22 Aug 2003 04:52:07 -0700, "Vikas M H"
    <vikasharidas@yahoo.com> wrote:

    >Hi,
    > I am connecting to a SQL Server database with a Data
    >Access Page which contains a Workflow Toolbar Control.
    >While deploying the data access page in other machines, i
    >am getting the error "Data Provider could not be
    >initialized" and "Login failed for user (null). Reason:
    >Not associated with a trusted SQL Server connection" on
    >load of the page. The user who is trying to access is a
    >valid Active directory User who has also been added into
    >the SQL database users list under a particular role. How
    >do i resolve the problem? I have checked out the
    >solutions over the internet and did not find them helpful
    >enough. I tried to change the UseRemoteProvider property
    >to true and then received the "Internet Server Error" on
    >load of the page. However if i load the data access page
    >on the machine where the SQL Server exists, it is working
    >fine. Any help towards this would be greatly
    >appreaciated. Thanks in advance.
    >
    >Thanks and Regards,
    >Vikas Haridas

  • Next message: Gary L: "RE: SQL server failed to call Excel's library after ms03-026 patch applied"

    Relevant Pages

    • Re: Importing data into MS-SQL from AcuCobol
      ... All the stuff you can do to improve performance in SQL server has been done ... Using AcuODBC to MS-SQL OLE-DB 5.5 - 6 minutes ... >> interface to load the data. ...
      (comp.lang.cobol)
    • Re: sql server first install sa password, sapwd switch
      ... When I launch SQL install on the 4th CD, I get a window called MS SQL ... When that CD is inserted into the server, it should autoplay and display the setup panel for SQL Server and ISA Server, plus installation instructions. ... then the last cd of the set of 5 - and come back to load this SQL 2005 ... If you install SQL Server 2000, you should also have applied SQL SP4. ...
      (microsoft.public.windows.server.sbs)
    • Re: SQL CE 3 and CF 1.0 support
      ... > We have designed our application so that all data access logic is ... > using our automated upgrade mechanism and at the same time upgrade the ... > from the engine download and the database upgrade delay). ... > I also know of applications that have been using SQL CE databases in RAM ...
      (microsoft.public.sqlserver.ce)
    • Re: SQL Backend is way too slow
      ... The SQL BE is located on the WAN but so was the Ac BE. ... then moving to sql server for the back end will ... changing the source of a combo box to a query from a table actually makes it ... and then load up the form to the one record. ...
      (microsoft.public.access.forms)
    • Three Tier Access Database page
      ... Data Access Pages on the Internet or Your Intranet". ... ;[sql default] will modify the Sql if name is not found ... ;If we want to disable unknown connect values, we set Access to ... [connect CustomerDatabase] ...
      (microsoft.public.access.dataaccess.pages)