John Gill
2014-09-22 20:44:05 UTC
I just spend a frustrating afternoon trying to connect to SQL Server(s) with pymssql.
The issue was I wanted to use windows authentication rather than supply username and password in the code.
After getting no joy and lots of googling I realized I can just do:
import clr
clr.AddReference('System.Data')
from System.Data.SqlClient import SqlConnection
Sure enough this works a treat. I need to remember how powerful pythondotnet is and make sure I use it more.
Meanwhile, I am wondering if anyone has tried to wrap this stuff up to produce a standard DB-API interface to SQL Server using pythondotnet and SqlConnection?
If not, anyone else out there interested in this?
John
This communication and any attachments contain information which is confidential and may also be legally privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of disclosure, distribution, copying, printing or use of this communication or the information in it or in any attachments is strictly prohibited and may be unlawful. If you have received this communication in error, please return it with the title "received in error" to ***@tokiomillennium.com and then permanently delete the email and any attachments from your system.
E-mail communications cannot be guaranteed to be secure or error free, as information could be intercepted, corrupted, amended, lost, destroyed, arrive late or incomplete, or contain viruses. It is the recipient's responsibility to ensure that e-mail transmissions and any attachments are virus free. We do not accept liability for any damages or other consequences caused by information that is intercepted, corrupted, amended, lost, destroyed, arrives late or incomplete or contains viruses.
******************************************
The issue was I wanted to use windows authentication rather than supply username and password in the code.
After getting no joy and lots of googling I realized I can just do:
import clr
clr.AddReference('System.Data')
from System.Data.SqlClient import SqlConnection
Sure enough this works a treat. I need to remember how powerful pythondotnet is and make sure I use it more.
Meanwhile, I am wondering if anyone has tried to wrap this stuff up to produce a standard DB-API interface to SQL Server using pythondotnet and SqlConnection?
If not, anyone else out there interested in this?
John
This communication and any attachments contain information which is confidential and may also be legally privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of disclosure, distribution, copying, printing or use of this communication or the information in it or in any attachments is strictly prohibited and may be unlawful. If you have received this communication in error, please return it with the title "received in error" to ***@tokiomillennium.com and then permanently delete the email and any attachments from your system.
E-mail communications cannot be guaranteed to be secure or error free, as information could be intercepted, corrupted, amended, lost, destroyed, arrive late or incomplete, or contain viruses. It is the recipient's responsibility to ensure that e-mail transmissions and any attachments are virus free. We do not accept liability for any damages or other consequences caused by information that is intercepted, corrupted, amended, lost, destroyed, arrives late or incomplete or contains viruses.
******************************************