Subject | Re: [firebird-support] Re: Firebird ODBC: only one connection at the same time? |
---|---|
Author | Martijn Tonies |
Post date | 2005-06-20T13:14:57Z |
> > > i connect to the firebird database over ODBC.Try:
> > > 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
DATABASE=servername:C:\Firebird\data\IC2DB.FDB
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com