send to database not available

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

send to database not available

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> send to database not available

Page: [1]


Topic Starter Posts: 49 From: Canada, eh? Status: offline	send to database not available - 3/27/2001 16:56:00 I have a DRW that returns some records, and I've also added in some fields of my own - all of which I want to send to a new database. But in my form properties I cannot choose Send To Database. Why is this, and how can I manually add in the records to this database myself? I'm not TOO afraid of using ASP....Spooky!! Thanks

Topic Starter

Posts: 49
From: Canada, eh?
Status: offline

RE: send to database not available - 3/27/2001 17:20:00

Here is what I've done with my ASP, I'm getting an error message of

Microsoft VBScript runtime error '800a01a8'

Object required: 'DRIVER={Microsoft Ac'

/Lobby_Options/Thank_You.asp, line 10

My ASP:

<%
LobbyItemsDSN = Application("LobbyItems_ConnectionString")
LobbyItemsDSN.Open
Set ItemsRS = Application("LobbyItems_RecordSet")
ItemsRS.AddNew
ItemsRS ("ProdID") = Request("ProdID")
ItemsRS ("Name") = Request("Name")
ItemsRS ("Description") = Request("Description")
ItemsRS ("Price") = Request("Price")
ItemsRS ("SalePrice") = Request("SalePrice")
ItemsRS ("WhichCategory") = Request("WhichCategory")
ItemsRS ("Image") = Request("Image")
ItemsRS.Update
%>

(in reply to Topic Starter)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: send to database not available - 3/27/2001 23:12:00 Is that the full script? Its not DRW is it? Whats this : Set ItemsRS = Application("LobbyItems_RecordSet") ? (in reply to Topic Starter)


Topic Starter Posts: 49 From: Canada, eh? Status: offline	RE: send to database not available - 3/27/2001 23:49:00 Hey Spooky... I've just made a plain page to add the record in my database, using the info passed by the form. I know from ASP that a connection has to be made, and then in order to update it has be turned into a RecordSet. I read your topic on using FP's connections, but I was kind of confused as to what that connection actually did. I just want to add the record to my database using the fields mentioned in my 2nd post... (in reply to Topic Starter)

Spooky

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: send to database not available - 3/28/2001 20:34:00

Try this :
(notice the ado constants file)

<%
sDSN = Application("LobbyItems_ConnectionString")

Set ItemRs = Server.CreateObject("ADODB.RecordSet")
ItemRs.Open "Table", sDSN, adOpenKeySet, adLockPessimistic, adCmdTable

ItemsRS.AddNew
ItemsRS ("ProdID") = Request("ProdID")
ItemsRS ("Name") = Request("Name")
ItemsRS ("Description") = Request("Description")
ItemsRS ("Price") = Request("Price")
ItemsRS ("SalePrice") = Request("SalePrice")
ItemsRS ("WhichCategory") = Request("WhichCategory")
ItemsRS ("Image") = Request("Image")
ItemsRS.Update

ItemRs.close
Set ItemRs = Nothing

(in reply to Topic Starter)