Feb-19-2020, 11:53 AM
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,
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,
Through a cloudy window,
Kip...
“Progress means getting nearer to the place you want to be. And if you have taken a wrong turn, then to go forward does not get you any nearer.
If you are on the wrong road, progress means doing an about-turn and walking back to the right road; and in that case the man who turns back soonest is the most progressive man.” ― C.S. Lewis
Kip...
“Progress means getting nearer to the place you want to be. And if you have taken a wrong turn, then to go forward does not get you any nearer.
If you are on the wrong road, progress means doing an about-turn and walking back to the right road; and in that case the man who turns back soonest is the most progressive man.” ― C.S. Lewis