Re: SQLOLEDB with Server=(local) on SQL Server 2005




onedaywhen wrote:
Can anyone confirm whether or not it is possible to use '(local)' with
SQLOLEDB on SQL Server 2005?

Yes, I can <g>. The resolution is in Configuration Manager to set
TCP/IP to enabled.

Jamie.

--

.



Relevant Pages

  • RE: SQL Server Configuration Manager
    ... Were you able to get a resolution to this issue? ... I've got a similar problem with a SQL Server 2005 64-bit clustered ... In my Configuration Manager, ... I imagine that it's a 64-bit cluster issue rather than a just a 64-bit ...
    (microsoft.public.sqlserver.clustering)
  • Re: Umstieg von Access auf SQL-Server
    ... > Bei Port 1433 sabber ich dann immer gleich Named Pipes. ... Nein, TCP/IP. ... How To Change SQL Server Default Network Library Without ... How To Set the SQL Server Network Library in an ADO Connection String ...
    (microsoft.public.de.vb.datenbank)
  • Re: IF Statement causes Invalid Column Name
    ... This has to do with parse and compile time versus execute time. ... And also deferred name resolution. ... If you refer to a column which doesn't exist, SQL Server will not be able to parse your SQL, so you will never ... SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: Slow access on XP using ADO with ODBC to SQL Server 2000 - any ideas?
    ... Just a thought but you might try changing the SQL server name in the ... connection string to the server's IP address as a test. ... | and keep all the machines here configured the same way using TCP/IP. ...
    (microsoft.public.data.ado)
  • Re: TCP/IP slower than NetBEUI...?
    ... > With TCP you need a method of name resolution as you have seen. ... > few workstations HOSTS files will do the job. ... running only TCP/IP. ... Netbios Naming does *not* require NetBEUI. ...
    (microsoft.public.win2000.networking)