Recent content by vishnuprasad

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...