I am trying to establish a read only link into an oracle table and pass the user name and password through so the user never sees it. I have a system DNS set up for this but it has no place to set a password. I am down to using a query when the db opens and it works except for the fact that it is prompting for a value. I assume this is because the select statement is specifying the field before it makes the link.
SELECT [field1] FROM tablename IN oracledbname
[ODBC;DATABASE=u
ATABASE BACK END\db1;UID=me;PWD=xxxxxx;DSN=db1dns];
It's not a big deal since the user can just hit ok and go on but it looks ugly. Is there any way to send the username and password through first before it selects a field?
SELECT [field1] FROM tablename IN oracledbname
[ODBC;DATABASE=u
ATABASE BACK END\db1;UID=me;PWD=xxxxxx;DSN=db1dns];It's not a big deal since the user can just hit ok and go on but it looks ugly. Is there any way to send the username and password through first before it selects a field?
