|
Home > Archive > MS SQL Server ODBC > March 2005 > Re: ODBC Driver error '80040e14'
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: ODBC Driver error '80040e14'
|
|
|
|
"L Adam via SQLMonster.com" <forum@SQLMonster.com> wrote in message
news:8fbaff9acfc64ae
38f5473689da09957@SQ
LMonster.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
> 'tblCompanySubCatego
ry' failed because 'tblCompanySubCatego
ry' is a table
> object.
>
> --
> Message posted via http://www.sqlmonster.com
can you paste the sql that created the error?
cheers
lefty
| |
| L Adam via SQLMonster.com 2005-03-30, 7:03 pm |
| 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 " tblCompanySubCategor
y", 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.sqlmonster.com
| |
|
|
"L Adam via SQLMonster.com" <forum@SQLMonster.com> wrote in message
news:43509d3988f8454
c9af8da35ebbe7f39@SQ
LMonster.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 " tblCompanySubCategor
y", 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.sqlmonster.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
|
|
|
|
|