SQL & how different databases implement it

Some vaguely structured thoughts on the differences that you see between SQL as implemented by one DBMS and that of another.

22 December 2008

 

ASP error message - OraOLEDB (0x80040E4B) Accessor is not a parameter accessor

Have you received the following error:

Error Type:
OraOLEDB (0x80040E4B)
Accessor is not a parameter accessor.

This is from an ASP application running against an Oracle database. Here is how I fixed this problem in my application:

The problem was due to excessive digits in a number being returned by an Oracle SQL SELECT statement. To fix it, I changed the SQL statement so that it used the Oracle ROUND function to remove some of those digits, e.g.:

change:

SELECT fees / days
FROM timesheet

to:

SELECT ROUND(fees / days, 3)
FROM timesheet

Comments:
informatin of ADO ,method add record database
 
what is mean (Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.)
set str=Request.Form("text1")
set str1=Request.Form("text2")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("db4.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="INSERT INTO Author (Name,LastName) VALUES ("&"'"& str & "'"&","&"'"& str1 & "'"&") "

error >rs.Open sql, conn
 
Post a Comment

Subscribe to Post Comments [Atom]





<< Home

Links

Archives

September 2005   October 2005   December 2005   January 2006   March 2006   May 2006   June 2006   September 2006   May 2007   June 2007   November 2007   December 2007   March 2008   April 2008   December 2008   January 2011  

This page is powered by Blogger. Isn't yours?

Subscribe to Posts [Atom]