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