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