Kinook Software Forums

Kinook Software Forums (http://www.kinook.com/Forum/index.php)
-   [VBP] Third Party Tools (http://www.kinook.com/Forum/forumdisplay.php?f=3)
-   -   Error :([DBNMPNTW]Connection broken.) (http://www.kinook.com/Forum/showthread.php?t=2967)

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=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 :)

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 http://support.microsoft.com/kb/238949 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.