VB Script (db con) question

[Mace-x]

Hi.
I have an excel macro (vb script) that i have to tweak a bit but ive never worked with vb script before (being a c++/java programmer).

I was wondering (to put it mildly) how the heck I can debug things when I get errors like “runtime error no 212302840943” and have no clue what it is or how to fix it.

Ive tried pressing f1 to get a detailed description of the error although it doesn’t help a vbs noob like me.

Any suggestions? I would really appreciate it

A code snippet:

Dim DDE As New DdeLib.DdeConnection

DDE.Connect "KONTAKT", "SERVER" <-- gets stuck here (the strings are defined in another place in the code)

[SeanPMorris]

First off the best place to go for vb scripts, after here, of course, is probably the MS site. Try http://microsoft.com/technet

in terms of connection strings try:

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

strSQL="SELECT * FROM tblwhatever"

conn.Open("Driver=SQL Server; Server=ServerName; Database=DBName; User ID=UserID; Password=PWord")

Set rs.conn.Execute(SQLString)