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 |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2003-04-08 : 04:24:59
|
| Hi All,Thru "sp_oacreate" we can create the instance of a dll in the SQL server(if the dll is registered in the Database server). Is it possible to create the instance of the dll without registering the dll in the database server machine(Using a proxy)? Since I have different machine for database server, application server and webserver. So I don't want to install the dll in the database server, because it should be installed in the application server. Please help by by any mean.Thanx in advance Sachinsachin.samuel@fqsltd.com |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-08 : 05:08:49
|
| Not normally. sp_oaCreate only creates an instance on the same m/c.I have seen a method of creating a remote object by patching the registry.This is the second time today this question has been asked so maybe I'll try to find it again if I get time.I posted the link in answer to a question several months ago but can't remember whether it was on this site or experts-exchange.==========================================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. |
 |
|
|
|
|
|
Using OLE Object