Hey John,

Good to hear from you. I just looked through the last version of back_mssqlserver I was messing with for pyodbc, and did not see any use of it to confirm your theory. Unfortunately I am not familiar enough with python development to offer better insight.

Nah, I wasn't able to migrate or upgrade our roundup instance. Last thing I tried was to drag n drop our Python and roundup folders off the old 2008 server and into a newer 2025 server. I think it served out a working main page with tickets, but links and login functionality were broken. I was spending too much time on it and ultimately had to shift gears to work on other things. But it's still something one of us needs to address at some point. Just not now with other projects going on.

Hope you find the answer to your question. Thanks for checking in!




From:        "John Rouillard" <issues@roundup-tracker.org>
To:        patrick.murray@pha.phila.gov
Date:        04/13/2025 11:17 PM
Subject:        [issue2551394] mssqlserver backend files
Sent by:        issues@roundup-tracker.org

---

CAUTION: This Email is from an EXTERNAL source. Ensure you trust this sender before clicking on any links or attachments.




John Rouillard added the comment:

Hi Randy, not sure if you are still around. I don't see you on IRC.
I had somebody ask about this ticket.

In the irc chat, I mentioned that the dbi module seems to be unused and I though
pyodbc might be able to be used to replace the odbc module imported by back_mssqlserver.

Do you know if my guesses are correct?

Also have you made any progress in moving your roundup instance?

Have a good day.

-- rouilj

----------
nosy: +rouilj

_________________________________________________
Roundup tracker <issues@roundup-tracker.org>
<https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.roundup-2Dtracker.org_issue2551394&d=DwIFaQ&c=pTMmftTp0eOqX5h_B2WLq0DUIZO-1izRe_CcgPLX088&r=Z2rb6s109oq7YRKGmXWSa7Fd4M21eAdFLJ58RP_-x6A&m=i1thdIX00K252HEBn_rehDaetPTCWWPyxUSHQOt_U03OzsVNHgERKMIyfvyrLR_C&s=Zh-vItG9BEUbUeKRtHwzh6MbioX2Znxdqh_Te_nd0g0&e= >
_________________________________________________