•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 427,776 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,725 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 1876 | Replies: 3 | Solved
 |
•
•
Join Date: Oct 2006
Location: South Africa
Posts: 13
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
ASP To Access 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
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
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
post your code that is giving this error
•
•
Join Date: Feb 2007
Posts: 12
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Put the database in access_db folder on your server
make sure your server support access and asp
make sure your server support access and asp
•
•
Join Date: Feb 2008
Posts: 41
Reputation:
Rep Power: 1
Solved Threads: 0
Light Poster
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!!
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!!
|
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- can asp work with mySQL (ASP)
- Basic ASP Access question (ASP)
- No Error, No Insert: ASP to Access (ASP)
- PHP vs ASP... the big ShOwdOwN (IT Technologies and Trends)
- Asp,ms Access,iis (ASP)
- Windows 2000 server not allowing ASP access. (ASP)
- Low bandwidth ASP hosting (Web Hosting Deals)
Other Threads in the ASP Forum
- Previous Thread: selection problem in a month loop
- Next Thread: insert data to Access
