ASP.NET Access Update Issue

[Matthew David]

I have an ASP.NET application that is running using Access. It works fine on
my desk top. When I move it to another computer it will run fine with the
exception that I can not update any data. Any one have any ideas why this
might happen?

I get a cryptic Ole.Db error.

--
Matthew David
PH: 920.475.2972
FAX: 775.239.8171
[email]mdavid@matthewdavid.ws[/email]

New Books at [url]http://www.cafepress.com/matthewdavid[/url] on Flash Rich Internet
Applications

[Julian Roberts]

In what way is the error message cryptic?

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Bob]

>I have an ASP.NET application that is running using Access. It works fine

>on
> my desk top. When I move it to another computer it will run fine with the
> exception that I can not update any data. Any one have any ideas why this
> might happen?

Database permission issue perhaps?

[Matthew David]

The database is fine. I have it working on one machine just A-OK. I then
copy and move the the same database to another machine and I and read data
just fine, I simply can not edit or update any data. I have checked to make
sure that the database is not read only. Any help is really needed on this
issue.

Cheers,
MD

"Bob" <no@mail.com> wrote in message
news:d3664m$7ce$1@forums.macromedia.com...

> >I have an ASP.NET application that is running using Access. It works fine
> >on
> > my desk top. When I move it to another computer it will run fine with

the

> > exception that I can not update any data. Any one have any ideas why

this

> > might happen?

>
> Database permission issue perhaps?
>
>

[Matthew David]

This the problem and resolution from MM:

Error when previewing .Net pages: "The .Net Data OLE DB
Provider(System.Data.OleDb)..."
Issue
When previewing a .NET page in a browser the following error is received:



System.ArgumentException: The .Net Data OLE DB
Provider(System.Data.OleDb) does not support the MSDASQL Provider, Microsoft
OLE DB Provider for ODBC Drivers.
at
System.Data.OleDb.OleDbConnection.ValidateConnecti onString(Hashtable
hashtable, String connectionString)
at System.Data.OleDb.OleDbConnection.set_ConnectionSt ring(String
value)
at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
at DreamweaverCtrls.DataSet.DoInit()

Reason
This error occurs when the provider "Microsoft OLE DB Provider for ODBC
Drivers" is selected as the driver when creating a connection within
Dreamweaver MX. This provider, like all others, requires a very specific set
of parameters formatted in a specific way. Currently, the connection code
Dreamweaver MX writes does not work with this Microsoft OLE DB provider.

Note: This error will only appear once when you preview the page in a
browser or view Live Data. All tests through the Dreamweaver MX document
window will complete successfully, and it will appear that you are able to
generate a connection and a Dataset.

Solution
To avoid the error use any other provider. A complete list of available
providers is available by creating an OLE DB connection and clicking the
Build button.

Last updated: June 10, 2002
Easy Link this TechNote [url]http://www.macromedia.com/go/tn_16303[/url]


"Bob" <no@mail.com> wrote in message
news:d3664m$7ce$1@forums.macromedia.com...

> >I have an ASP.NET application that is running using Access. It works fine
> >on
> > my desk top. When I move it to another computer it will run fine with

the

> > exception that I can not update any data. Any one have any ideas why

this

> > might happen?

>
> Database permission issue perhaps?
>
>

[Matthew David]

OK, I read some more and this is the problem I am having from MM techNet.
The only challenge I have is that this solution works fine on my test
mahcine but not on the remote machine. What gives?

"The INSERT INTO statement contains the following unknown field name:"

Issue
After applying the "Insert Record" server behavior, attempts to insert a new
record into a database fail and the following error appears:

"The INSERT INTO statement contains the following unknown field name:"

Reason This error typically results from one or more of the following
problems with the name of a field, object, or variable within a database:
Using a "reserved word" as a name. Most databases have a set of "reserved
words" which have meaning to the database engine because they may be used to
identify built-in functions or keywords. For example, "DATE" is a reserved
word and cannot be used for column names in the database.
Special characters in the name. Examples of special characters
include:
. / * : ! # & - ?

A space in the column name.
A column name starts with a numeric character, such as 2products
The error can also occur when an Input Mask is defined for an object
in the database, and the data being inserted does not conform to the mask.

Solution Avoid using reserved words such as "date", "name", "select",
"where" and "level" when specifying field names in your database. Also
eliminate spaces and special characters.

Please refer to the links below for a comprehensive list of reserved words
associated with the following popular databases:

Microsoft Access


"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d362g5$1o4$1@forums.macromedia.com...

> In what way is the error message cryptic?
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>

[Julian Roberts]

It doesn't neccessarily follow that the same code and and files will work
the same on 2 different machines. Depends what the error is. My guess is
that it's a permissions related error.

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Matthew David]

Yes, I thought that too. I was thinking that the database did not have write
access. But I double checked and it does, unless it can be switch off
somewhere else.

Any ideas?
"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d367n9$9u2$1@forums.macromedia.com...

> It doesn't neccessarily follow that the same code and and files will work
> the same on 2 different machines. Depends what the error is. My guess is
> that it's a permissions related error.
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>

[Julian Roberts]

You need to put Machinename_IUSR permissions on the database folder on the
server

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Matthew David]

That might just work. Brilliant!
"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d369mf$cr6$1@forums.macromedia.com...

> You need to put Machinename_IUSR permissions on the database folder on the
> server
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>

[Julian Roberts]

I've an article that outlines the issues

[url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=56[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Matthew David]

I just updated the security. Turns out that it was a stand alone machine and
I needed to allow the directory to be shared.

Thanks for you help.
"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d36e2l$j5p$1@forums.macromedia.com...

> I've an article that outlines the issues
>
> [url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=56[/url]
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>