Heres what I did to make it work.
1) Make sure the datawindow(s) being referenced is listed in the .pbr
file for the project
*You could also place a check mark next to the .pbl name in the com
generator project, which will include all objects (overkill).
2) Use OLEDB type connection .vs. ODBC
3) Put the SQLCA transaction creation/connnection/destruction in the
method, instead of the constructor for the nvo.
I realize this is not exactly how things have to be, but it fixed the
problems I was having.
Still looking for a good guide...
"Robert A. Chauvin" wrote:
> Non-database com object in MTS works aok, but connecting to a MSSQL
> Server database fails with "Transaction not connected" error.
> Seems like a rudimentary issue.
> Any tutorials or white papers re PB7/MSSqlServer 6.5/MTS?
> Any help apprecicated.