Advice needed on localization

Hi
I have an old ASP website which I need to localize. There should be several languages supported. The website connects to an MS SQL server.
Please advise if this is the right apporach - I plan to extract all hardcoded Strings from the pages and put them into a table in the database (like a resourcestring list). Then another table will contain translations on different languages. A user chooses his preferred language and I store this information in the session variable Session("show_language") = "ar" for example. The call a procedure to load all the resources for this language in session variables like Session("Res1") = :... Session("Res2") = .... etc from the database.
To display a resource I will need to call <div>....<%Response.Write(Session("ResX"))%>
My question is: Is this approach accepted or there might be another better approach?
ThanksStart Free Trial