[python-win32] Create a System DSN which points to a MSSQL Database on Remote Machine

[Tim Golden]

siddhartha veedaluru wrote:
> But when i give user and pass information it is not able to create  the dsn
> It is default local system user name and creating, which fails connecting to
> database.
> 
> i gave the user information as following:
> "SQL Server", SERVER="SQLSVR01",DESCRIPTION="MS SQL Server DSN",
> DSN="MyDSN", DATABASE="Testing",uid="sa",pwd="sysadmin"):
> if uid and pwd is not given then it creates the DSN with logged in user as
> username.

Siddharrtha, the most useful thing you can do at this point is to post
some code, ideally with a traceback if one occurs. I'm finding it a little
difficult to understand what you're doing.

To take this forward, perhaps, the following code fragments use the 
pyodbc [1] module to connect to an MSSQL server with passthrough
authentication and with a specific username / password. I'm not
clear whether you're trying to do the same thing or something else,
but at least it'll provide a starting point for discussion :)

<code>
import pyodbc

def connection (server, database, username="", password="", **kwargs):
  connectors = ["Driver={SQL Server}"]
  connectors.append ("Server=%s" % server)
  connectors.append ("Database=%s" % database)
  if username:
      connectors.append ("UID=%s" % username)
      connectors.append ("PWD=%s" % password)
  else:
      connectors.append ("TrustedConnection=Yes")
  return pyodbc.connect (";".join (connectors), **kwargs)

db1 = connection ("SVR", "DB") # use passthrough authentication
db2 = connection ("SVR", "DB", "sa", "password") # use specific credentials

</code>

[1] http://pyodbc.sourceforge.net/