Accessing another MSSQL table issue

[wasatchconsulting]

This was working prior to version 7.12.

I have run into an issue with accessing an additional MSSQL table in the code to gather some additional information. The tables are related and I can add this as a related table to the primary table, but this ends up creating multiple rows for each primary record as there are multiple records in the child table.

I include the required table in the "Other Files" section for the procedure. When I try to access the file I get "connection is busy - s1000" error. I have the MARS option on the table, I even checked the code, but yet it still gives me this error.

Thanks
Ken Watts
Wasatch Consulting Services

[kevin plummer]

My experience is you need the following and it needs to be set before any tables in the DB are opened. If you use FM3 there is a space on the template to add this driver string as it needs to be set before FM3 does it's magic.

/MULTIPLERESULTSETS=TRUE /BUSYHANDLING=2