I'm researching ways in which I can build Classic ASP applications that can work with a SQL and Oracle database based on the user's preference. What changes in database connections and code would be needed? Is their an online article that discusses this?
2007-06-29 18:12:22 · 3 answers · asked by Valerie H 1 in Computers & Internet ➔ Programming & Design
It doesn't really matter, ASP talks to almost all databases the same way. OLEDB is prefered, though it could do ADO as well.
2007-06-29 19:25:16 · answer #1 · answered by Kasey C 7 · 0⤊ 0⤋
Hi,
You can develop Asp with Ajax and Sql is best and easy way for dieing asp applications to become live all time.
2007-06-29 19:05:32 · answer #2 · answered by benaya p 1 · 0⤊ 0⤋
Does it have to be classic ASP? You can easily do it with .Net because you can abstract your Data Access code and use the appropriate interfaces.
Here's a decent article that explains what I'm talking about: http://www.ondotnet.com/pub/a/dotnet/2002/12/16/transadonet.html
Oh, you'll need to acquire an Oracle data adapter for .Net but I'm bet you can find one out there pretty easily.
2007-06-29 18:24:35 · answer #3 · answered by Eman 2 · 0⤊ 0⤋