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 failed
Driver's SQLSetConnectAttr failed ERROR

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

post your code that is giving this error

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

I do have a problem with access...

this is my code:

var connection= new ActiveXObject("ADODB.Connection");
connection.ConnectionString = "Data Source=" +Server.MapPath("/database/Training11.mdb");

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



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??