Database Abstraction with ASP

[wdmny]

It was recently suggested to me by shane that I would need to 'abstract' my database functions from my code.

I have been reading into this and I still cannot find solutions to some of my problems here. First of all, how can I perform SELECTS using functions? It is pretty simple to open a database connection and execute SQL statements, but for retrieving values and rows, I am stuck. Can someone with experience in db abstraction and ASP help me out? Does anyone have a sample abstraction file that I could use (with my modifications)?

Thanks

[azizur_rahman]

No Offence but from your website:

infinetSoftware can create a variety of business applications including Access Database software, Microsoft Office integration, Windows NT/2000 integration, and more. To learn how infinetSoftware can help your business, email info@infinetsoftware.com for more information.

It seems to me that you already provide business Access Database and integration. Its really shame that software company like your's or the one you're working for provide the service and not know how to do this. It really breaks my heart to see this post.

What you're asking require some what long explanations... and I dont think I'd have space to explain everything here about db abstraction and ASP, and how to use SQL Select statements.

But since I am being generous and feel bad not halping you... I've got several URLs for you.

http://www.asp101.com/articles/wrox/3382/33820605.asp
http://www.asp101.com/ado/index.asp
http://www.asp101.com/articles/wrox/asp30/26100903.asp

http://www.asp101.com/articles/wrox/asp30/contents.asp


I hope this helps you out.
by the way... do forgive me.. if I am being unfair critising you or parhaps your company.
Please reply to me if am incorrect in my critisim, only you can help me to realise the mistakes I am making by knowing little about you and your company. I am sure the sitepoint mentor will agree with me. well at least I hope so.

[wdmny]

I know what you mean, but I DO know what I am doing. Everyone runs into new problems and new ideas. I have never personally had a need for database abstraction before. In addition, before your post I had already found a solution. And finally, the URLs you provided had content that I already know. Sorry to argue back with you, but I do know what I am doing.

[Snowbird122]

I think it is quite uncommon to have a generic database abstraction layer. In my experience, almost all SQL statements reside in either custom COM objects or stored procedures. Both of these provide more security and performance than creating generic ASP functions to access your database.

[wdmny]

That is true, but not always possible. In this case, I am going for customizable, simple, and multidatabase use, and therefore, stored procedures and COMponents aren't preferred.