Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Web Publishing (97)

    Couple of related queries I am trying to iron out - first time I've used the web publishing wizard and frankly, I've read the book but still none the wiser in some respects so help would be gratefully appreciated.
    I have my database already set but for now I'm just trying the basics and only using a table and a simple query as an example.
    I use the publishing wizard and publish the page as asp.
    The server is running on a separate desktop but no problems with other pages over the browser.
    When I try and return data I am getting
    "Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

    I searched WL and found previous thread post by seoras who actually added a system dsn for access
    When I try this however I get:
    "Unable to load msjter40.dll"
    and then
    "The Microsoft Access Driver is out of memory"

    Any help would be good help.

    Cheers
    Alan
    Wits End
    Weather outlook - gloomy <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Web Publishing (97)

    The capabilities of Access 97 are pretty limited in terms of publishing pages to the web to begin with - but you also appear to have some sort of issue with the Data Access components on your computer - the DLL that you got an error from is a Jet 4.0 component, while Access 97 uses 3.5. This isn't much help or encouragement, but unless someone else can suggest other options I think you will continue to have problems.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Web Publishing (97)

    Thanks Wendel. Kind of the same conclusion I was coming to - problems.
    However, did have success when the connection details were included in the script and not left to separate DSN.

    My problem now is (and I'm hoping someone will have a solution or reason for this):-
    The asp page works fine for returning data which is held in a table already in the database.
    But when I run a query which is based on a linked table, I get an error saying the linked tables database cannot be accessed.

    Any suggestions?
    Resort to SQL?

    TIA
    Alan

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Web Publishing (97)

    In that case, I'm afraid you will have to set a connection to the database which contains the actual table, not to the database that has a link. ASP doesn't know about the method which Access uses to link to tables in another MDB file.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •