p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

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


  Return to Index