<div>
<div class="content wysiwyg-content">
I am migrating all of my asp pages to aspx everything is going pretty well except for this little snag here 
 
rs.Open(sTable, cn, 2,2) is giving me an error 
 
Exception Details: System.Runtime.InteropServices.COMException: The request for procedure 'Productivity' failed because 'Productivity' is a table object. 
 
 
the code block it is in is as follows 
 
sTable = &quot;[Productivity]&quot; 
cn = CreateObject(&quot;ADODB.Connection&quot;) 
cn.Open(strConn) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
'=====Form======= 
If Len(Request.QueryString(&quot;save&quot;)) &gt;&nbsp;0 Then 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs = Server.CreateObject(&quot;ADODB.Recordset&quot;) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs.Open(sTable, cn,2,2) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs.addnew 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs(&quot;MechanicID&quot;) = MchID 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs(&quot;Score&quot;) = Score 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs(&quot;ScoreRight&quot;) = scoreright 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs(&quot;Per&quot;) = per 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs(&quot;Date&quot;) = myDate 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs(&quot;LocationID&quot;) = SID 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs(&quot;UserID&quot;) = UID 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs.Update &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
rs.close() &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 
that is pretty much it... any ideas? 
 
D--
</div>
</div>

I am migrating all of my asp pages to aspx everything is going pretty well except for this little snag here

rs.Open(sTable, cn, 2,2) is giving me an error

Exception Details: System.Runtime.InteropServices.COMException: The request for procedure 'Productivity' failed because 'Productivity' is a table object.


the code block it is in is as follows

sTable = "[Productivity]"
cn = CreateObject("ADODB.Connection")
cn.Open(strConn)
	
'=====Form=======
If Len(Request.QueryString("save")) > 0 Then
	 rs = Server.CreateObject("ADODB.Recordset")
	rs.Open(sTable, cn,2,2)
	rs.addnew
			rs("MechanicID") = MchID
			rs("Score") = Score
			rs("ScoreRight") = scoreright
			rs("Per") = per
			rs("Date") = myDate
			rs("LocationID") = SID
			rs("UserID") = UID
			rs.Update	
rs.close()	

that is pretty much it... any ideas?

D--

Migrating to ASP.net from ASP Having trouble with rs.open

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.