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.
| Author |
Topic |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2003-04-08 : 02:36:30
|
Hi,I was trying some tricky stuff for long.. infact posted a question of "Setting Attributes in AD using T-Sql"  , no suggestions from ne one... ?!Ne way let me put the past, and I tried looking for methods, and one was calling a dll from t-sql which does the job i wanted ..all went fine but as i was going thro' articles of the forum, rob and few more adviced not to use in-process dll call.. Would crash sql service.. !!   .And further reading of few advices, from the articles learnt using DCOM -> a remote object calling wd be better.. now I am scratching my head how do i do this.. ?  Can ne body help me in finding articles.. or ways to do this. ? Wd appreciate ne kind of help.RoyalSher.The world is the great gymnasium where we come to make ourselves strong. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-08 : 04:21:25
|
| look atwww.nigelrivett.comsp_oacreate Load DTSIt's an example of loading a com object and setting properties and calling methods.SQL server only supports loading local com objects but I have seen a method of loading a remote object but it involved patching the registry.I didn't try it but if you do a search you should find the article.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2003-04-08 : 05:26:51
|
hth nr,thanx for the reply. lemme do some more r&d.. and shall post the results if any to the forum.  RoyalSher.The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2003-04-09 : 04:49:26
|
| hi yrybody,solved the problem which i had posted as my first message in this message id. In order to avoid Sql Server crash, I had called dll using sp_OACreate not directly but by using COM+, where i have registered the dll... which in turns does the functionality in ADS.I would kindly advice yrybody whoever wantz to use dll for doing ne bzness logic, give that headache to COM+.. else u face the problemo.. i think i have read quite a few articles by rob.and few more abt this problem.A suggestion.. best of luck ppl. .RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-09 : 04:59:55
|
| Can you post a bit more detail about this - sounds interesting.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2003-04-09 : 05:21:19
|
| hth,hmm well it was interesting when i started off. well lemme put my requirement..!I had to set few attributes of a user in AD from Sql (T-Sql).The solution i derived was using a DLL, but read thro' excerpts of an article.. "The cost of creating and destroying the object each time it's called will probably outweight the network traffic cost. Combined with the crash risk to SQL Server, MTS becomes crucial for fault isolation and object caching.) So, you end up putting an application server on the database server, thereby taking more resources away from SQL Server. Plus, at that point, you have a local app server, so you can have COM objects make DB calls with no physical network overhead. At that point, you've destroyed the primary reason for having the DB call a COM object - reducing network overhead." [8d].So decided to use COM+, registered the dll and instantiated the object in the COM+. And there i go ... all things working fine.. as i wanted it to be..!!hmm of course few glitches with permissions of the account.. ... otherwise a happy ending. [RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
|
|
|
|
|
Calling Remote Object [dcom] from t-sql