Hello,
I am trying to figure out how to avoid the ODBC password dialog box that comes with opening a table in Oracle via a remote view. I realize you can't use trusted connections like in SQL*Server, but there has got to be back door.
Here is what I do now.
1.) Define a Shared connection in Views.dbc -- JKT9000
2.) Open a remote view -- v_Login -- ODBC Dialog box comes up.
3.) I then leave v_login open throughout session and because of the shared connection, I don't see the dialog box as I open other views.
I have tried in a program:
...
keyboard chr(013)
nConnect=SQLCONNECT('JKT9000', 'JKT', 'JKT') &&JKT is userid/password
...
and this shows the ODBC login, but the chr(013) closes it.
However, if I again try to open v_login, the ODBC dialog once again appears.
Any suggestions???
Kevin