[Thursday, January 20, 2005 8:24 AM]

hello folks,
My Requirement:

I want to have an combo box and it should get the list of sql servers that
is installed on the network..or on the machine..

The Process i have done:

I wrote a function , that intially list out the MSSQL server
installed..later it takes the server name from the sb5..which the user
enteres..It verifies with this list and returns one or zero
accordingly...based on this return value..I will have loop and asks for the
user to enter a correct sql server name..I have succeded in this..

CALLTHISFUNCTION1 FUNCTION(server)
CODE
open (window1)
?osqlApp{Prop:Create}='SQLDMO.Application'
onames = ?osqlApp{'ListAvailableSQLServers()'}
Loop i=1 To ?osqlApp{onames&'.Count()'}
ServerQ.Name = ?osqlApp{onames&'.Item('&i&')'}
add(Serverq)
!message(server)
!message(serverq)
IF Serverq=server THEN
return 1
end
End

At this point..my requirement is ...I want to have an combo box and this
combo box should get filled up the datas(servers installed in the
network)returned from the clarion that is the dll in run time.Is that
possible.

or do you have anyother method with using the dll to get this work
done.Please do help me. if not atleast tell me how to queue up or populate
the combo box at runtime.

Regards,
padma