Securing ASP Data Access

Storing Values

Now let's have some fun. Open MetaEdit. If you left it open while you ran MetaSchema.vbs, then close it and re-open it to make sure it reflects the changes the script made to the schema. Once you have the Metabase Editor console open, expand the Schema key, and then expand Classes. You should see a key folder named DataAccessMethods. (Mine appeared at the top of the list.) There's nothing of interest in it for us at the moment, but it's important to note (and verify) that it is there. Now, expand the /Schema/Properties/Names key. If you sort the list in the right hand pane by Id, you should see three items in the 13000 range that correspond to the three values we defined using the MetaSchema.vbs script. Each will start with "ODBC". The actual ID values may very depending on your server configuration.

Once you've verified that the new property types exist, minimize the Schema key and expand the LM key. LM stands for "local machine", by the way. Under this key you will see all kinds of keys for different kinds of services running under IIS on the server. You will want to create a new key to use for credential storage. Create a new key by right clicking LM and selecting New | Key. I chose to name my key ASP101, but you can call it whatever you like, as long as you also change any code that references this path.

You might also like...

Comments

About the author

Thomas C. Carpe United States

I have been working in IT since 1993. I founded CarpeDiem Business Internet Systems in 1995. In 2000 we incroporated and took on two partners. Its really a grat lot of fun, and I enjoy working o...

Interested in writing for us? Find out more.

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Debugging is anticipated with distaste, performed with reluctance, and bragged about forever.” - Dan Kaminsky