Microsoft OLE DB Provider for SQL Server 错误 '80040e37'
来源:百度知道 编辑:UC知道 时间:2024/06/04 13:38:05
Microsoft OLE DB Provider for SQL Server 错误 '80040e37'
对象名 'pH_Job_Base' 无效。
/Person/Per_Search_New.asp,行 11
<%
Dim SQL,Rs
Dim JobClass,Area,PublishDate,Key,KeyClass
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time
SQL = "Select j.JobId,j.Comid,j.JobName,j.Work_Area,j.Work_City,j.Edus,j.Deal,j.Number,j.Require,j.LastUpdate_Time,c.CompanyName,c.Properity,c.Workers From [pH_Job_Base] As j Inner Join [pH_Company_Base] As c On j.Comid=c.Comid Where c.Flag=1 And Len(j.JobName)>0 And j.JobFlag=1 And DateDiff(d,j.End_Date,GetDate())<=0 Order By j.LastUpdate_Time Desc"
Set Rs = Server.CreateObject("ADODB.Recordset")
11行 Rs.open SQL,Conn,1,1
12行 Rs.Pagesize = 20
Psize = Rs.PageSize
PCount = Rs.PageCount
RCount = Rs.RecordCount
怎么解决?
对象名 'pH_Job_Base' 无效。
/Person/Per_Search_New.asp,行 11
<%
Dim SQL,Rs
Dim JobClass,Area,PublishDate,Key,KeyClass
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time
SQL = "Select j.JobId,j.Comid,j.JobName,j.Work_Area,j.Work_City,j.Edus,j.Deal,j.Number,j.Require,j.LastUpdate_Time,c.CompanyName,c.Properity,c.Workers From [pH_Job_Base] As j Inner Join [pH_Company_Base] As c On j.Comid=c.Comid Where c.Flag=1 And Len(j.JobName)>0 And j.JobFlag=1 And DateDiff(d,j.End_Date,GetDate())<=0 Order By j.LastUpdate_Time Desc"
Set Rs = Server.CreateObject("ADODB.Recordset")
11行 Rs.open SQL,Conn,1,1
12行 Rs.Pagesize = 20
Psize = Rs.PageSize
PCount = Rs.PageCount
RCount = Rs.RecordCount
怎么解决?
我估计是你没有加上表的全名,。比如加上表的所有者 如dbo.table
pH_Job_Base为数据库表名
先确认数据库中有该表
PH_Job_Base这个表名可能和你数据库中的表名不一致
引用全路径
对象名 'pH_Job_Base' 无效,引用全路径
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC Microsoft Access Driver] ?
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F)
microsoft ole db provider for sql server 错误‘ 80004005’
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
Microsoft OLE DB Provider for SQL Server (0x80004005)
Microsoft OLE DB Provider for SQL Server (0x80040E14)错误