Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[REBOL] Command 2.0 Problems With ODBC

From: kvince::comcast::net at: 1-Sep-2005 18:57

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\*******:[******--DSS42] 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