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

2008-05-12 Thread 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,

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

2008-05-12 Thread siddhartha veedaluru
Thanks tim, 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,

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

2008-05-06 Thread siddhartha veedaluru
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