>I'm using ODBC Driver for ORACLE 7.3 (sqo32_73.dll) and want to maintain security, do not specify the password when setting up the connection in the DBC. I can´t to explicitly include the DBC in the project.
>
>What can I do?
I have a VFP login form to temporarily capture the user's ID and Password. I then create the connection string needed to open a shared connection. I have a User's table in the DBC where I lock the file while I do a DBSETPROP on the connection's ConnectString. I open a dummy remote view just to establish the connection. I then execute DBSETPROP again to remove the Connectstring, then unlock the table. Since this takes just a few seconds, user's trying to connect at the same time are not inconvenienced too long.
The dummy remote view is open the entire session of the application so I never have to have the user's ID and password. I release these 2 values after opening the dummy view. All safe and secure, no embedded IDs and passwords in the connection or in tables.
I can then use CursorGetProp to get the connection handle of the dummy view for use in SQL pass through.
Mark McCasland
Midlothian, TX USA