Member Avatar for 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:

  • 4 Contributors
  • 3 Replies
  • 108 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by zanzo
Member Avatar for campkev

post your code that is giving this error

Member Avatar for jenny4u

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

Member Avatar for 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!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.