Kinook Software Forums

Kinook Software Forums (
-   [VBP] Third Party Tools (
-   -   Error :([DBNMPNTW]Connection broken.) (

Buildboy 08-27-2007 04:32 PM

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=;Initial Catalog=Framework","some_user","****"
rs.Open sql, conn, 1, 2

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

kevina 08-27-2007 05:09 PM

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 for more details.

Buildboy 08-27-2007 05:23 PM

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

All times are GMT -5. The time now is 06:40 PM.

Copyright 1999-2019 Kinook Software, Inc.