Question Locked

VB.NET - How can I avoid entering database credentials??

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am green in VB.NET EXPRESS and converting MS Access VBA app to .NET.

Quick Explanation: Within my Access database I have linked tables to an Oracle database from which I retrieve data. (I read that .net express has no functionality for Oracle connections)

Problem:
Everytime I hit these tables from the .NET front-end I am prompted for username/password. With the user having to enter this dozens of times per process I am in danger of realizing this project is useless!

Solution:? Any help is greatly appreciated..

5 replies

by cmiller5400

There must be a way to edit the data source to include passing the credentials... Maybe... I have not worked with Oracle before.

by mpolini

Because its a linked table in access, I am not directly connecting to an Oracle db, therefore I would not be surprised if I am unable to pass my credentials. Can anyone else give me any ideas? Or does anyone know if VB.NET Express supports Oracle dbs?

by shellbot

I'm not sure about the Oracle thing..never worked with Oracle..
But when your linking a table in Access to a SQL database somewhere in there you can set/save username & password.. if linking to an Oracle table is the same (right click on white space -> Link Tables ) then one would assume it does allow for saving the credentials when linking to Oracle as well.

Thing is, was last year when I was doing a lot of this..can't remember where exactly this comes up. I think its when your done linking a promt comes up asking if you want to save?? Anyone more familiar with this?

This discussion is closed to new replies.