ASP To Access

[Goitse]

Hi Guys

I am a beginner in ASP and Access and need some help.
I have a database and an ASP page that I need to connect together.
The only problem is that I get an error message saying- Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedDriver's SQLSetConnectAttr failed ERROR

If someone has any solution, please help me as soon as possible.
Thanks
:sad:

[campkev]

post your code that is giving this error

[jenny4u]

Put the database in access_db folder on your server
make sure your server support access and asp

[zanzo]

helllo,
I do have a problem with access...

this is my code:
<%

var connection= new ActiveXObject("ADODB.Connection");
connection.Provider="Microsoft.Jet.OLEDB.4.0";
connection.ConnectionString = "Data Source=" +Server.MapPath("/database/Training11.mdb");
connection.Open;

var SQL = "INSERT INTO User (FirstName, MiddleName, LastName) VALUES ('lolo', 'keymo', 'rub')";

connection.Execute(SQL);
connection.Close();

%>

And i do get this error message:

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/testy.asp, line 16

so how could i solve this problem??
do i have some problem in the insert query??
help!!