• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1208
  • Last Modified:

How can I By-pass or auto login to an ODBC database

How  can I By-pass the user id and password prompts or auto login to an ODBC database?
0
mbrennan_pacbell_net
Asked:
mbrennan_pacbell_net
3 Solutions
 
Steve DubyoCommented:
Those details can be embedded.  Is this a linked table we are talking about ?
0
 
mbrennan_pacbell_netAuthor Commented:
Yes,  It is a linked table (Specicially linked into an Access database).

Thanks,

Mike
0
 
jgoedersCommented:
Workspaces(0).OpenConnection("MyNewConnection", , , "ODBC;DSN=...;UID=MYLOGON;PWD=MYPASSWORD")
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
jgoedersCommented:
connect to an odbc database through this code:

Workspaces(0).OpenConnection("MyNewConnection", , , "ODBC;DSN=...;UID=MYLOGON;PWD=MYPASSWORD")

insert the DSN of the database and you logon and password.  then just run this code when the database opens.
0
 
DauheeCommented:
optionally remove the password from the access database :)
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now