Wrox Programmer Forums
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 11th, 2005, 09:41 AM
Registered User
Join Date: Jul 2005
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...


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!



Old July 28th, 2005, 06:56 PM
Registered User
Join Date: Jul 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to netfed

Can you post the code?

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

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