Forum Discussion
Mosel: Error located at line 136 of `bin\model.mos'. Mosel: Dumping call stack (2/2): Mosel: #0 line 136 of `bin\model.mos' Mosel: #1 line 980 of `bin\model.mos'
i got this error when i was running the for loop which i mentioned in the previous question now in the line 136 i am connecting to database using sqlconnect and connectionstring and executing a inser...
The error message you have reported earlier says that the connection failed: is this on the first attempt (=first iteration calling the subroutine) or on a subsequent one? If you need to invoke several SQL statements, I would recommend to connect to the database only once (from the first iteration, or before invoking this subroutine), keep the connection open through the desired number of iterations and close the connection after the last one.
