ODBC or ADO ??

[Luis G]

so which one should i use for programming with ASP and Visual C++?

 

[samcurry]

i like ODBC, its better for porting to an as400 and the likes.

 

[Jeslek]

ADO, it is faster.

 

[PT]

Although it hurts me to say, speed is not everything, if it were, we'd all still be using DOS. Go with ODBC, may save you some keystrokes in the future.

 

[Luis G]

So ODBC gets the code, and ADO gets the speed. Always a tough call.

i'm not marrying with their specific instructions, all i want to do is to use SQL language to interact with the database manager, in this case SQL Server, i should have been more specific.

So, for doing that, is it better to use ODBC or ADO?

 

[Professur]

Bugger SQL Server. Go with DB2. Much better.

 

[Luis G]

If it was my choice i'd use UNIX, Apache, PHP and another database.

However, it isn't, so i must use NT, IIS, ASP and SQL Server.

 

[Professur]

You could always quit.

 

[Luis G]

I could quit theorically, but that'd screw me, since this project is for my professional service i must complete it in order to get my professional degree and title.

So what's the call, ODBC or ADO?

 

[Professur]

ODBC. If you have to use M$, you may as well use it.

 

[greenfreak]

I wish I knew basically what all that stuff was about. I'm always changing values and stuff in ODBC, SQL server, dsedit, etc. and I have no idea what I'm doing or how to troubleshoot problems.

 

[Jeslek]

We use IIS on 2000 as a front end, and Oracle on Solaris as a back end. We connect with ADO and not ODBC. ODBC is incredibly slow and ADO is easier to use.