Hope this is simple for the experts out there...
I need to create a VBScript that will insert a row into db on SQL 2000. There is a System ODBC connection available if that is easier pointing the database in question
Details are be:
ODBC Datasource Name: SMS
Type: SQL 2000
Table: Outgoing ( has two columns - PhNumber and TextMsg
Db User: sa
DB Password: blank
Server Name: SQLServer
I have a process that will recreate this file each time it is required, inserting the 2 text values ( for the fields PhNumber and TextMsg ) into the appropriate section of the vbscript file.
many thanks
ije
I need to create a VBScript that will insert a row into db on SQL 2000. There is a System ODBC connection available if that is easier pointing the database in question
Details are be:
ODBC Datasource Name: SMS
Type: SQL 2000
Table: Outgoing ( has two columns - PhNumber and TextMsg
Db User: sa
DB Password: blank
Server Name: SQLServer
I have a process that will recreate this file each time it is required, inserting the 2 text values ( for the fields PhNumber and TextMsg ) into the appropriate section of the vbscript file.
many thanks
ije