[python-win32] Create a System DSN which points to a MSSQL Database on remote machine

[Tim Golden]

siddhartha veedaluru wrote:
> Hi,
> 
> I'm trying to create a Sytem DSN which points to a MSSQL Database on remote
> machine.
> 
> i tried using the following code snip in the following link
> http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/414879
> 
> i customized the script according to my requirements and it got created but
> i could not able to access the database.
> 
> Here there the thing is while creating a system DSN manually, we can mention
> the type of authentication we want to connect to
> SQL
> 
> Type of credential,
>       Either through NT username and password OR Sql username password.
> 
> But the code in the link does not support them.

That's what the "TrustedConnection = 'Yes'" thing at the end is doing.

TJG