NetTalk Central

Author Topic: Accessing another MSSQL table issue  (Read 2608 times)

wasatchconsulting

  • Jr. Member
  • **
  • Posts: 72
    • View Profile
    • Email
Accessing another MSSQL table issue
« 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

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Accessing another MSSQL table issue
« Reply #1 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