Question Query remote SQL server from progress program.

[Courtney White]

I need a push in the right direction, and then I should be able to figure this out.
Our users want a browse that includes a field that contains a logical value from a mssql server.
I've explained to them that whatever we do, it's going to be extremely slow, but they insist.

I'd like to make a local variable function that executes a remote query, but I can't seem to be able to find any information on making a remote query inside a progress program.

Is there any function where I can supply it an IP and port, username and password, database and query?
anything similar?

Thank you, and Happy Holidays!

 

[Stefan]

Lookup ado.net. There is a document on www.winningfamily.com ( strange URL I know), select work stuff.

You could also use the send-sql-statement buffer, but that does require a DataServer license.