By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,193 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

force user to signon to ODBC source

P: n/a
I'm developing an MS Access application that creates and executes
stored procedures on a Teradata system using SQL Pass Through queries.
I want the users to have to perform those functions using their own
Teradata UID and password. I've tried omitting Password and UID from
the connect string, but I get a response that there isn't enough
information to sign on. It seems as tho the messages I've found here
are asking how to AVOID asking the user to enter pw and ID. How do I
REQUIRE them to enter that information?

TIA,
Nolan

Nov 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

no*********@gmail.com wrote:
I'm developing an MS Access application that creates and executes
stored procedures on a Teradata system using SQL Pass Through queries.
I want the users to have to perform those functions using their own
Teradata UID and password. I've tried omitting Password and UID from
the connect string, but I get a response that there isn't enough
information to sign on. It seems as tho the messages I've found here
are asking how to AVOID asking the user to enter pw and ID. How do I
REQUIRE them to enter that information?
If you are using ADO, try something like this:

Set con = New ADODB.Connection
con.Properties("Prompt") = adPromptComplete
con.Open strConnect

Nov 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.