Connection - MSSQL - HOST_ID

Hi Everyone,
I wonder if somebody knows what sets the value resulting from the HOST_ID()
function in SQL2000.
It seems that the OleDb connection sets that property (and pass it to the
server when setting up the connection).
My problem is that I need to create 2 connections in my application to the
same database/server using the same credentials, but I need both connections
to return different HOST_ID().
I haven't been able to accomplish that, currently my both, different
connections return the same HOST_ID() when querying the database.
Any ideas?
Thanks, Jos Araujo.You can specify the desired host name using the 'Workstation ID' connection
string keyword or OLEDB property:
Provider=SQLOLEDB;Data Source=MyServer;Initial Catalog=MyDatabase;Integrated
Security=SSPI;Workstation ID=MyHost"
Hope this helps.
Dan Guzman
SQL Server MVP
"Jos Araujo" <josea@.mcrinc.com> wrote in message
news:O3f60VwQGHA.5808@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I wonder if somebody knows what sets the value resulting from the
> HOST_ID()
> function in SQL2000.
> It seems that the OleDb connection sets that property (and pass it to the
> server when setting up the connection).
> My problem is that I need to create 2 connections in my application to the
> same database/server using the same credentials, but I need both
> connections
> to return different HOST_ID().
> I haven't been able to accomplish that, currently my both, different
> connections return the same HOST_ID() when querying the database.
> Any ideas?
> Thanks, Jos Araujo.
>
>
>|||It is not quite exactly what I wanted: I wanted to change the HOST_ID()
return value, it changes the HOST_NAME() return value.
However: I can workaround my problem by using this.
Thanks! Jos.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:O1mkLmyQGHA.5468@.TK2MSFTNGP14.phx.gbl...
> You can specify the desired host name using the 'Workstation ID'
> connection string keyword or OLEDB property:
> Provider=SQLOLEDB;Data Source=MyServer;Initial
> Catalog=MyDatabase;Integrated Security=SSPI;Workstation ID=MyHost"
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Jos Araujo" <josea@.mcrinc.com> wrote in message
> news:O3f60VwQGHA.5808@.TK2MSFTNGP12.phx.gbl...
>|||I'm glad my answer helped, even though it wasn't exactly what you were
looking for :-)
Dan Guzman
SQL Server MVP
"Jos Araujo" <josea@.mcrinc.com> wrote in message
news:evtB6U4QGHA.1576@.tk2msftngp13.phx.gbl...
> It is not quite exactly what I wanted: I wanted to change the HOST_ID()
> return value, it changes the HOST_NAME() return value.
> However: I can workaround my problem by using this.
> Thanks! Jos.
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:O1mkLmyQGHA.5468@.TK2MSFTNGP14.phx.gbl...
>

Connecting via Radio Link

Could somebody tell me as to what configuration changes has to be made in the SQL Server 2000, if I want to connect to a table in the database using Internet options, i.e., I have the SQL Server running on a machine which uses a real IP address, and I want to connect to it (SQL Server)using DSN from another location. In the 2nd location, I use internet using dialup/DSL/Cable Broadband.

--
The following error is shown, when I try to connect to the SQL Server using SQL Server authentication using login ID and password:

Connection failed:
SQL State:'01000'
SQL Server Error: 10060
[Microsoft][OBDC SQL Server Driver][TCP/IP Sockets]ConnectionOpen[Connect()]
Connection failed:
SQL State:'08001'
SQL Server Error: 17
[Microsoft][OBDC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
-----

Thanxs in advance to anyone who can help me solve the problem.You can use the Client Network Utility.

Go To Client Network Utility. Go to Alias Tab.
Click on ADD. Provide a Alias Name, and the Server IP address or the URL as Server Name under the Connection Parameters Section. (Netowrk Libraries can be Named Pipes)

Thats it. When you go to Enterprise Manager, you can register that server by its Alias name.