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.

BTW: maybe this is a question for the SQL group.

FileSystemWatcher onCreated tell where it was created from?
Asynchronous callback method: Thread.CurrentPrincipal roles empty
Closing tray applications from .NET
.NET 1.1 connectivity with SQL 2005 ????
Access network shares from asp .net 2.0