Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 11th, 2005, 09:41 AM
Registered User
 
Join Date: Jul 2005
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database connection error. asp.net/dreamw/access

I posted this is in the wrong forum before (twice!)... sorry!

Here's the message...

Hello,

I'm very new to asp.net and web programming in general but I've made some progress in the last few days but am currently struggling with an error I cant get past.

I'm using Windows XP and Dreamweaver. I've got an MS Access database and I've created the connection to it in Dreamweaver successfully. I'm using the ASP.net VB option.

In Dreamweaver I've made a couple of pages and in one of them I've added a dataview object (sorry if my terminology isnt correct). I've opened the page in IE and it's worked fine (displayed all the records from the database table).

However, when I added a 'insert record' object it prompts me to enter the new record but then I get this error...

System.Data.OleDb.OleDbException: Operation must use an updateable query.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()


I've trawled the forums and mostly they mention read/write privileges. I'm not exactly sure how to add these (or if indeed this is the problem) but this is what I've done;

control panel - administrative tools - Internet Information Services

added ticks in read and write to all the folders. it was set to 'scripts only' which i've heard is correct.

I've also tried to make the database not read only and the folder it's in. I've noticed that the read only 'tick' has a habit of returning though.

I tried for a few hours yesterday to get past this prob, any help would be appreciated!

thanks

rich


Reply With Quote
  #2 (permalink)  
Old July 28th, 2005, 06:56 PM
Registered User
 
Join Date: Jul 2005
Location: oslo, , Norway.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to netfed
Default

Can you post the code?
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection to Access Database in .Net KarthikR BOOK: ASP.NET Website Programming Problem-Design-Solution 1 January 16th, 2007 11:56 AM
Database Connection Problem with ASP.NET fukai100 Classic ASP Databases 2 August 13th, 2004 12:12 PM
Database Connection Problem with ASP.NET fukai100 SQL Server ASP 1 August 12th, 2004 07:37 PM
connection to Database. ASP, Dreamweaver, Access CrazyCanuck Classic ASP Basics 2 July 4th, 2004 09:12 PM
ASP.NET database connection MySQL socoolbrewster ASP.NET 1.0 and 1.1 Basics 3 November 21st, 2003 07:12 PM



All times are GMT -4. The time now is 11:19 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.