Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Extended Stored Procedure programming

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-09-01 : 07:42:37
Greg writes "Hi Guys,
I need a opinion here. I am developing/redeveloping a XP and moving away from the DB-Library. I am changing the XP to se ODBC but the thought occurred to me why not use ADO . I know ADO a lot better than native ODBC. I have looked on the Internet but can't really fined any information.

My question is this. Is there a good reason (or any reason) to not use ADO in a SQL Server Extended Stored procedure?

kind regards
Greg O"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-09-01 : 07:44:48
I can't think of one, other than the aforementioned lack of examples. ADO adds a little more overhead to native OLE DB calls but it's not likely to affect performance significantly.
Go to Top of Page

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2003-09-01 : 08:26:44
I think the more interesting question is, if one should write its own extended stored procedures.
Why?
Because poorly programmed xp's are likely to crash SQL Server and it's very easy to poorly program C and C++

anyway, here are a few links on this topics

http://search.microsoft.com/search/results.aspx?View=msdn&st=a&s=2&c=4&qu=extended+stored+procedures
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odssql/ods_6_con_01_9rxv.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odssql/ods_6_con_01_3fhq.asp

and good luck!

Cheers,
Frank
Go to Top of Page
   

- Advertisement -