Python Forum
ODBC iPhone to PC - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: ODBC iPhone to PC (/thread-24553.html)



ODBC iPhone to PC - KipCarter - Feb-19-2020

I am making good progress in my Python crash course! This forum has been extremely helpful in that effort.
I want to expand on what I have learned thus far with the pyodbc module.

It is great to use where the odbc target is on the same machine as the python script that is attempting to query it. However, for the project that brought me into this I need to use an iPhone to gather data and then insert that data in to an MS Access database across the local network infrastructure (intranet).

In my mind, I have designed a simple SMTP relay between the cell phone and the desktop PC housing the Access db. Python is performing these actions, both the phone and pc end, so I have accomplished ‘proof of concept’ to collect the data, transfer it to the PC, and now insert the data into the table as desired.

What is bothering me at this point is that I would really like to eliminate the SMTP relay process and simply perform the insert from the phone on the PC.

I am not looking for code examples, just methodology concepts that can accomplish this. Because this is a large corporate environment the opportunity to introduce utilities outside of the ‘approved tool-set’ is extremely limited, so I want to accomplish this with commonly available modules within Python if I can.

I will appreciate all suggestions.

Thanks,