Postgres Pro
Downloads
Home   >   mailing lists

Thread: ODBC error and concurrent connections question

ODBC error and concurrent connections question

From
"Francesco Lilley"
Date:
Hello everyone!
I've just installed postgres 8.1 on my pc whcih runs Windows 2000 Professional.
But i have a problem: i've created a  Test table, and then installed and created the Odbc on another pc different from the pc on which i installed the Postgres Server.
I created a C-like program and the first time it was all ok, but after i can't connect to the machine through Odbc, so i create new odbc, but nothing, now i'm not able to connect to the sever. The program returns me an ODBC error! Why? It's very strange!
 
I've installed Postgres because i ha ve the necessity to have a Db able to manage multiple concurrent connections, but i'm new and i don't know how to program and set the Postgres DB in order to do this. Ehat i have to do in order to have automatic serialization with concurrent connections?
 
Please Help me!!
Thank you very much in advance!!
Francesco.
 

Dott. FRANCESCO LILLEY
Ufficio Tecnico
BIESSE SERVIZI s.r.l.
P.za Garibaldi, 2
14049 Nizza Monferrato (AT)
Tel  +39 0141 793233
Fax +39 0141 721676
www.gruppobiesse.it
E.mail f.lilley@gruppobiesse.it

Informativa ai sensi del Decr.Lgs Privacy n.196/2003
I dati in nostro possesso vengono impiegati per attività di marketing e supporto tecnico nei termini previsti dalla normativa vigente. In ogni momento l’interessato potrà avvalersi dei diritti e nelle modalità previste della Legge.
Il titolare del trattamento è la BIESSE SISTEMI SPA, con sede in Grugliasco, Strada del Gerbido 49, tel. 0114088811 – info@gruppobiesse.it
Disclaimer
Quanto sopra e' espressione del mittente.
La società BIESSE SISTEMI SPA non si fa carico di omissioni o errori dovuti alla trasmissione via Internet. Le informazioni contenute nel presente messaggio sono destinate esclusivamente al/ai destinatario/i in esso indicato/i.
Qualora riceviate il presente messaggio per errore, vi preghiamo di voler cortesemente darcene notizia via e-mail ( info@gruppobiesse.it) e di provvedere ad eliminare il messaggio ricevuto erroneamente, essendo ogni utilizzo, divulgazione, distribuzione o copia dello stesso vietata dalla Legge.

Attachment

Re: ODBC error and concurrent connections question

From
Ludek Finstrle
Date:
> But i have a problem: i've created a Test table, and then installed
> and created the Odbc on another pc different from the pc on which
> i installed the Postgres Server.
> I created a C-like program and the first time it was all ok, but
> after i can't connect to the machine through Odbc, so i create new

After what you can't connect? I think this is postgresql related question.
Can you connect server through psql command line client?
If you can't connect with psql then the problem is on server side.

Could you ping to the server? Does ODBC and C program work on server?
Do you have well filled datasource parameters like server name,
server port, SSL mode, database name, user name and password?

> odbc, but nothing, now i'm not able to connect to the sever.
> The program returns me an ODBC error! Why? It's very strange!

What error do you get? We're not crystal gazers ...
Could you post mylog output?

> Ehat i have to do in order to have automatic serialization with
> concurrent connections?

Isn't it again postgresql related question? I think there is pgsql-novice
mailing list for these question. It isn't ODBC related.
You can try study transaction isolation ... It's well documented on
www.postgresql.org/docs/

Regards,

Luf