Subject Re: Firebird ODBC: only one connection at the same time?
Author kandalf4711
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
> > i connect to the firebird database over ODBC.
> > Now i have the problem, that only one connect can be active at the
> > same time. I have several threads in my programm and each thread has
> > obe connect to the database. That's not possible just in time, the
> > second connect hang an became no response.
> >
> > Can i set the number of open connections anywhere?
>
> What is your connect string?
>
> Does it include a server name? If not, try it like this:
> severname:pathtodatabase
>

I connect over ODBC with teh standard function:
rc = SQLConnect(pConPar->hDbc, pDSN, SQL_NTS, pCONNECT->pUID,
(SWORD) (pCONNECT->pUID ? SQL_NTS : 0), pCONNECT->pPWD,
(SWORD) (pCONNECT->pPWD ? SQL_NTS : 0));

i configured the odbc admin
DSN = IC2DB_FB
DATABASE=C:\Firebird\data\IC2DB.FDB