Want a Example Of MTS with VB6 Code

[manishjoisar]

Can anybody give small Code example of MTS In VB6
i have made a DLL which reside in COM+ of Server & i
am using that for INSERT,UPDATE,SELECT

But i want idea about MTS

 

[fredericofonseca]

The best way is to create one with Enterprise Admin, and then look at the code. It can be saved as a Visual Basic file. (v7 and 2000)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[manishjoisar]

How to Create with Enterprise Admin can you explain

Thanks

 

[fredericofonseca]

On enterprise manager select the database you are working with.
Then select "Data Transformations Services->local packages"
and create a new package.

There is a very good help on DTS on SQL Server Books Online, supplyed with SQL Server. These are also available at

http://www.microsoft.com

for free.

READ THEM.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[manishjoisar]

I want to work with ( MTS ) & Not DTS. It is same or what??

Thanks

 

[VBrit]

No it is completely different!! I think mis-read!

MTS - Microsoft TRansaction Server / COM+

With MTS you need to remember that your transaction will only be completed when you call SetComplete of the parent object. It is more of a procedural way of coding than a heirarchical way of programming, because the requirement that it is 'all or nothing' approach.

For good example look for "Duwamish online" at msdn.microsoft.com

 

[fredericofonseca]

Oopss!!

Sorry for that it was my mistake.

Just ignore.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[fredericofonseca]

look at

http://www.vbforums.com

If you search for MTS you will find 500+ entries. Some of them are bound to help you.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[manishjoisar]

If i want to go for Multi tier Application then i have to learn MTS & COM+ OR Only COM+ is enough


Thanks

 

[manishjoisar]

Can you make me understand what actually MTS is use for

Example

I have Header Table ,Detail Table & I want to save in it so what is use of MTS in this / It is for anything else

Thanks