NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: wasatchconsulting on July 24, 2013, 06:44:55 PM

Title: Accessing another MSSQL table issue
Post by: wasatchconsulting on July 24, 2013, 06:44:55 PM

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

Title: Re: Accessing another MSSQL table issue
Post by: kevin plummer on July 24, 2013, 07:03:25 PM

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