Issue is solved...
Hope it will be useful to them who are facing same problem
I have create
DSN,...
open controlpanel -> administrative tools -> ODBC -> System DSN ->
select 'SQL Server' Driver -> Name DSN as 'SQLDSN'
->
select servername/ copy paste my sql server name [problem was here in servername list my servername was not full as in sqlserver so, that i copy-paste it from sql connection window)
-> enter sql server id-pwd
-> select default database
finish and test it!
after test of connection is succeed
in asp...
I used
connection string as below
"DSN = SQLDSN; uid=___ ; pwd=____;"
Happy Coding!
:)