Now, I create ODBC of system i access software and config finished
But, I can not get data form database on System i for show
Souce code as below. (It connected to ODBC but can not get data for show)
<% ConnectionString= "Driver={iSeries Access ODBC Driver}; System=10.230.1.32; UID=PCS; PWD=PCS;" set con = Server.CreateObject("ADODB.Connection") con.open(ConnectionString)
Set rs = Server.CreateObject("ADODB.Recordset")
on error resume next
set rs=server.CreateObject("adodb.recordset") sql="select * from KORAKOTLIB.QRPGSRC" rs.open sql,conn,1,3 if err.number<> 0 then response.write err.Description&"<br>" response.write err.source&"<br>" response.write err.number else response.write "succeed" end if
on error goto 0 %>
On run it display error : Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. ADODB.Recordset 3001
Please support me for rolve this problme
if nay question or not clear, please post message in this borad..
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 2  Replies