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

ODBC Password?

P: n/a
Hi All,

Here is my situation:
I have a database that needs to be compacted and repaired nightly. I
have the process working and ready to go, but I have hit a snag with
an ODBC password.

I have a query that runs at every :02 and :32 of the hour. The first
time this runs (The first :02 or :32 on the hour after I have opened
it) I must put the ODBC password in. Every time after that the
password is not needed (I guess I stay logged in).

I want to be able to compact and repair my database at night, which
will force me to close and open the database. I still want this query
to run at every :02 and :32 after it is opened back up, but currently
it will not be able to because it will be waiting for me to put in the
password for the first time.

Is there a way to send the ODBC source the password through code? Any
other Ideas?

As always,
Thanks in advance for all of your help!

Mar 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Matt wrote:
Is there a way to send the ODBC source the password through code? Any
other Ideas?
Hi Matt,

I don't know what database type you're connecting to, but the dialog
that appears when you link a table should give you the option of saving
the password with the linked table. Clear your current table links and
relink them.

In my experience with helping folks with Oracle ODBC, at least, a lot of
people miss that little check mark! 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Mar 6 '07 #2

P: n/a
On Mar 6, 2:03 pm, Tim Marshall
<TIM...@PurplePandaChasers.Moertheriumwrote:
Matt wrote:
Is there a way to send the ODBC source the password through code? Any
other Ideas?

Hi Matt,

I don't know what database type you're connecting to, but the dialog
that appears when you link a table should give you the option of saving
the password with the linked table. Clear your current table links and
relink them.

In my experience with helping folks with Oracle ODBC, at least, a lot of
people miss that little check mark! 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

Thanks Tim!
Mar 6 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.