Linked tables in ms access asking for login/password

[anand]

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 OLEDBatabase 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.


anand saha

 

[Cor Ligthert]

Hi Anand,

Nice crossposted, however this newsgroup where this is often the question is
not in it.
If I was you I would try it especially there.

Adonet
<
Web interface:

<http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsof
t.public.dotnet.framework.adonet>

I think you have more change there to get an answer that fits you.

Cor

 

[Paul Clement]

On 21 Jun 2004 01:36:31 -0700, (e-mail address removed) (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 OLEDBatabase 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[John B]

On 21 Jun 2004 01:36:31 -0700, (e-mail address removed) (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 OLEDBatabase 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 ~~~ (e-mail address removed)
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

 

[Paul Clement]

On 22 Jun 2004 10:45:33 -0700, (e-mail address removed) (John B) wrote:

¤ > On 21 Jun 2004 01:36:31 -0700, (e-mail address removed) (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 OLEDBatabase 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 ~~~ (e-mail address removed)
¤ > 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)