Powerbuilder 6.5 call to API on network server

[Denwich]

powerbuilder 6.5 needing to call api on network server.

Just have windows version (written in c) of ADP software and need to call api that is located on SQL server 2008 R2 box.

Created external function to call api, but need to know how to code and access SQL server 2008 R2 box. I can connect to the database on that box with no problem.

FUNCTION int CapiTaxRoutine (ref str_adp_taxinbuffer taxinparm,ref str_adp_taxoutbuffer taxoutparm, int taxin_length) LIBRARY "taxcommono.dll"

I have no idea how to do this and would appreciate any help I can get!!! code examples would be wonderful!!

Thanks,
Denise

 

[mbalent]

You may be better off coding an Assembly in .Net and calling it via a SQL stored procedure from PB. If you google the phrase "calling assembly from sql server" you can find many examples.

If you structure your stored proc to return results, you could use it to create a datawindow object in PB.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com