I have two tables
1 = MS Access table
2 = Oracle table
I need to join (query) table 1 (Access) to table 2 (Oracle)
Problem: Though I can use ye old (cnn1.Open "Driver={Microsoft ODBC for
Oracle};Server=Server;DSN=Oracle;UID=UID;PWD=PWD") followed by
(rst.Open sql, cnn1) to connect with and speak to the Oracle server, it
will not see the Access table within the SQL script.
To bypass this problem I ran a simple (Set rs = db.OpenRecordset(sql))
where SQL = my query string to connect table 1 with table 2. This works,
but it requires that you enter the Oracle password manually every time.
I thought the "cnn1" string above would bypass this by opening the
Oracle connection first, but nope, that doesn't seem to do it.
Question: How can I get this connection to work without having to enter
the password manually every time?
Thanks
Craig Gross
VBA Developer
Baker and Taylor
Phone: 908-541-7197
Email: [email protected] <mailto:[email protected]>
This email and any attachments contain information from Baker & Taylor which
may
be confidential, privileged and/or protected by other legal rules. If you are
not the
intended recipient, you are hereby advised that any disclosure, copying,
distribution or
use of the contents of this email is prohibited. If you have received the email
in error,
please notify us by reply email immediately and then delete the email and your
reply
from your email system. NOTE: Baker & Taylor accepts no liability for the
contents of
this email. This email shall not operate to bind Baker & Taylor to any
contract, order
or other obligation.
[Non-text portions of this message have been removed]
