Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > Technical sections > Languages, Compilers, Interpreters
Register

Reply
 
LinkBack Thread Tools
Old 04.04.2002, 05:56   #1
Младенец
 
Join Date: 03 2002
Location: Yerevan
Posts: 7
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Question Microsoft Jet engine trouble

Please help me if you can!

My ASP database connection doesn't work properly.
table name is "guestbook"
fields are ID, firstName, lastName, e-mail, URL

Dim connect, record
Set con=Server.CreateObject("ADODB.connection")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("guests.mdb")
Set record=Server.CreateObject("ADODB.Recordset")
record.Open "SELECT * FROM guestbook", con
record.AddNew
record("firstName")=firstName
record("lastName")=lastName
record("e-mail")=Request.Form("e-mail")
record("URL")=Request.Form("URL")
record.Update
record.Close
con.Close

IIS gives something like this: Microsoft Jet engine can not find the 'URL' object, check if this object exists or may be its path is incorrect!

Help me if you can !
__________________
Ամեն ինչ կախվածա նրանից թե ինչքան ես դու...
Reply With Quote
Old 04.04.2002, 14:44   #2
Бакалавр
 
Join Date: 03 2002
Location: Detroit, MI, USA
Posts: 482
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Post

I dont' know exactly, what's going on in your case, but, there is a thing, which confuses me (maybe, that's the source of error)
You're executing SELECT statement, which (IMHO), returns read-only recordset. After that, you're trying to modify and update result of SELECT execution. I'm not sure, if Microsoft JET engine supports it or no.
Anyhow, at least it is direction to dig in.
I hope, this will help.

Regards,
Hovik
__________________
Hovhannes Tumanyan,
CISSP
Reply With Quote
Old 05.04.2002, 02:24   #3
Младенец
 
Join Date: 03 2002
Location: Yerevan
Posts: 7
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Talking

Dear Tumanyan

That wasn't the exact code i was using - please see this one -

Dim con, record

Set con=Server.CreateObject("ADODB.connection")

con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("guests.mdb")

Set record=Server.CreateObject("ADODB.Recordset")

record.Open "SELECT * FROM guestbook", con

record.Close
con.Close

see this one doesn't do anything smart, but error message is the same: that microsoft jet engine cannot find the 'URL' or whatever object that is the last field in my guestbook table!

I'm running XP - maybe here what's the problem?
Reply With Quote
Sponsored Links
Reply

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 18:50.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.