|
 |
asp_databases thread: Connection/Command objects ??
Message #1 by "padmaja jaganmohan" <padmaja.jaganmohan@w...> on Tue, 3 Dec 2002 03:55:12
|
|
Dear All,
I am facing a strange problem for which I don't get any explanation .
The server in which our department website was crashed . The contents were
however retrieved and the site was up again , BUT THEN A DISASTER STRUCK .
The asp files of one of the applications (which worked perfect before
crash)just failed to work . I checked all the possible problems but none
were existing .
I have always found it comfortable to work with the connection and
recordset objects rather than command objects . So I just changed the
database connection part to be handled with connection and recordset
objects, earlier it was using the command object . THE APPLICATION WORKED
PERFECT .
I had to change this part in all the ASP pages to make the entire chunk
work .
I solved the problem , but fail to understand why it occured .
Can anyone please explain .
Thanks for your help
Message #2 by "Roy, Siddarth S" <sroy@b...> on Mon, 2 Dec 2002 22:48:13 -0500
|
|
Well what i understand out of query is
previously u were working with the command objects rather than
connection and recordset objects if that is the consideration .I hope
the constants file is still there
that would be adovbs file or may be u may be missing some updates which
are not not there may be recordsets and connections are basic database
conn objects they would be working well
Hope this helps
sid
-----Original Message-----
From: padmaja jaganmohan [mailto:padmaja.jaganmohan@w...]
Sent: Monday, December 02, 2002 10:55 PM
To: ASP Databases
Subject: [asp_databases] Connection/Command objects ??
Dear All,
I am facing a strange problem for which I don't get any explanation .
The server in which our department website was crashed . The contents
were
however retrieved and the site was up again , BUT THEN A DISASTER STRUCK
.
The asp files of one of the applications (which worked perfect before
crash)just failed to work . I checked all the possible problems but none
were existing .
I have always found it comfortable to work with the connection and
recordset objects rather than command objects . So I just changed the
database connection part to be handled with connection and recordset
objects, earlier it was using the command object . THE APPLICATION
WORKED
PERFECT .
I had to change this part in all the ASP pages to make the entire chunk
work .
I solved the problem , but fail to understand why it occured .
Can anyone please explain .
Thanks for your help
Message #3 by "padmaja" <padmaja.jaganmohan@w...> on Tue, 3 Dec 2002 09:31:38 +0530
|
|
No files were deleted or got deleted . Everything was restored yet din't
work .
Can u explain ?
-----Original Message-----
From: Roy, Siddarth S [mailto:sroy@b...]
Sent: Tuesday, December 03, 2002 9:18 AM
To: ASP Databases
Subject: [asp_databases] RE: Connection/Command objects ??
Well what i understand out of query is
previously u were working with the command objects rather than connection
and recordset objects if that is the consideration .I hope the constants
file is still there
that would be adovbs file or may be u may be missing some updates which are
not not there may be recordsets and connections are basic database conn
objects they would be working well
Hope this helps
sid
-----Original Message-----
From: padmaja jaganmohan [mailto:padmaja.jaganmohan@w...]
Sent: Monday, December 02, 2002 10:55 PM
To: ASP Databases
Subject: [asp_databases] Connection/Command objects ??
Dear All,
I am facing a strange problem for which I don't get any explanation .
The server in which our department website was crashed . The contents were
however retrieved and the site was up again , BUT THEN A DISASTER STRUCK .
The asp files of one of the applications (which worked perfect before
crash)just failed to work . I checked all the possible problems but none
were existing .
I have always found it comfortable to work with the connection and
recordset objects rather than command objects . So I just changed the
database connection part to be handled with connection and recordset
objects, earlier it was using the command object . THE APPLICATION WORKED
PERFECT .
I had to change this part in all the ASP pages to make the entire chunk
work .
I solved the problem , but fail to understand why it occured .
Can anyone please explain .
Thanks for your help
Message #4 by "Ken Schaefer" <ken@a...> on Tue, 3 Dec 2002 15:22:48 +1100
|
|
Hi,
You originally said: "it just failed to work". Did you get any error
messages? What where they?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "padmaja" <padmaja.jaganmohan@w...>
Subject: [asp_databases] RE: Connection/Command objects ??
: No files were deleted or got deleted . Everything was restored yet din't
: work .
:
: Can u explain ?
:
:
:
: -----Original Message-----
: From: Roy, Siddarth S [mailto:sroy@b...]
: Sent: Tuesday, December 03, 2002 9:18 AM
: To: ASP Databases
: Subject: [asp_databases] RE: Connection/Command objects ??
:
:
: Well what i understand out of query is
:
: previously u were working with the command objects rather than connection
: and recordset objects if that is the consideration .I hope the constants
: file is still there
:
: that would be adovbs file or may be u may be missing some updates which
are
: not not there may be recordsets and connections are basic database conn
: objects they would be working well
:
: Hope this helps
:
: sid
:
: -----Original Message-----
: From: padmaja jaganmohan [mailto:padmaja.jaganmohan@w...]
: Sent: Monday, December 02, 2002 10:55 PM
: To: ASP Databases
: Subject: [asp_databases] Connection/Command objects ??
:
:
: Dear All,
:
: I am facing a strange problem for which I don't get any explanation .
:
: The server in which our department website was crashed . The contents were
: however retrieved and the site was up again , BUT THEN A DISASTER STRUCK .
: The asp files of one of the applications (which worked perfect before
: crash)just failed to work . I checked all the possible problems but none
: were existing .
:
: I have always found it comfortable to work with the connection and
: recordset objects rather than command objects . So I just changed the
: database connection part to be handled with connection and recordset
: objects, earlier it was using the command object . THE APPLICATION WORKED
: PERFECT .
:
: I had to change this part in all the ASP pages to make the entire chunk
: work .
:
:
: I solved the problem , but fail to understand why it occured .
:
: Can anyone please explain .
:
: Thanks for your help
Message #5 by "padmaja" <padmaja.jaganmohan@w...> on Tue, 3 Dec 2002 10:49:36 +0530
|
|
I used the ON ERROR RESUME NEXT but din't give any error description . It
just says
YOU ARE NOT AUTHORIZED TO VIEW THIS PAGE ................
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Tuesday, December 03, 2002 9:53 AM
To: ASP Databases
Subject: [asp_databases] RE: Connection/Command objects ??
Hi,
You originally said: "it just failed to work". Did you get any error
messages? What where they?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "padmaja" <padmaja.jaganmohan@w...>
Subject: [asp_databases] RE: Connection/Command objects ??
: No files were deleted or got deleted . Everything was restored yet din't
: work .
:
: Can u explain ?
:
:
:
: -----Original Message-----
: From: Roy, Siddarth S [mailto:sroy@b...]
: Sent: Tuesday, December 03, 2002 9:18 AM
: To: ASP Databases
: Subject: [asp_databases] RE: Connection/Command objects ??
:
:
: Well what i understand out of query is
:
: previously u were working with the command objects rather than connection
: and recordset objects if that is the consideration .I hope the constants
: file is still there
:
: that would be adovbs file or may be u may be missing some updates which
are
: not not there may be recordsets and connections are basic database conn
: objects they would be working well
:
: Hope this helps
:
: sid
:
: -----Original Message-----
: From: padmaja jaganmohan [mailto:padmaja.jaganmohan@w...]
: Sent: Monday, December 02, 2002 10:55 PM
: To: ASP Databases
: Subject: [asp_databases] Connection/Command objects ??
:
:
: Dear All,
:
: I am facing a strange problem for which I don't get any explanation .
:
: The server in which our department website was crashed . The contents were
: however retrieved and the site was up again , BUT THEN A DISASTER STRUCK .
: The asp files of one of the applications (which worked perfect before
: crash)just failed to work . I checked all the possible problems but none
: were existing .
:
: I have always found it comfortable to work with the connection and
: recordset objects rather than command objects . So I just changed the
: database connection part to be handled with connection and recordset
: objects, earlier it was using the command object . THE APPLICATION WORKED
: PERFECT .
:
: I had to change this part in all the ASP pages to make the entire chunk
: work .
:
:
: I solved the problem , but fail to understand why it occured .
:
: Can anyone please explain .
:
: Thanks for your help
Message #6 by "Ken Schaefer" <ken@a...> on Tue, 3 Dec 2002 16:30:42 +1100
|
|
Take out "On Error Resume Next" so that you can see the exact error message
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "padmaja" <padmaja.jaganmohan@w...>
Subject: [asp_databases] RE: Connection/Command objects ??
: I used the ON ERROR RESUME NEXT but din't give any error description . It
: just says
:
: YOU ARE NOT AUTHORIZED TO VIEW THIS PAGE ................
Message #7 by "padmaja" <padmaja.jaganmohan@w...> on Tue, 3 Dec 2002 11:11:07 +0530
|
|
I tried that as well . No luck
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Tuesday, December 03, 2002 11:01 AM
To: ASP Databases
Subject: [asp_databases] RE: Connection/Command objects ??
Take out "On Error Resume Next" so that you can see the exact error message
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "padmaja" <padmaja.jaganmohan@w...>
Subject: [asp_databases] RE: Connection/Command objects ??
: I used the ON ERROR RESUME NEXT but din't give any error description . It
: just says
:
: YOU ARE NOT AUTHORIZED TO VIEW THIS PAGE ................
Message #8 by "Roy, Siddarth S" <sroy@b...> on Tue, 3 Dec 2002 14:52:27 -0500
|
|
Does the old code rum on some other server where the command object is
running
well if it is then run the com checkher component check the mdac packs
on the both the servers
hope this helps
cheers
sid
-----Original Message-----
From: padmaja [mailto:padmaja.jaganmohan@w...]
Sent: Monday, December 02, 2002 11:02 PM
To: ASP Databases
Subject: [asp_databases] RE: Connection/Command objects ??
No files were deleted or got deleted . Everything was restored yet din't
work .
Can u explain ?
-----Original Message-----
From: Roy, Siddarth S [mailto:sroy@b...]
Sent: Tuesday, December 03, 2002 9:18 AM
To: ASP Databases
Subject: [asp_databases] RE: Connection/Command objects ??
Well what i understand out of query is
previously u were working with the command objects rather than
connection
and recordset objects if that is the consideration .I hope the constants
file is still there
that would be adovbs file or may be u may be missing some updates which
are
not not there may be recordsets and connections are basic database conn
objects they would be working well
Hope this helps
sid
-----Original Message-----
From: padmaja jaganmohan [mailto:padmaja.jaganmohan@w...]
Sent: Monday, December 02, 2002 10:55 PM
To: ASP Databases
Subject: [asp_databases] Connection/Command objects ??
Dear All,
I am facing a strange problem for which I don't get any explanation .
The server in which our department website was crashed . The contents
were
however retrieved and the site was up again , BUT THEN A DISASTER STRUCK
.
The asp files of one of the applications (which worked perfect before
crash)just failed to work . I checked all the possible problems but none
were existing .
I have always found it comfortable to work with the connection and
recordset objects rather than command objects . So I just changed the
database connection part to be handled with connection and recordset
objects, earlier it was using the command object . THE APPLICATION
WORKED
PERFECT .
I had to change this part in all the ASP pages to make the entire chunk
work .
I solved the problem , but fail to understand why it occured .
Can anyone please explain .
Thanks for your help
Message #9 by "Ken Schaefer" <ken@a...> on Wed, 4 Dec 2002 12:46:51 +1100
|
|
WHAT IS THE ERROR MESSAGE?
(turn off "Show Friendly HTTP errors" in Internet Explorer)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "padmaja" <padmaja.jaganmohan@w...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, December 03, 2002 4:41 PM
Subject: [asp_databases] RE: Connection/Command objects ??
: I tried that as well . No luck
:
: -----Original Message-----
: From: Ken Schaefer [mailto:ken@a...]
: Sent: Tuesday, December 03, 2002 11:01 AM
: To: ASP Databases
: Subject: [asp_databases] RE: Connection/Command objects ??
:
:
: Take out "On Error Resume Next" so that you can see the exact error
message
:
: Cheers
: Ken
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: "padmaja" <padmaja.jaganmohan@w...>
: Subject: [asp_databases] RE: Connection/Command objects ??
:
:
: : I used the ON ERROR RESUME NEXT but din't give any error description .
It
: : just says
: :
: : YOU ARE NOT AUTHORIZED TO VIEW THIS PAGE ................
:
:
:
:
:
|
|
|
View Cart
