CreateObject with SQL

[royjimenez]

hi!

I need to create an Object with CreateObject function

I am doing a tests and I can't find the classname.

'Dim sm As New SQLMerge // it's correct !!!
Dim sm As Object

Set sm = CreateObject("SQLServer.SQLMerge&quot // Unknown !!

please, help !! what is the correct name of 'SQLServer.SQLMerge' ?

Thanks in advance.



The life is too short to cry and long enough to try it... God bless us.

 

[nigelrivett]

try SQLMERGXLib.SQLMerge

There is an example in bol

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

 

[royjimenez]

i needed it urgently !!! for this reason i couldn't look up it.
Thanks


The life is too short to cry and long enough to try it... God bless us.

 

[royjimenez]

hi!

I made the test with

Set yy = CreateObject("SQLMERGXLib.SQLMerge&quot

But i got the message:
The ActiveX Component couldn't be created.

I have to register something ?
I' am using SQL Server 2000.

I haven't done this before, i have done this in this way:

Dim sm As New SQLMERGXLib.SQLMerge

Actually, it is working out.

If someone knows something about it, please help.

Thanks


The life is too short to cry and long enough to try it... God bless us.

 

[nigelrivett]

hmmm
CreateObject("SQLMerge.SQLMerge&quot

seems to work.

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

 

[royjimenez]

Thanks a lot nigelrivett !!!

It's working out !!!



The life is too short to cry and long enough to try it... God bless us.