ODBC insert problems in ASP.NET C#

[Jimbo_Bimbo]

Hi All,
I am having a bit of trouble inserting and updating into an acces database
using the Dreamweaver MX 2004 functions.

It works fine reading, inserting and updating into Oracle and SQL Server but
not Access??

I have the same problem when I tested it in ASP.

Dreamweaver is fully updated and has the correct patches for the .net sp2
problems.

Any help gratefully received.
Cheers

[Paul Whitham TMM]

What specific issue are you having (ie what error message is being
returned).

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Jimbo_Bimbo" <webforumsuser@macromedia.com> wrote in message
news:d4rdug$hfk$1@forums.macromedia.com...

> Hi All,
> I am having a bit of trouble inserting and updating into an acces

database

> using the Dreamweaver MX 2004 functions.
>
> It works fine reading, inserting and updating into Oracle and SQL Server

but

> not Access??
>
> I have the same problem when I tested it in ASP.
>
> Dreamweaver is fully updated and has the correct patches for the .net sp2
> problems.
>
> Any help gratefully received.
> Cheers
>

[Jimbo_Bimbo]

Hi Paul,
I get this error:

System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
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()

There is no sytax error in sql statement it is only a simple insert statement.

Thanks for the help,

Jamie

[Paul Whitham TMM]

Jamie

Syntax errors normally come from the following

1) Having a database field with a reserved name (such as Name, Desc,
Password)
2) Trying to insert a text value into a numeric field

The latter one can happen if a person enters a comma or a dollar sign in the
input field.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Jimbo_Bimbo" <webforumsuser@macromedia.com> wrote in message
news:d565s3$4gm$1@forums.macromedia.com...

> Hi Paul,
> I get this error:
>
> System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
> 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()
>
> There is no sytax error in sql statement it is only a simple insert

statement.

>
> Thanks for the help,
>
> Jamie
>

[Jimbo_Bimbo]

Hi Paul,
Thanks for that I will give it a go,
The thing that confuses me is it works fine with an SQL database and all the
names of the tables and fields are exatcly the same - its just with access -
but it is a valid point.

I will get back to you when I have tested it,

Cheers,
Jamie

[Jimbo_Bimbo]

Hi Paul,
I have sorted the problem - It was a simple security problem with access - I am not used to using access - it is RUBBISH!

Thanks for your help.

Jamie