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

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 procedure
'tblCompanySubCategory' failed because 'tblCompanySubCategory' is a table
object.
Message posted via http://www.sqlmonster.com
"L Adam via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8fbaff9acfc64ae38f5473689da09957@.SQLMonster.c om...
> 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.sqlmonster.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.sqlmonster.com
|||"L Adam via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:43509d3988f8454c9af8da35ebbe7f39@.SQLMonster.c om...
> 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.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

odbc + sql problem

Anyone could please help me ?
I have a simple asp program connecting to sql7.0.
I have the system dsn setup already.
After I transfer everything from the old hard disk to new hard disk, I
cannot login through asp program anymore. Below is the error message but I
don't know why it has to do with the iusr account. Thanks a lot. (any image
of setup would be helpful)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'CENTRAL\IUSR_CENTRAL'.So, the error message is that this user:
doesn't exist as a SQL login.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'CENTRAL\IUSR_CENTRAL'.
175671 PRB: 80004005 ConnectionOpen (CreateFile()) Error Accessing SQL
http://support.microsoft.com/?id=175671
307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User
http://support.microsoft.com/?id=307002
176380 How To Use ASP with a SQL Trusted Connection with Guest Account
http://support.microsoft.com/?id=176380
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.