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.

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

This question has already been answered. Start a new discussion instead.