|
 |
asp_databases thread: RE: asp_databases digest: June 12, 2002
Message #1 by "Biermeier, Marcelo Zelone" <Marcelo.Biermeier@v...> on Thu, 13 Jun 2002 08:28:02 -0300
|
|
Please,
I would like that the responsable for ASP page cancel my name from the
distribution list of ASP.
Thanks,
Marcelo.
-----Original Message-----
From: ASP Databases digest [mailto:asp_databases@p...]
Sent: quarta-feira, 12 de junho de 2002 20:02
To: asp_databases digest recipients
Subject: asp_databases digest: June 12, 2002
-----------------------------------------------
When replying to the digest, please quote only
relevant material, and edit the subject line to
reflect the message you are replying to.
-----------------------------------------------
The URL for this list is:
http://p2p.wrox.com/list.asp?list=asp_databases
Get the Readers Advantage price for
Professional ASP Data Access from Barnes & Noble.
---
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&bfpid=1861
003927&bfmtype=book
ASP_DATABASES Digest for Wednesday, June 12, 2002.
1. Re: error
2. Re: error
3. Update Command :: Obtaining SQL Identity Field from new record in
recordser
4. MSDE Problem
5. RE: MSDE Problem
6. RE: MSDE Problem
7. Re: MSDE Problem
8. Back button coding
9. RE: Back button coding
10. RE: MSDE Problem
11. Re: Back button coding
12. Re: Back button coding
13. Re: Back button coding
----------------------------------------------------------------------
Subject: Re: error
From: "Ken Schaefer" <ken@a...>
Date: Wed, 12 Jun 2002 16:25:04 +1000
X-Message-Number: 1
What cursor type are you using? Some cursors (eg adOpenForwardOnly) do not
support bookmarking (hence the error you are getting)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Roy, Siddarth S" <sroy@b...>
Subject: [asp_databases] error
i am using a db2 database .
the env i am working on
mdac 2.6 , win2k
even the server has the same thing when i work in dev enev no error came up
in this code
The code is using the recordset book mark i included the adovbs.inc file
i get this error when i moved the application the staging level that is
The error
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
/apps/hsa/Updatesub.asp, line 67
The code
recordset.bookmark
i am using the find function so in that i have to use the bookmark
i am getting the error in the staging part of my development I checked the
mdac the same pack seems to be there
it seems fine from this end .do i have to use type lib or do i have do some
other changes
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----------------------------------------------------------------------
Subject: Re: error
From: "Roy, Siddarth S" <sroy@b...>
Date: Wed, 12 Jun 2002 09:00:44 -0400
X-Message-Number: 2
I am using the keyset. i think i have to change the code in this i have
do it allover again in a different way
thanx
sid
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Wednesday, June 12, 2002 2:25 AM
To: ASP Databases
Subject: [asp_databases] Re: error
What cursor type are you using? Some cursors (eg adOpenForwardOnly) do
not
support bookmarking (hence the error you are getting)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Roy, Siddarth S" <sroy@b...>
Subject: [asp_databases] error
i am using a db2 database .
the env i am working on
mdac 2.6 , win2k
even the server has the same thing when i work in dev enev no error came
up
in this code
The code is using the recordset book mark i included the adovbs.inc file
i get this error when i moved the application the staging level that is
The error
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
/apps/hsa/Updatesub.asp, line 67
The code
recordset.bookmark
i am using the find function so in that i have to use the bookmark
i am getting the error in the staging part of my development I checked
the
mdac the same pack seems to be there
it seems fine from this end .do i have to use type lib or do i have do
some
other changes
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----------------------------------------------------------------------
Subject: Update Command :: Obtaining SQL Identity Field from new record in
recordser
From: "mike.carlton@b..." <mike.carlton@b...>
Date: Wed, 12 Jun 2002 16:51:23
X-Message-Number: 3
Help! I am adding a new record to the datastore, (data passed from a
form) I then want to obtain the ID of this new record from the datastore.
I am storing the ID in a variable to be used later.
However, each time the code is executed the variable is empty. The code
works fine when using Access as the datastore, but not with SQL server
2000.
Thanks in advance,
Mike Carlton
::::::
Code Below
<!--#include file="connect.asp" -->
<%
'First of all we want to add a new record to the cusotmers table
then we want to obtain the
'new customer id for use in the address table
'Stage 1 :: Customer Table
'V's
Dim ObjRsCustomer, ObjRsAddress, IntCustomerID,
IntAddressID
'Object
Set ObjRsCustomer = Server.CreateObject("ADODB.Recordset")
objRsCustomer.Open "Customers", DcHealth, adOpenDynamic,
adLockPessimistic
'Update the recordset
ObjRsCustomer.AddNew
ObjRsCustomer.Fields("CompanyName") = Request.Form
("CompanyName")
ObjRsCustomer.Fields("ForeName") = Request.Form
("ForeName")
ObjRsCustomer.Fields("Surname") = request.FOrm("surname")
ObjRsCustomer.Fields("EmailAddress") = Request.form
("EmailAddress")
ObjRsCustomer.Fields("Telephone") = Request.form
("telephone")
ObjRsCustomer.Fields("fax") = Request.form("fax")
ObjRsCustomer.Fields("UserCreated") = Session("UsrName")
ObjRsCustomer.Update
'Define the new customer ID to a V
IntCustomerID = ObjRsCustomer.Fields("CustomerID")
'Close Customer Recordset
ObjRsCustomer.Close
Set ObjRsCustomer = Nothing
'Stage 3 :: Address Table
Set ObjRsAddress = Server.CreateObject("ADODB.Recordset")
objRsAddress.open "Addresses", DcHealth, adOpenDynamic,
adLockPessimistic
'Update the Recordset
ObjRsAddress.AddNew
ObjRsAddress.Fields("CustomerID") = IntCustomerID
ObjRsAddress.Fields("ForeName") = Request.form("ForeName")
ObjRsAddress.Fields("Surname") = Request.form("Surname")
ObjRsAddress.Fields("Company") = request.form
("CompanyName")
ObjRsAddress.Fields("Building") = Request.Form("building")
ObjRsAddress.Fields("Street") = Request.form("Street")
ObjRsAddress.Fields("Locality") = Request.form("Locality")
ObjRsAddress.Fields("town") = Request.form("town")
ObjRsAddress.Fields("County") = Request.form("County")
ObjRsAddress.Fields("PostCode") = Request.form("PostCode")
ObjRsAddress.Fields("Country") = Request.form("country")
ObjRsAddress.Fields("Telephone") = Request.form
("telephone")
ObjRsAddress.Fields("Fax") = Request.form("fax")
ObjRsAddress.Fields("DirectTelephone") = Request.form
("DirectTelephone")
ObjRsAddress.Fields("DirectFax") = Request.form
("DirectFax")
ObjRsAddress.Fields("Mobile") = request.form("Mobile")
ObjRsAddress.Fields("EmailAddress") = Request.form
("EmailAddress")
ObjRsAddress.Update
'ObtainAddressID
IntAddressID = ObjRsAddress.Fields("AddressID")
'Close and tidy up
ObjRsAddress.CLose
Set ObjRsAddress = Nothing
'Update the customers info with the HQ Address
Dim MySelectSQL, ObRsHqID
MySelectSQL = "SELECT HqAddressID, CustomerID FROM
Customers WHERE CustomerID = '" & IntCustomerID & "';"
Set ObRsHqID = Server.CreateObject("ADODB.Recordset")
ObRsHQID.Open MySelectSQL, DCHealth
'Check for EOF
If ObRsHQID.EOF Then
'Define error then redirect back to main menu!
Session("Message") = "Could not define HQ address
Line 73. Contact IT on 01608 649 250 Int Customer ID =" & IntCustomerID
& " IntAddressID=" & IntAddressID
ObRsHqID.Close
Set ObRsHqID = Nothing
DcHealth.close
Set DCHealth = Nothing
Response.Redirect "Menu.asp"
Else
'Update the datastore
ObRsHQID.Fields("HQAddressID") = IntAddressID
ObRsHQID.Update
'Close + Tidy up
ObRsHQID.close
Set ObRsHQID = Nothing
End If
DcHealth.Close
Set DCHealth = Nothing
'Redirect to the confirmation page
Session("Message") = "The New Customer Has Been Added To
The DataStore"
Response.Redirect "Menu.asp"
%>
----------------------------------------------------------------------
Subject: MSDE Problem
From: "louis" <yiauko@h...>
Date: Wed, 12 Jun 2002 18:23:52
X-Message-Number: 4
please help me about this problem..i give up already..
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.
/asp/connect.asp, line 29
----------------------------------------------------------------------
Subject: RE: MSDE Problem
From: "Schelling, Michael" <schellim@s...>
Date: Wed, 12 Jun 2002 13:21:06 -0400
X-Message-Number: 5
Louis
Might want to do a http://www.google.com search on 0x80004005. I just did
and it returned all kinds of links.
Mike
-----Original Message-----
From: louis [mailto:yiauko@h...]
Sent: Wednesday, June 12, 2002 2:24 PM
To: ASP Databases
Subject: [asp_databases] MSDE Problem
please help me about this problem..i give up already..
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.
/asp/connect.asp, line 29
----------------------------------------------------------------------
Subject: RE: MSDE Problem
From: "Roy, Siddarth S" <sroy@b...>
Date: Wed, 12 Jun 2002 14:14:07 -0400
X-Message-Number: 6
Where exactly did u get the probelm .if u are using the windows 2000
advanced server then u have give them the rights to it
i suppose it is that way try the windows authentican
thanx
sid
-----Original Message-----
From: louis [mailto:yiauko@h...]
Sent: Wednesday, June 12, 2002 2:24 PM
To: ASP Databases
Subject: [asp_databases] MSDE Problem
please help me about this problem..i give up already..
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.
/asp/connect.asp, line 29
----------------------------------------------------------------------
Subject: Re: MSDE Problem
From: jiwilliams@c...
Date: Wed, 12 Jun 2002 21:21:05
X-Message-Number: 7
Play with your authentications in odbc administration. Try different
settings. Also make sure the SQL server properties match the odbc
properties. I had this problem before. I couldn't figure it out for
anything. It boiled down to the things mentioned above. Hope this helps.
Jimmy
----------------------------------------------------------------------
Subject: Back button coding
From: jiwilliams@c...
Date: Wed, 12 Jun 2002 21:23:59
X-Message-Number: 8
Hi all,
I need to know what coding the back button on the browser is based on.
I want to put the same function or buttton on an asp form. Can anyone help?
Jimmy
----------------------------------------------------------------------
Subject: RE: Back button coding
From: "Huber, Mike" <michael.huber@p...>
Date: Wed, 12 Jun 2002 15:18:47 -0500
X-Message-Number: 9
I think this will do it for you.
<input type="button" value="Back" name="Back" onclick="history.back()">
-----Original Message-----
From: jiwilliams@c... [mailto:jiwilliams@c...]
Sent: Wednesday, June 12, 2002 4:24 PM
To: ASP Databases
Subject: [asp_databases] Back button coding
Hi all,
I need to know what coding the back button on the browser is based on.
I want to put the same function or buttton on an asp form. Can anyone help?
Jimmy
----------------------------------------------------------------------
Subject: RE: MSDE Problem
From: "David James" <David@S...>
Date: Wed, 12 Jun 2002 16:21:51 -0400
X-Message-Number: 10
http://groups.google.com/groups?q=3DLogin+failed+for+user+%27sa%27.+Reaso
n%3A+Not+associated+with+a+trusted+SQL+&ie=3DUTF8&oe=3DUTF8&hl=3Den&btnG=3D
Google+Search
-----Original Message-----
From: Schelling, Michael [mailto:schellim@s...]
Sent: Wednesday, June 12, 2002 1:21 PM
To: ASP Databases
Subject: [asp_databases] RE: MSDE Problem
Louis
Might want to do a http://www.google.com search on 0x80004005. I just
did
and it returned all kinds of links.
Mike
-----Original Message-----
From: louis [mailto:yiauko@h...]
Sent: Wednesday, June 12, 2002 2:24 PM
To: ASP Databases
Subject: [asp_databases] MSDE Problem
please help me about this problem..i give up already..
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.
/asp/connect.asp, line 29
----------------------------------------------------------------------
Subject: Re: Back button coding
From: "CLINTON PARSLEY" <cparsley@m...>
Date: Wed, 12 Jun 2002 13:28:56 -0700
X-Message-Number: 11
This should do the trick for you....
<form>
<input type="button" value="Back" onClick="history.go(-1)" />
</form>
Hi all,
I need to know what coding the back button on the browser is based on.
I want to put the same function or buttton on an asp form. Can anyone help?
Jimmy
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
----------------------------------------------------------------------
Subject: Re: Back button coding
From: jiwilliams@c...
Date: Wed, 12 Jun 2002 21:45:26
X-Message-Number: 12
How about if I want to put it in a table that I've created to look like a
form?
----------------------------------------------------------------------
Subject: Re: Back button coding
From: "CLINTON PARSLEY" <cparsley@m...>
Date: Wed, 12 Jun 2002 14:22:43 -0700
X-Message-Number: 13
Pick a table cell and paste away....
How about if I want to put it in a table that I've created to look like a
form?
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
---
END OF DIGEST
|
|
|
View Cart
