| || |
Repeated ODBC connect problem
To emulate the user interactions, I need to call some function from main VU script several times. That function is simple and looks like this:
int func GetId()
conn = sqlconnect(<SQL2000 server through ODBC>
set Server_connection = conn;
return <some value from DB>
the problem is that the second sequential call if going to fail with _error = 40021, _error_text = ""
and "set Server_connection" command issues an "invalid connection descriptor" error.
The only work-around I've reached so far - to have identical functions with different names - and it seems to be working. But maybe there's some other solution? Does anyone have such problem?