ODBC error and concurrent connections question

This is a multi-part message in MIME format.

------=_NextPart_000_005A_01C5FF04.9E0D7000
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_005B_01C5FF04.9E0D7000"

------=_NextPart_001_005B_01C5FF04.9E0D7000
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=20

Informativa ai sensi del Decr.Lgs Privacy n.196/2003
I dati in nostro possesso vengono impiegati per attivit=E0 di marketing =
e supporto tecnico nei termini previsti dalla normativa vigente. In ogni =
momento l'interessato potr=E0 avvalersi dei diritti e nelle modalit=E0 =
previste della Legge.
Il titolare del trattamento =E8 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=E0 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.

------=_NextPart_001_005B_01C5FF04.9E0D7000
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

Re: ODBC error and concurrent connections question

> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org