Greetings, I'm trying to delete records from a MS SQLServer table based on identifiers stored in a file. The script listed below works great on its own. The problem is launching the script from a third party scheduling app gives me an ODBC error - "** Script Error: ODBC error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". The script is launched from the scheduling app with the command: C:\Rebol\REBOLCMD.EXE %/C/Rebol/deltdlrows.r. This brings up a REBOL/Command console with the above error. With this console I can't connect to my database, but when I bring up a new console the connection works fine. Any ideas?
REBOL [ Title: "Delete TDL Rows" Date: 15-Aug-2005 File: %deltdlrows.r Author: "Ken Vincent" Version: .05 ] change-dir %/F/Process_J5P0 source: %UPDTDL.DAT connect-db: open odbc://OHSU\*******:[EMAIL PROTECTED] db-port: first connect-db if [size? source > 0][ tx_nums: read/lines source foreach tx_num tx_nums [insert db-port["DELETE smsdss.clarity_tdl_tran WHERE (TX_ID = ?)" tx_num]]] close connect-db -- To unsubscribe from the list, just send an email to lists at rebol.com with unsubscribe as the subject.
