home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,756 of 19,505   
   Erland Sommarskog to theintrepidfox   
   Re: ODBC Connection Wizard: Can't see SQ   
   15 Feb 10 18:38:26   
   
   5ac82932   
   From: esquel@sommarskog.se   
      
   theintrepidfox (theintrepidfox@hotmail.com) writes:   
   > I wonder whether you may have some hints and pointers. I'm trying to   
   > create an ODBC User/System DSN but can't see the SQL server in the   
   > ODBC New Connection Wizard drop-down. The client machine is in a   
   > different domain than the server. I can ping the server and resolve by   
   > name but typing Servername / IP in the dropdown combo doesn't work.   
   > Further: The client machine is running an application that connects to   
   > the very same SQL server using SQL Authentication just fine which   
   > puzzles me a bit. SQL Server browser is running on the server.   
   > I'm grateful for any ideas you may have. Please let me know if you   
   > require additional details.   
      
   I haven't used the wizard for many years, but aren't you able to save   
   the DSN without testing it? In that case, does it work when using it?   
      
   Also, on the same machine, try connecting to the server with OSQL using   
   the same parameters.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca