Search results for query: *

I dont think U need to shut down the server, instead just click the refresh button which I feel would do.

Use *.TLB/*.VBR files,*.exe with Package and deployment wizard for client side installation.

USe SQL Jobs

I think this has nothing to do with data, its settings in MTS which is causing the probs.Check u'r Component security. Disable the checkbox for Enable authorization and try it again.

Are u using this as a *.VBR,*.TLB file or have u installed as a *.msi,*.exe file. If the case is former than you don't have problem.

Programming COM with VB6 - TeddPatisson COM programming with VB - Marykirtland

If u dont break compatibility u can expand them in the existing interface but if u want a new expanded one (which breaks compatibility) then u will have to create a new abstract interface defn and again implement in the class where u want.

EngineFactory object should support the object being passed for further processing, i.e your QueryInterface is not returning a valid reference back.

Use a ADO recordset to run your query and set the recordset to Datagrid/adodc. 'say rec is recordset Set rec = datagrid1.recordset.

If u implement MTS code with Security context you can? Or else u can pass from the client the Machine name as a parameter. Sorry I don't think I can do much...

Its logical that ODBC will not save the password since its your app which should pass the password for security validation. The initial ask is just to test for connectivity.

I dont know much about MS Access but as far as my knowledge I dont think u have any Storedprocedure's in MSaccess.

create procedure sp_GetEmployeeDetails @Eno int, @Eno int output, @EName Varchar(30) output, @Sal Decimal(12,2) output as select @Eno=eno, @Ename=ename, @Sal=sal from emp where eno=@Eno return Just check for syntax as I have not run this in sql.

create procedure sp_GetEmployeeDetails @Eno int, @Eno int output, @EName Varchar(30) output, @Sal Decimal(12,2) output, as select @Eno=eno, @Ename=ename, @Sal=sal from emp where eno=@Eno return Just check for syntax as I have not run this in sql.

U cant make updates into the inserted table.I can just give a idea of creating a unique column in the exiting table or create a temp tab with unique val and go with the updates with the table directly.I have'nt checked the following modified query, but just work on it. CREATE TRIGGER...

Its something to do with latebinding, try early binding the method call.It is unable to identify the call made due to late binding.

Change Business rules and recompile with Binary compatibility mode. Dont break the compatibility COM+ will take care of this , but in MTS u will again have to register under MTS. Further u have to install client exe with the VBR files of VB and configure for Remote Server configs.

The object which you are trying to include in a transaction should be called with "getobjectcontext.createinstance("prj.class1"). Have a root class which would call these two functions to perform(which are in two different classes). Make a call from root to both these classes...

The query seems to be fine, just try to use "commit" after the fetch statement within the while... or make the entire Inserts as a unit of work using explicit "Begin trans". I feel that this might work.

MTS will dynamically allocate 100 threads/processor(or process) so it basically is a question of what is the hardware configuration. In u'r case it will allocate a max of 200 threads(at peak load) to various activities created.Once it goes beyond this level it will go for co-operative thread...