OdbcConnection & M$ Access

[naeems]

Can anyone take a look at my C# code i'm using to connect to a M$ Access database and tell me what is wrong.

I'm getting the following error:
ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

and the code has been attached.

I keep getting an email back containing the above exception.

[WhiskyFudge]

Not quite sure whats generating that error but it could be possibly:

command.CommandType = CommandType.StoredProcedure;

needs to be:

command.CommandType = CommandType.Text;

Also does your email errors work? If my memory servers me correct localhost will not work for the SMTPServer, you need to use mail.yourdomain.com.

Hope that helps

[naeems]

using localhost definately works! I'm receiving email with the error report.

I've just tried the CommandType.Text and still get the same results. Any more ideas?

[WhiskyFudge]

Try replacing:

command.CommandText = "INSERT INTO Visitor(Referer, Browser) VALUES(@Referer, @Browser);";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Referer", (Request.UrlReferrer == null ? "none" : Request.UrlReferrer.ToString()));
command.Parameters.Add("@Browser", Request.UserAgent);

with:

command.CommandText = "INSERT INTO Visitor(Referer, Browser) VALUES(" + (Request.UrlReferrer == null ? "none" : Request.UrlReferrer.ToString()) + "," + Request.UserAgent + ");";
command.CommandType = CommandType.Text;

[naeems]

OK, so I replaced the original code with the following:

OdbcConnection connection = new OdbcConnection(AppSettings.DbConn);
OdbcCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO Visitor(Referer, Browser) VALUES('";
command.CommandText += (Request.UrlReferrer == null ? "none" : Request.UrlReferrer.ToString());
command.CommandText += "', '" + Request.UserAgent + "');";
command.CommandType = CommandType.Text;

Now i'm getting "Operation must use an updateable query".

[naeems]

If I use a OleDb connection object with an OleDbCommand, can I still use the database in the {root}/db?

If so, what will the path to the database be?

[Jacob]

The probable reason you would be getting 'Operation must use an updateable query' is because the folder you have the database in does not have correct permissions. The /db has the correct permissions already and is much more secure than having the database in the wwwroot somewhere.

The absolute path to the /db is:

d:\domains\mydomain.com\db

Hope that helps, post back if you have any further queries.

Regards,

Jacob