Solved

Publishing Access to IIS

Posted on 1998-12-29
4
408 Views
Last Modified: 2008-02-20
Pretty self explanatory. Tried publishing the tute database that came with Interdev and MSDN. Can't seem to get it to work. Here's the code and error message

---This is the global.asa---
<SCRIPT LANGUAGE='VBScript' RUNAT='Server'>

'You can add special event handlers in this file that will get run automatically when
'special Active Server Pages events occur. To create these handlers, just create a
'subroutine with a name from the list below that corresponds to the event you want to
'use. For example, to create an event handler for Session_OnStart, you would put the
'following code into this file (without the comments):

'Sub Session_OnStart
'**Put your code here **
'End Sub

'EventName              Description
'Session_OnStart        Runs the first time a user runs any page in your application
'Session_OnEnd          Runs when a user's session times out or quits your application
'Application_OnStart    Runs once when the first page of your application is run for the first time by any user
'Application_OnEnd      Runs once when the web server shuts down

</SCRIPT>
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
      '==Visual InterDev Generated - startspan==
      '--Project Data Connection
            Application("Fitch_ConnectionString") = "DSN=Fitch;DBQ=F:\Jason\Fitch\Fitch_Mather.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5;"
            Application("Fitch_ConnectionTimeout") = 15
            Application("Fitch_CommandTimeout") = 30
            Application("Fitch_CursorLocation") = 3
            Application("Fitch_RuntimeUserName") = ""
            Application("Fitch_RuntimePassword") = ""
      '-- Project Data Environment
            Set DE = Server.CreateObject("DERuntime.DERuntime")
            Application("DE") = DE.Load(Server.MapPath("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
      '==Visual InterDev Generated - endspan==
End Sub
</SCRIPT>

---This is the error message when I try to browse---

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/Fitch/global.asa, line 31

Invalid class string

It may be an ODBC thing I'm not sure but maybe someone knows. By the way does anybody know of a good book on this stuff ie. Interdev, Access and the Web.

I'll start at 50 and go from there and if the suggestions are good enough I'll up the points.

Many thanks
0
Comment
Question by:Jasson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 4

Expert Comment

by:siabod
ID: 1972269
i know a good book about ASP... and it's about the topics you described to... it's called Active Server Pages unleashed
isbn : 1-57521-351-6
0
 

Author Comment

by:Jasson
ID: 1972270
Thanks siabod I'll have a look. The unleashed ones are generally pretty good. Any ideas on the error message?

Regards Jason
0
 
LVL 1

Accepted Solution

by:
wdavidsmith earned 50 total points
ID: 1972271
It appears that the DLL or Server-Side ActiveX control "DERuntime" is missing or corrupted. Froma analyzing the code, I'd say that the call to this DLL is appending the Session() variables contained in the "DataEnvironment.ASA" to the "Global.ASA" (similar to a #include statement in C++).

What I'd try is removing (commenting) the lines:

'Set DE = Server.CreateObject("DERuntime.DERuntime")
'Application("DE") = DE.Load(Server.MapPath("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")

then copy the contents of the "DataEnvironment.ASA" file to the "Global.ASA" and try loading your page again.

I hope this helps...
0
 

Author Comment

by:Jasson
ID: 1972272
This didn't actually work. Turns out that I had a problem with the visual studio/NT installation and fixed it with a complete system reinstall.

Either way thanks for the answer here are the points anyway.

Thanks Jason
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question