|
 |
access_asp thread: global.asa problem
Message #1 by "Anjali sarwal" <microfredo@m...> on Mon, 9 Dec 2002 19:49:16
|
|
Hi,
I am trying to access an Access Database using asp. I developed the asp
file using Visual interdev. It works fine on my PC but when I upload it
the global.asa file gives me this error
error '80070003' global.asa line 33. I think I am having trouble with the
data environment object.
the following is my global asa file, line 33 is the line at the end
starting in Application("DE")....
any suggestions will be appreciated.
thanks
anjali
</SCRIPT>
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==Visual InterDev Generated - startspan==
'--Project Data Connection
Application("cnTB_ConnectionString") = "DSN=TBDB;User
Id=admin;"
Application("cnTB_ConnectionTimeout") = 15
Application("cnTB_CommandTimeout") = 30
Application("cnTB_CursorLocation") = 3
Application("cnTB_RuntimeUserName") = "admin"
Application("cnTB_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>
Message #2 by "John Jerdak" <netman@b...> on Mon, 9 Dec 2002 15:15:00 -0500
|
|
Check the permissions on the server for running asa files.
JJ
Broadband Websystems
-----Original Message-----
From: Anjali sarwal [mailto:microfredo@m...]
Sent: Monday, December 09, 2002 7:49 PM
To: Access ASP
Subject: [access_asp] global.asa problem
Hi,
I am trying to access an Access Database using asp. I developed the asp
file using Visual interdev. It works fine on my PC but when I upload it
the global.asa file gives me this error
error '80070003' global.asa line 33. I think I am having trouble with
the
data environment object.
the following is my global asa file, line 33 is the line at the end
starting in Application("DE")....
any suggestions will be appreciated.
thanks
anjali
</SCRIPT>
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==Visual InterDev Generated - startspan==
'--Project Data Connection
Application("cnTB_ConnectionString") = "DSN=TBDB;User
Id=admin;"
Application("cnTB_ConnectionTimeout") = 15
Application("cnTB_CommandTimeout") = 30
Application("cnTB_CursorLocation") = 3
Application("cnTB_RuntimeUserName") = "admin"
Application("cnTB_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>
Message #3 by "Ken Schaefer" <ken@a...> on Tue, 10 Dec 2002 11:04:23 +1100
|
|
Delete these lines from the global.asa
Set DE = Server.CreateObject("DERuntime.DERuntime")
Application("DE") = DE.Load(Server.MapPath
("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
that is on the production server.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Anjali sarwal" <microfredo@m...>
Subject: [access_asp] global.asa problem
: Hi,
: I am trying to access an Access Database using asp. I developed the asp
: file using Visual interdev. It works fine on my PC but when I upload it
: the global.asa file gives me this error
: error '80070003' global.asa line 33. I think I am having trouble with the
: data environment object.
: the following is my global asa file, line 33 is the line at the end
: starting in Application("DE")....
: any suggestions will be appreciated.
: thanks
: anjali
:
: </SCRIPT>
:
: <SCRIPT LANGUAGE=VBScript RUNAT=Server>
: Sub Application_OnStart
: '==Visual InterDev Generated - startspan==
: '--Project Data Connection
: Application("cnTB_ConnectionString") = "DSN=TBDB;User
: Id=admin;"
: Application("cnTB_ConnectionTimeout") = 15
: Application("cnTB_CommandTimeout") = 30
: Application("cnTB_CursorLocation") = 3
: Application("cnTB_RuntimeUserName") = "admin"
: Application("cnTB_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>
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #4 by "microman microman" <microfredo@m...> on Tue, 10 Dec 2002 05:33:56 +0000
|
|
Server folks say all permissions are fine.
>From: "John Jerdak"
>Reply-To: "Access ASP"
>To: "Access ASP"
>Subject: [access_asp] RE: global.asa problem
>Date: Mon, 9 Dec 2002 15:15:00 -0500
>
>Check the permissions on the server for running asa files.
>
>JJ
>Broadband Websystems
>
>-----Original Message-----
>From: Anjali sarwal [mailto:microfredo@m...]
>Sent: Monday, December 09, 2002 7:49 PM
>To: Access ASP
>Subject: [access_asp] global.asa problem
>
>
>Hi,
>I am trying to access an Access Database using asp. I developed the asp
>file using Visual interdev. It works fine on my PC but when I upload it
>the global.asa file gives me this error
>error '80070003' global.asa line 33. I think I am having trouble with
>the
>data environment object.
>the following is my global asa file, line 33 is the line at the end
>starting in Application("DE")....
>any suggestions will be appreciated.
>thanks
>anjali
>
>
</DIV>>Sub Application_OnStart
</DIV>> '==Visual InterDev Generated - startspan==
</DIV>> '--Project Data Connection
</DIV>> Application("cnTB_ConnectionString") = "DSN=TBDB;User
</DIV>>Id=admin;"
</DIV>> Application("cnTB_ConnectionTimeout") = 15
</DIV>> Application("cnTB_CommandTimeout") = 30
</DIV>> Application("cnTB_CursorLocation") = 3
</DIV>> Application("cnTB_RuntimeUserName") = "admin"
</DIV>> Application("cnTB_RuntimePassword") = ""
</DIV>> '-- Project Data Environment
</DIV>> Set DE = Server.CreateObject("DERuntime.DERuntime")
</DIV>> Application("DE") = DE.Load(Server.MapPath
</DIV>>("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
</DIV>> '==Visual InterDev Generated - endspan==
</DIV>>End Sub
</DIV>>
Message #5 by "microman microman" <microfredo@m...> on Tue, 10 Dec 2002 05:41:29 +0000
|
|
I tried that on my PC. When I tried to view the asp file I get this error
Error Type:Microsoft JScript runtime (0x800A0005)Invalid procedure call or argument/MultiMode/_ScriptLibrary/pm.asp, line 192
DE.Init(Application('DE')); is line 192 ion the pm.asp
I don't think I can delete those lines because when I made the project the Data environment 'DE' was very much integrated into the
project. It is referenced in many places.
any other ideas??
I assume that when you say production server you mean on my PC where I am developing the asp file.
thanks
anjali
>From: "Ken Schaefer"
>Reply-To: "Access ASP"
>To: "Access ASP"
>Subject: [access_asp] Re: global.asa problem
>Date: Tue, 10 Dec 2002 11:04:23 +1100
>
>Delete these lines from the global.asa
>
>Set DE = Server.CreateObject("DERuntime.DERuntime")
>Application("DE") = DE.Load(Server.MapPath
>("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
>
>that is on the production server.
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "Anjali sarwal"
>Subject: [access_asp] global.asa problem
>
>
>: Hi,
>: I am trying to access an Access Database using asp. I developed the asp
>: file using Visual interdev. It works fine on my PC but when I upload it
>: the global.asa file gives me this error
>: error '80070003' global.asa line 33. I think I am having trouble with the
>: data environment object.
>: the following is my global asa file, line 33 is the line at the end
>: starting in Application("DE")....
>: any suggestions will be appreciated.
>: thanks
>: anjali
>:
>:
</DIV>>: Sub Application_OnStart
</DIV>>: '==Visual InterDev Generated - startspan==
</DIV>>: '--Project Data Connection
</DIV>>: Application("cnTB_ConnectionString") = "DSN=TBDB;User
</DIV>>: Id=admin;"
</DIV>>: Application("cnTB_ConnectionTimeout") = 15
</DIV>>: Application("cnTB_CommandTimeout") = 30
</DIV>>: Application("cnTB_CursorLocation") = 3
</DIV>>: Application("cnTB_RuntimeUserName") = "admin"
</DIV>>: Application("cnTB_RuntimePassword") = ""
</DIV>>: '-- Project Data Environment
</DIV>>: Set DE = Server.CreateObject("DERuntime.DERuntime")
</DIV>>: Application("DE") = DE.Load(Server.MapPath
</DIV>>: ("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
</DIV>>: '==Visual InterDev Generated - endspan==
</DIV>>: End Sub
</DIV>>:
Message #6 by "Ken Schaefer" <ken@a...> on Tue, 10 Dec 2002 16:57:35 +1100
|
|
Keep the lines for th global.asa on your *local* machine
Make a copy of global.asa (someplace outside your webroot), and delete those
lines. Upload the copy to your server.
When I say "production server" I mean the machine that is actually hosting
your "live" website. The machine that you are developing on is typically
called the "local server" or the "development server". You may also have an
intermediate "staging server".
[Dev Site] [Live Site]
Dev Server -> Staging Server -> Production Server
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "microman microman" <microfredo@m...>
Subject: [access_asp] Re: global.asa problem
:
: I tried that on my PC. When I tried to view the asp file I get this error
: Error Type:Microsoft JScript runtime (0x800A0005)Invalid procedure call or
argument/MultiMode/_ScriptLibrary/pm.asp, line 192
:
: DE.Init(Application('DE')); is line 192 ion the pm.asp
:
: I don't think I can delete those lines because when I made the project the
Data environment 'DE' was very much integrated into the project. It is
referenced in many places.
:
: any other ideas??
:
: I assume that when you say production server you mean on my PC where I am
developing the asp file.
:
: thanks
: anjali
:
:
:
: >From: "Ken Schaefer"
: >Reply-To: "Access ASP"
: >To: "Access ASP"
: >Subject: [access_asp] Re: global.asa problem
: >Date: Tue, 10 Dec 2002 11:04:23 +1100
: >
: >Delete these lines from the global.asa
: >
: >Set DE = Server.CreateObject("DERuntime.DERuntime")
: >Application("DE") = DE.Load(Server.MapPath
: >("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
: >
: >that is on the production server.
: >
: >Cheers
: >Ken
: >
: >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: >From: "Anjali sarwal"
: >Subject: [access_asp] global.asa problem
: >
: >
: >: Hi,
: >: I am trying to access an Access Database using asp. I developed the asp
: >: file using Visual interdev. It works fine on my PC but when I upload it
: >: the global.asa file gives me this error
: >: error '80070003' global.asa line 33. I think I am having trouble with
the
: >: data environment object.
: >: the following is my global asa file, line 33 is the line at the end
: >: starting in Application("DE")....
: >: any suggestions will be appreciated.
: >: thanks
: >: anjali
: >:
: >:
: </DIV>>: Sub Application_OnStart
: </DIV>>: '==Visual InterDev Generated - startspan==
: </DIV>>: '--Project Data Connection
: </DIV>>: Application("cnTB_ConnectionString") = "DSN=TBDB;User
: </DIV>>: Id=admin;"
: </DIV>>: Application("cnTB_ConnectionTimeout") = 15
: </DIV>>: Application("cnTB_CommandTimeout") = 30
: </DIV>>: Application("cnTB_CursorLocation") = 3
: </DIV>>: Application("cnTB_RuntimeUserName") = "admin"
: </DIV>>: Application("cnTB_RuntimePassword") = ""
: </DIV>>: '-- Project Data Environment
: </DIV>>: Set DE = Server.CreateObject("DERuntime.DERuntime")
: </DIV>>: Application("DE") = DE.Load(Server.MapPath
: </DIV>>: ("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
: </DIV>>: '==Visual InterDev Generated - endspan==
: </DIV>>: End Sub
: </DIV>>:
:
:
Message #7 by "rakesh gupta" <raj_hec@h...> on Fri, 13 Dec 2002 07:30:28 +0000
|
|
hi anjali ,
me rakesh here
i cant understand your problem properly
more over i wana help from your side to design a search engine
bye
>From: "Anjali sarwal" <microfredo@m...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] global.asa problem
>Date: Mon, 9 Dec 2002 19:49:16
>
>Hi,
>I am trying to access an Access Database using asp. I developed the asp
>file using Visual interdev. It works fine on my PC but when I upload it
>the global.asa file gives me this error
>error '80070003' global.asa line 33. I think I am having trouble with the
>data environment object.
>the following is my global asa file, line 33 is the line at the end
>starting in Application("DE")....
>any suggestions will be appreciated.
>thanks
>anjali
>
></SCRIPT>
>
><SCRIPT LANGUAGE=VBScript RUNAT=Server>
>Sub Application_OnStart
> '==Visual InterDev Generated - startspan==
> '--Project Data Connection
> Application("cnTB_ConnectionString") = "DSN=TBDB;User
>Id=admin;"
> Application("cnTB_ConnectionTimeout") = 15
> Application("cnTB_CommandTimeout") = 30
> Application("cnTB_CursorLocation") = 3
> Application("cnTB_RuntimeUserName") = "admin"
> Application("cnTB_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>
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
Message #8 by "microman microman" <microfredo@m...> on Mon, 16 Dec 2002 04:53:00 +0000
|
|
well I discarded my efforts with Data Environment and global.asa. I used notepad and created aDSN-less connection and was able to
bring up my table from the database just fine.
What I am looking for now is an example of a form with multiple buttons (add,delete,update,reset) so that one can add one record at
a time and click add or be able to update or delete an existing record. Do you have any suggestions as to where i might such
help???
thanks
>From: "Ken Schaefer"
>Reply-To: "Access ASP"
>To: "Access ASP"
>Subject: [access_asp] Re: global.asa problem
>Date: Tue, 10 Dec 2002 16:57:35 +1100
>
>Keep the lines for th global.asa on your *local* machine
>
>Make a copy of global.asa (someplace outside your webroot), and delete those
>lines. Upload the copy to your server.
>
>When I say "production server" I mean the machine that is actually hosting
>your "live" website. The machine that you are developing on is typically
>called the "local server" or the "development server". You may also have an
>intermediate "staging server".
>
>[Dev Site] [Live Site]
>Dev Server -> Staging Server -> Production Server
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "microman microman"
>Subject: [access_asp] Re: global.asa problem
>
>
>:
>: I tried that on my PC. When I tried to view the asp file I get this error
>: Error Type:Microsoft JScript runtime (0x800A0005)Invalid procedure call or
>argument/MultiMode/_ScriptLibrary/pm.asp, line 192
>:
>: DE.Init(Application('DE')); is line 192 ion the pm.asp
>:
>: I don't think I can delete those lines because when I made the project the
>Data environment 'DE' was very much integrated into the project. It is
>referenced in many places.
>:
>: any other ideas??
>:
>: I assume that when you say production server you mean on my PC where I am
>developing the asp file.
>:
>: thanks
>: anjali
>:
>:
>:
>: >From: "Ken Schaefer"
>: >Reply-To: "Access ASP"
>: >To: "Access ASP"
>: >Subject: [access_asp] Re: global.asa problem
>: >Date: Tue, 10 Dec 2002 11:04:23 +1100
>: >
>: >Delete these lines from the global.asa
>: >
>: >Set DE = Server.CreateObject("DERuntime.DERuntime")
>: >Application("DE") = DE.Load(Server.MapPath
>: >("Global.ASA"), "_private/DataEnvironment/DataEnvironment.asa")
>: >
>: >that is on the production server.
>: >
>: >Cheers
>: >Ken
>: >
>: >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>: >From: "Anjali sarwal"
>: >Subject: [access_asp] global.asa problem
>: >
>: >
>: >: Hi,
>: >: I am trying to access an Access Database using asp. I developed the asp
>: >: file using Visual interdev. It works fine on my PC but when I upload it
>: >: the global.asa file gives me this error
>: >: error '80070003' global.asa line 33. I think I am having trouble with
>the
>: >: data environment object.
>: >: the following is my global asa file, line 33 is the line at the end
>: >: starting in Application("DE")....
>: >: any suggestions will be appreciated.
>: >: thanks
>: >: anjali
>: >:
>: >:
>:
>: Sub Application_OnStart
>:
>: '==Visual InterDev Generated - startspan==
>:
>: '--Project Data Connection
>:
>: Application("cnTB_ConnectionString") = "DSN=TBDB;User
>:
>: Id=admin;"
>:
>: Application("cnTB_ConnectionTimeout") = 15
>:
>: Application("cnTB_CommandTimeout") = 30
>:
>: Application("cnTB_CursorLocation") = 3
>:
>: Application("cnTB_RuntimeUserName") = "admin"
>:
>: Application("cnTB_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
>:
>:
>:
>: ---
>:
>
>
>---
The new MSN 8: smart spam protection and 2 months FREE*
|
|
|
View Cart
