New topic: ODBCPlugin.rbx RS 2012 2.1 - Did Something Changed?
<http://forums.realsoftware.com/viewtopic.php?t=47107> Page 1 of 1 [ 5 posts ] Previous topic | Next topic Author Message Sky Stream Post subject: ODBCPlugin.rbx RS 2012 2.1 - Did Something Changed?Posted: Wed Feb 27, 2013 10:25 pm Joined: Sun Nov 23, 2008 12:27 am Posts: 390 Location: New Jersey In a reporting app that I wrote a while ago which connects to MS SQL 2008 R2 using ODBC, it would run a number of store procedures on the database and then display the results in the app example code: dim db as new ODBCDatabase dim rs as recordset db.DataSource = Window1.dsnPM.Text db.UserName = "username" db.Password = "password" db.Timeout = -1 if db.Connect then rs = db.SQLSelect("exec P_SP_REPORT") break ' check to see if RS has data. if db.Error then MsgBox db.ErrorMessage end if end if In RS 2011 4.3, this worked great and the store procedure would return the desire records. when using RS 2012 2.1 and the same code, the record set is empty. did something change in RS 2012 2.1 ODBCPlugin? _________________ - Rich Top npalardy Post subject: Re: ODBCPlugin.rbx RS 2012 2.1 - Did Something Changed?Posted: Wed Feb 27, 2013 10:40 pm Real Software Engineer Joined: Sat Dec 24, 2005 8:18 pm Posts: 7744 Location: Canada, Alberta, Near Red Deer You can always read the release notes at http://docs.realsoftware.com/index.php/ ... io_Changes _________________ Norman Palardy (Real Software) ââââââââââââââââââââââââââââââââââââââââââââââââââ Real Studio Developer Conference - April 23 - 26, 2013 http://www.realsoftware.com/community/realworld.php Top Sky Stream Post subject: Re: ODBCPlugin.rbx RS 2012 2.1 - Did Something Changed?Posted: Wed Feb 27, 2013 10:54 pm Joined: Sun Nov 23, 2008 12:27 am Posts: 390 Location: New Jersey Thank you Norm. looking through a number of changes, I saw these: FIX 18347 Database: Extensive ODBC work done on text fields (and unicode text fields). FIX 18026 Database: Extensive ODBC work was done to improve Unicode support. ---- I guess my question is.. anyway for me to regain previous functionality when using 2012 2.1? _________________ - Rich Top npalardy Post subject: Re: ODBCPlugin.rbx RS 2012 2.1 - Did Something Changed?Posted: Wed Feb 27, 2013 11:21 pm Real Software Engineer Joined: Sat Dec 24, 2005 8:18 pm Posts: 7744 Location: Canada, Alberta, Near Red Deer You could try copying the old plugin to 2012r2.1 and see if it works I dont recall what other changes got made for R2 and whether that would preclude this from working. Dont think there were any _________________ Norman Palardy (Real Software) ââââââââââââââââââââââââââââââââââââââââââââââââââ Real Studio Developer Conference - April 23 - 26, 2013 http://www.realsoftware.com/community/realworld.php Top Sky Stream Post subject: Re: ODBCPlugin.rbx RS 2012 2.1 - Did Something Changed?Posted: Wed Feb 27, 2013 11:30 pm Joined: Sun Nov 23, 2008 12:27 am Posts: 390 Location: New Jersey npalardy wrote:You could try copying the old plugin to 2012r2.1 and see if it works I dont recall what other changes got made for R2 and whether that would preclude this from working. Dont think there were any I just gave that a try and it did work... thank you Norm for the suggestion. just curious if anyone who has access to MS SQL could create a simple stored procedure create procedure P_TEST as select * from SOME_TABLE_WITH_DATA then try to return the output of the store procedure to a recordset using 2012 2.1? _________________ - Rich Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 5 posts ]
-- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
