Solved

Publishing Access to IIS

Posted on 1998-12-29
4
386 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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
strange textbox behavior MS Access 9 34
Close Print Preview button not active 12 36
Track name AutoCorrect info 14 46
Access Query based on a Form Field 2 18
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now