VBSCript writing to SQL database

[SW2004]

Can anyone help me with the following, when I try to write the PC name to a SQL database I get the message that column names are not permitted only variables, what's wrong with my code? I suspect it's the formatting of the (objComputer). Many thanks

'Read Machine Name
Set objComputer = CreateObject("Shell.LocalMachine")
SQLQuery = "insert into Audit_Table (MachineName) values(objComputer)"
objRSSQL.Open SQLQuery, objConn

Wscript.Echo "Done

 

[PHV]

SQLQuery = "insert into Audit_Table (MachineName) values('" & objComputer & "')"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SW2004]

Thanks PHV

I now receive the error 'object doesn't support this property or method', any ideas what could be amiss? I feel like I'm 99% there.

'Read Machine Name
Set objComputer = CreateObject("Shell.LocalMachine")
SQLQuery = "insert into Audit_Table (MachineName) values('" & objComputer & "')"
objRSSQL.Open SQLQuery, objConn