ADO .NET and Excel ...

[Guest]

Hi

Frankly speaking, what ever one says, Microsoft technologies will always
remain problem-matic.. specially with versions... they don have seamless
integration. Deployment is always always an issue. But I still love .NET!!
Anyway folks, my problem goes like this...

I am reading and updating excel sheet using ADO .NET.

Everything is working fine on machine, but on server it is all messing up...

I connect to sheet using the string called...

Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel
8.0;HDR=YES;'

But whenver I try to execute insert command, following error occurs...

Operation must use an updateable query.Microsoft JET Database Engine at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at MyPledge.ClientPaymentData.Button1_Click(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\Web1\Data.aspx.vb:line 74


I will highly appreciate if someone help me... !!!


eff_kay

 

[Miha Markic [MVP C#]]

Nice of yout to frankly speak.
Is this an aspnet application?

 

[Guest]

yes, offcource...

Nice of yout to frankly speak.
Is this an aspnet application?

 

[Miha Markic [MVP C#]]

Then, most probably, your aspnet local windows account (NETWORK SERVICE on
Windows 2003) has no NTFS privileges on mdb file and the folder where it
resides.

 

[Paul Clement]

On Sun, 5 Dec 2004 15:46:36 +0100, "Miha Markic [MVP C#]" <miha at rthand com> wrote:

¤ Then, most probably, your aspnet local windows account (NETWORK SERVICE on
¤ Windows 2003) has no NTFS privileges on mdb file and the folder where it
¤ resides.

I think you meant "xls" and not "mdb".


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[xbmzaybx]

http://www.ardice.com/Computers/Programming/Databases/ADO/ADO.NET/

 

[Miha Markic [MVP C#]]

Yes
Thanks for correction - here is such a big amount of similar problems
(asp.net and access, but you know this already, do you) that those words
were imprinted into my fingers

 

[Paul Clement]

On Mon, 6 Dec 2004 18:06:16 +0100, "Miha Markic [MVP C#]" <miha at rthand com> wrote:

¤ Yes
¤ Thanks for correction - here is such a big amount of similar problems
¤ (asp.net and access, but you know this already, do you) that those words
¤ were imprinted into my fingers

Yup. The error doesn't change under Jet regardless of which ISAM you are using.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Cor Ligthert]

Paul,

In the dotnet general newsgroup is a typical question for you.

problem running net application from shared drive
It is about DAO

Maybe you can have a look,

Cor