ODBC and SQL Security

Hi,
What is the best practice for authentication to Win2003 Server with SQL
Server 2000 database? For example, an Access 2003 application that would us
e
a ODBC pass-through query to connect and select (read only) data from the
SQL Server database. Would prefer to hard code the username and password
using VBA as this is a reporting app only. We are using a Novell network on
servers where Access app is installed. Usernames are only unique within the
contexts on multiple Novell servers.Bonnie
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting
best practices
http://vyaskn.tripod.com/sql_server...t_practices.htm --secu
rity
best practices
"Bonnie" <Bonnie@.discussions.microsoft.com> wrote in message
news:1A495F95-D112-4364-A11B-F1FDC24D93C4@.microsoft.com...
> Hi,
> What is the best practice for authentication to Win2003 Server with SQL
> Server 2000 database? For example, an Access 2003 application that would
use
> a ODBC pass-through query to connect and select (read only) data from the
> SQL Server database. Would prefer to hard code the username and password
> using VBA as this is a reporting app only. We are using a Novell network
on
> servers where Access app is installed. Usernames are only unique within
the
> contexts on multiple Novell servers.

OCR Features

Hi All, is anyone had develop a system for OCR features? For example i wish to develop a system, all the data will input from fax machine. The fax machine need to scan the data and auto connect to PC software, is it this possible and accurate for the data ? Thank All !!!There are a number of tools for doing this. HP ships a package with at least some of their OfficeJet machines that does a respectable job. I'm pretty sure that Cannon does too, although I've never played with it myself.

Intel used to have a great product that they shipped with their SatisFAXion boards, that I think they've released as a commercial product. I don't know the name off the top of my head, but it was a great package (easy to use, accurate, and relatively low overhead).

I suspect that this market has already been pretty well developed. I'd be surprised if there was much room for real growth here.

-PatP

Objects in precedence constraints?

Is it possible to use objects in precedence constraints? For example, I have a collection object that may or may not be populated in a script at some point and want to be able to execute different paths depending upon whether the Count property equals zero or not.

I realize I could very easily just create another int variable and populate it accordingly, but I am just curious about this. I couldn't get it to work, but then I am really just starting out here and just not sure if I am doing it wrong.

Thanks!

Brandon

Brandon,

No, its not possible to do that. The expression language doesn't have that capability. You will have to use a script task I'm afraid.

-Jamie