On 22 Jun 2004 10:45:33 -0700,
jb***@gene.com (John B) wrote:
¤ Paul Clement <Us***********************@swspectrum.com> wrote in message news:<vj********************************@4ax.com>. ..
¤ > On 21 Jun 2004 01:36:31 -0700,
an*******@rediffmail.com (anand) wrote:
¤ >
¤ > ¤ Hi,
¤ > ¤
¤ > ¤ I have an Access 2000 database, which contains some native tables,
¤ > ¤ and some linked tables which belong to an ORACLE database, through
¤ > ¤ ODBC.
¤ > ¤
¤ > ¤ Using VB.NET, I am trying to fetch some data by joining two tables,
¤ > ¤ one table native to the mdb file, and another belonging to ORACLE.
¤ > ¤
¤ > ¤ I am using a connection string to connect to mdb file:
¤ > ¤ Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;User ID=Admin;
¤ > ¤ Jet OLEDB:Database Password=xxxx;Persist Security Info=True;
¤ > ¤
¤ > ¤ My problem is that as soon i try to fetch the data, a window (not belonging
¤ > ¤ to my vb program) comes up with the title "ORACLE ODBC driver connect"
¤ > ¤ asking for ORACLE's username and password. Its the same screen which
¤ > ¤ i get when i open Access database, and try to view one of the oracle
¤ > ¤ tables for the first time.
¤ > ¤
¤ > ¤ I don't want this screen. Somehow :
¤ > ¤ - i want to store this info with access
¤ > ¤ OR
¤ > ¤ - pass this info through something like the connection string.
¤ > ¤
¤ > ¤ User should not be able to see this screen.
¤ > ¤
¤ > ¤ I would appreciate any help.
¤ >
¤ > When you create the linked table in Access there is an option to save the password so that you will
¤ > not be prompted when accessing the table.
¤ >
¤ >
¤ > Paul ~~~
pc******@ameritech.net
¤ > Microsoft MVP (Visual Basic)
¤
¤ Paul-
¤
¤ I'm having this same difficulty, and tried your suggestion by
¤ re-linking the Oracle table so I could save the user ID and password.
¤ However, during re-linking I was never given the option to enter the
¤ user ID and password. Is this an option that has to be set-up in the
¤ Oracle driver or database?
¤
¤ John
I don't believe that the Linked Table Manager supports this capability if that is what you are
using. AFAIK, you have to delete the existing linked table and use the File...Get External
Tables...Link Tables... method.
Paul ~~~
pc******@ameritech.net
Microsoft MVP (Visual Basic)