OK, I am connecting to Oracle8 through ADO 2.1 and I used a code sample to get myself up and running. In this code sample, this code was used:
'Displays a prompt for Service, Username and password
.Properties("Prompt") = adPromptAlways
I seem to be stuck with this though. When I try to assign a different constant(like adPromptNever) or remove this line altogether, I get this error: "TNS:unable to connect to destination"
What I'd really like is to bypass the prompt because this app is supposed to run on a schedule, usually at night after everyone has gone home. Thanks for any help.