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
[email protected] 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.
******************************************
_________________________________________________
Python.NET mailing list - [email protected]
https://mail.python.org/mailman/listinfo/pythondotnet
