'Transaction not connected' error trying to connect to an ODBC database via PB7 Com in MTS

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.

-bac

0 Robert 12/18/2000 10:06:37 PM

More details...

DTS IS running on SQL Server.

"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.
>
> -bac

0 Robert 12/19/2000 7:04:01 PM

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
    ie, comtest.pbl("d_datawindowname")
    *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...

-bac

"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.
>
> -bac

0 Robert 12/20/2000 5:54:35 PM