SQL Server - Unable to create DSN - Asked By Ramya M. on 09-Oct-14 09:26 AM

I m using Visual Studio 2008 (C# .Net) for my project.. and i m using SQL Server 2005 as DataBase....

i m trying to create user DSN.. but i m getting the below error....

first, i will explain u the steps i m follwoing to create the DSN...

control panel==>
    Administrative Tools==>
      Data Sources(ODBC)==>
       in 'ODBC Data Source Administrator' Window, go to Add...
 
then i m selecting SQL Server==>
                     Finish.
then i will give the DSN Name as Sal1 and i will select the server name as '.\sqlexpress' ==>Next in next window, i m selecting 'With Window NT Authentication using the network login id' Radiobutton
and i m selecting the 'Connect to SQL Server to obtain default settings for the additional configuration options' checkbox.... Till here it is working fine... but when i click 'Next' button, i m getting the below error....

connection failed:
SQL State:'01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection open(Connect( )).
Connection failed:
SQL State:'08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

Note:  i m getting the same error for already created DSN which i was using for some othr project...  befor this DSN was working fine... but now if i select this DSN and if i give 'Configure'. i will get the similar error:

connection failed:
SQL State:'01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection open(Connect( )).
Connection failed:
SQL State:'08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

 
 

reply - Binny ch replied to Ramya M. on 16-Dec-08 06:35 AM

Try it this way:
control panel==>
    Administrative Tools==>
        Data Sources(ODBC)==>
          System dsn==> Add===>Sqlnative===>
           
Enter the datasource-->Server---->Next-->
Finally click Test connection

You can use an OLE DB provider to communicate - Venkat K replied to Ramya M. on 09-Oct-14 09:26 AM

with your database. Creating a direct database-specific OLE DB connection can improve the speed of your connection by eliminating the ODBC layer between your web application and the database.

If you don't specify an OLE DB provider for your database, ASP uses the default OLE DB provider for ODBC drivers to communicate with an ODBC driver, which in turn communicates with the database.

Different OLE DB providers exist for different databases. You can obtain OLE DB providers for Microsoft SQL Server by downloading and installing the Microsoft Data Access Components (MDAC) 2.5 and 2.7 packages on the Windows computer running IIS. You can download the MDAC packages for free from the Microsoft website at http://msdn.microsoft.com/data/mdac/downloads/.
 

TRYTHIS LINK - C_A P replied to Ramya M. on 17-Dec-08 04:02 AM

maybe this can help  you
http://www.issociate.de/board/post/212908/ODBC_connection_to_SQL_server_failing.html
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306
sql server error:11001 - mangesh shete replied to Ramya M. on 17-Feb-09 04:26 AM
connection failed:
SQL State:'01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection open(Connect( )).
Connection failed:
SQL State:'08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.