error -2147217887 odbc to an as400

This topic is locked

error -2147217887 odbc to an as400	8/21/2007 2:26:34 PM
PHPRunner General questions
E edgarv author I created an odbc to my as400 I can see that my odbc is working because if I try to see the data from an access db I can import or link to it. but when I try to use ASPRUNNER PRO 5.0 it gives me the following erro Technical information Error number -2147217887 Error description ODBC driver does not support the requested properties. I try taking out the following from the commonfunctions.asp page Function AddTop(strSQL, n) Dim tstr, ind1 tstr = UCase(strSQL) ind1 = InStr(tstr, "SELECT") AddTop = Mid(strSQL, 1, ind1 + 6) & " top " & n & Mid(strSQL, ind1 + 6) End Function but then I got an error 13 any ideas of what I might try? On a side note I have an old copy of asprunner standard edition and if I build my page with that one it works I just have to take the brackets out []


F	frocco 8/21/2007
	AS400 does not support the top keyword to limit records. After addTop strSQL += "FETCH FIRST " + n + " RECORDS ONLY" HTH Frank I created an odbc to my as400 I can see that my odbc is working because if I try to see the data from an access db I can import or link to it. but when I try to use ASPRUNNER PRO 5.0 it gives me the following erro Technical information Error number -2147217887 Error description ODBC driver does not support the requested properties. I try taking out the following from the commonfunctions.asp page Function AddTop(strSQL, n) Dim tstr, ind1 tstr = UCase(strSQL) ind1 = InStr(tstr, "SELECT") AddTop = Mid(strSQL, 1, ind1 + 6) & " top " & n & Mid(strSQL, ind1 + 6) End Function but then I got an error 13 any ideas of what I might try? On a side note I have an old copy of asprunner standard edition and if I build my page with that one it works I just have to take the brackets out []