Error :([DBNMPNTW]Connection broken.)
 

Hi All,
I am trying to write some data to the data base, the same vbscript works for XP and 2K3, its only on 2K that I am seeing this error. here is the script:

dim conn, rs, sql

sql = "INSERT INTO dbo.VMHostMapping (MachineName,vmxLink,VMHostIP,OSName) VALUES('%HOST_NAME%','%VM_URL%','%VM_HOST_IP%', '%OS_VERSION%')"

set conn = CreateObject("ADODB.Connection")
set rs = CreateObject("ADODB.Recordset")

conn.Open "Provider=SQLOLEDB.1;Data Source=10.10.10.10;Initial Catalog=Framework","some_user","****"
rs.Open sql, conn, 1, 2

what am I missing here?
Thaks for the help in advance :)

Sounds like you need to use the Sql Server Network Client Utility on the win2K workstation to properly configure named pipes and/or TCP/IP connections (depending on what you are using).

Since you are obviously trying to use a TCP/IP sql connection, you might also try adding "Network Library=DBMSSOCN;" to your connection string to explicitly force the use of that protocol. See http://support.microsoft.com/kb/238949 for more details.

Thank you very much for the help , that worked :)