Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to hide the password do not specify this in the DBC?
Message
 
 
À
15/11/1999 17:14:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00291306
Message ID:
00291441
Vues:
17
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform