Thursday, July 9, 2009

How do you create ASP web applications that are compatible with SQL and Oracle databases?

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?

How do you create ASP web applications that are compatible with SQL and Oracle databases?
It doesn't really matter, ASP talks to almost all databases the same way. OLEDB is prefered, though it could do ADO as well.
Reply:Hi,


You can develop Asp with Ajax and Sql is best and easy way for dieing asp applications to become live all time.
Reply: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/200...





Oh, you'll need to acquire an Oracle data adapter for .Net but I'm bet you can find one out there pretty easily.


No comments:

Post a Comment