Toad World® Forums

Question from TDA noobie


#1

Hi everyone, using the trial version of TDA and have a question, I hope someone might know the answer.

Among the DBs I need to connect are Avaya CMS switches running Informix, I connect via ODBC settings and Iknow it works (existing reports in Crystal Reports). When I try to connect with TDA using ODBC I get an error message Informix Server - Cannot support multiple connections over shared memory.

I know that if I try to connect twice to the switch with the same user name (for example, in a SQL client and in Crystal) I get that error message but in this case I’m just trying to connect with one client.

Has anyone experienced this or know of a work-around?


#2

TDA maintains a pool of connections for performance reasons and unfortunately there is no way to make it use a single connection.