lmsmith wrote:We don't want users to be able to query the entire table, retrieve all rows and used elsewhere.
Some other options I've considered are below, but not sure if they are viable.
1) We're looking into calling a web service from a validation script eliminating the need to have a DSN on every workstation, but the programming is taking some time to figure out (I'm a little rusty).
(2) I'm assuming if I created a validation script and accessed an ODBC Data Source programmatically by pulling back data using SBL's SQLRequest function, I would be in the same boat? Would the ODBC DSN need to be configured on every workstation using the validation script method as well?
About querying the entire tabe. I understand that but how would one do that? At least something like SQL Server Managent Studio (Microsoft) or Toad (Oracle) should be installed on the scan/validation PC's.
Users browsing this forum: Yahoo [Bot] and 6 guests