ODBC Driver error '80040e14'

We are using SQL7 and are experiencing this problem when trying to update
to the database. It is an intermitent problem. Any ideas? The error
code reads:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The request for p
rocedure
'tblCompanySubCategory' failed because 'tblCompanySubCategory' is a table
object.
Message posted via http://www.droptable.com"L Adam via droptable.com" <forum@.droptable.com> wrote in message
news:8fbaff9acfc64ae38f5473689da09957@.SQ
droptable.com...
> We are using SQL7 and are experiencing this problem when trying to update
> to the database. It is an intermitent problem. Any ideas? The error
> code reads:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [Microsoft][ODBC SQL Server Driver][SQL Server]The request for
procedure
> 'tblCompanySubCategory' failed because 'tblCompanySubCategory' is a table
> object.
> --
> Message posted via http://www.droptable.com
can you paste the sql that created the error?
cheers
lefty|||This is the sql code that is causing the error:
response.buffer=true
Dim Rs1, Con1, RedirectString
set Con1 = server.createobject("ADODB.Connection")
Con1.open( "dsn=*****;uid=******" )
set Rs1 = server.createobject("ADODB.recordset")
Rs1.open "tblCompanySubCategory", Con1,3,3
If not isnull(request.form("TheSubCatID")) then
if len(trim(request.form("TheSubCatID"))) then
Rs1.addnew
Rs1("LastAmendedBy") = request.Cookies("***")("UserID")
Rs1("LastAmendedDate") = date()
Rs1("CompanyID") = request.querystring("CompanyID")
Rs1("CatSubCatID") = request.form("TheSubCatID")
Rs1.update
end if
End If
Con1.close
set Con1 = Nothing
set Rs1 = Nothing
RedirectString = "SalesCompanyCategory.asp?CompanyID=" &
request.querystring("CompanyID") & "&method=save"
response.clear
response.redirect RedirectString
response.end
Thoughts?
Message posted via http://www.droptable.com|||"L Adam via droptable.com" <forum@.droptable.com> wrote in message
news:43509d3988f8454c9af8da35ebbe7f39@.SQ
droptable.com...
> This is the sql code that is causing the error:
> response.buffer=true
> Dim Rs1, Con1, RedirectString
> set Con1 = server.createobject("ADODB.Connection")
> Con1.open( "dsn=*****;uid=******" )
> set Rs1 = server.createobject("ADODB.recordset")
> Rs1.open "tblCompanySubCategory", Con1,3,3
> If not isnull(request.form("TheSubCatID")) then
> if len(trim(request.form("TheSubCatID"))) then
> Rs1.addnew
> Rs1("LastAmendedBy") = request.Cookies("***")("UserID")
> Rs1("LastAmendedDate") = date()
> Rs1("CompanyID") = request.querystring("CompanyID")
> Rs1("CatSubCatID") = request.form("TheSubCatID")
> Rs1.update
> end if
> End If
> Con1.close
> set Con1 = Nothing
> set Rs1 = Nothing
> RedirectString = "SalesCompanyCategory.asp?CompanyID=" &
> request.querystring("CompanyID") & "&method=save"
> response.clear
> response.redirect RedirectString
> response.end
> Thoughts?
> --
> Message posted via http://www.droptable.com
sorry but i haven't a clue.
Although why dont you watch the actual sql being sent to sql server with the
profiler, then compare a working sql to the sql that gave you the error.
That should show you were the problem lies
you could change it to a straight sql = "insert into etc.etc"
Best Regards
Lefty