Get error when run multi-users ODBC test
I need help with my perfomance testing.
I recorded script for testing my ODBC application and made parametrization. It works correct when I do "try script".
But when I run script with a few VU I've got the problem.
As I understand when second VU tries to connect to DB the errors come:
"5 - ODBC error, IM002(0) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
I have such code for VU login where the error arises:
OdbcSetEnvAttr(ghEnv1, SQL_ATTR_ODBC_VERSION, SQL_OV_ODBC3);
OdbcAlloc(SQL_HANDLE_DBC, ghDbc1, ghEnv1);
OdbcSetConnectAttr(ghDbc1, SQL_ATTR_ODBC_CURSORS, SQL_CUR_USE_IF_NEEDED);
OdbcConnect(ghDbc1, psLogin_dns, psLogin_name, psLogin_pass);
Please, help. I lost all hope of running the test in multiuser mode
Re: Get error when run multi-users ODBC test
Are you running your VUs from agent machines or on the same machine that you ran the 'try script' from? It sounds from that error that it's from agent machines that don't have the ODBC settings configured for the DB you're trying to connect to. Or your parameter for the ODBCConnect command (psLogin_dns) is not being populated with the correct value.