I was trying to Import datatable from Sql Server in QTP but
while creating Data Source for Sql Server with
option 'window NT authentication using the Network login ID" it shows following error:
SQL Server Error : 11001
[Microsoft][oDBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).Connection Failed:
Sql Server Error : 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Soclets] Specified SQL Server not found
However SQL Server does work absolutely fine when executed SQL Statement independently.
Does anybody know about this error & its possible solution
Or would you suggest me to see Database guy?
I've done a few things with ODBC connections outside of QTP and it's always trail and error, as the error messages spit out are never really that helpful. In the past, I used this link in setting up ODBC conncections (I don't do it often and I forget some steps)