C#, CGI and databases

[john tindell]

hey, im using C# to write to databases, i can do it though a normal exe normal but when i try and do it though a web page cgi and stuff, it just comes up with an error

System.Data.OleDb.OleDbException: Operation must use an updateable query.

[Cander]

it might be that the database is read only and/or the server is not setup to use an access database...


..Im assuming you are using an access database..

[john tindell]

im using an access database. i can read write and do every thing to it normaly. but when i try to do it though my server it doesnt work? do i have to set the server up to let C# write though the server, coz it can read from it, but it can write?

[Cander]

is this server remote...or yours?

[john tindell]

yer its hosted on my own computer and im running wun2k SP2

[Cander]

make sure that your web application virtual directory is set up with write permissions.

[john tindell]

ypu the persmission are set to read, write and the execute permission are set to scripts and exectuables.

[Cander]

hmm..well I am out of ideas and am about to leave work..If I come up with anything tonight, ill let you know.

[john tindell]

thanks any way

[joan_fl]

What is the error your getting?

[john tindell]

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.

its not the code, because ive tryed it using VB asp and none of them will work when i try to write it though my webserver?

[joan_fl]

Hmm it should be writing some error to the browser..? Does it not display anything?

[john tindell]

sorry, it displays that in the browser with some other stuff, but when i run it from a folder normaly theres no problems? could it be something with IIS?

[abhijit]

Send me your code and db I will try to test it over here.

rgds,
abhijit

[john tindell]

ive sorted it out now it was something to do with the IIS user config, they didn't have the access rights.


thanks

[toto]

Hey John,

Could you perhaps post the code your using to connect to the database? It seems like it might do what i need(to mysql).

Thanks,
-toto

[john tindell]

i used mdb, and it was compiled to a exe

using System.Data.OleDb;
class zzz
{
public static void Main()
{
try
{
OleDbConnection s;
s = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\\c#\\myDB.mdb");
s.Open();
OleDbCommand c;
string t;
t=System.Environment.GetEnvironmentVariable("QUERY_STRING");
//t = "aa=john&bb=tindell";
string [] u;
char [] v = new char[2];
v[0] = '=';
v[1] = '&';
u = t.Split(v);
string f1,f2,f3;
f1 = u[1].Replace('+',' ');
f2 = u[3].Replace('+',' ');
f3 = "insert into bbb values('" + f1 + "','" + f2 + "')";
System.Console.WriteLine("Content-Type:text/html\n");
System.Console.WriteLine(f3);
c=new OleDbCommand(f3,s);
c.ExecuteNonQuery();
}
catch(System.Exception e)
{
System.Console.WriteLine(e.ToString());
}
}
}

[schizo]

hey, do you know how to handle a file upload?