[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