An error about & quot;[dbnmpntw]ConnectionOpen(CreateFile())".

Hi:
When I tried to connect SQL Server Databse which was on another machine,
using Microsoft OLEDB Provider for SQL Server, error 0x80040005 was
returned, and the error message was
"& #91;dbnmpntw]ConnectionOpen(CreateFile()
)".Hi,
Use the SQL Client Configuration utility (from the machine u are connecting)
to create alias server name for the sql server using the TCP/IP protocol
specifying IP and port number.
And use this Alias name to connect to SQL server using TCP/IP
Thanks
Hari
MCDBA
"arxing" <cjx@.nbdx.cn> wrote in message
news:eAfe$8PWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi:
> When I tried to connect SQL Server Databse which was on another
machine,
> using Microsoft OLEDB Provider for SQL Server, error 0x80040005 was
> returned, and the error message was
> "& #91;dbnmpntw]ConnectionOpen(CreateFile()
)".
>|||But if I don't installed SQL Client on the machine I am connecting, what can
I do?
thanks.
"Hari" <hari_prasad_k@.hotmail.com> д?
news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Use the SQL Client Configuration utility (from the machine u are
connecting)
> to create alias server name for the sql server using the TCP/IP protocol
> specifying IP and port number.
> And use this Alias name to connect to SQL server using TCP/IP
> --
> Thanks
> Hari
> MCDBA
> "arxing" <cjx@.nbdx.cn> wrote in message
> news:eAfe$8PWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> machine,
>|||You can also do this using the wizard to set up an ODBC=20
data source. Use the Client Configuration button.

>--Original Message--
>But if I don't installed SQL Client on the machine I am=20
connecting, what can
>I do?
>thanks.
>
>"Hari" <hari_prasad_k@.hotmail.com> =D0=B4=C8=EB=D3=CA=BC=FE
>news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
machine u are[vbcol=seagreen]
>connecting)
the TCP/IP protocol[vbcol=seagreen]
TCP/IP[vbcol=seagreen]
was on another[vbcol=seagreen]
0x80040005 was[vbcol=seagreen]
>
>.
>|||You can also do this when you set up the ODBC data source.=20
Use the Client Configuration button in the wizard.

>--Original Message--
>But if I don't installed SQL Client on the machine I am=20
connecting, what can
>I do?
>thanks.
>
>"Hari" <hari_prasad_k@.hotmail.com> =D0=B4=C8=EB=D3=CA=BC=FE
>news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
machine u are[vbcol=seagreen]
>connecting)
the TCP/IP protocol[vbcol=seagreen]
TCP/IP[vbcol=seagreen]
was on another[vbcol=seagreen]
0x80040005 was[vbcol=seagreen]
>
>.
>|||This utility is available even if you didn't install the SQL Client tools -
start -> run -> Cliconfg.exe.
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"arxing" <cjx@.nbdx.cn> wrote in message
news:O3sk4WSWEHA.4048@.TK2MSFTNGP12.phx.gbl...
> But if I don't installed SQL Client on the machine I am connecting, what
> can
> I do?
> thanks.
>
> "Hari" <hari_prasad_k@.hotmail.com> д?
> news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
> connecting)
>