Skip site navigation (1) Skip section navigation (2)

Re: ODBC error and concurrent connections question

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Francesco Lilley <f(dot)lilley(at)gruppobiesse(dot)it>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC error and concurrent connections question
Date: 2005-12-12 12:10:59
Message-ID: 20051212121059.GA7515@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
> 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

In response to

pgsql-odbc by date

Next:From: AndrusDate: 2005-12-12 17:16:42
Subject: Re: Access violation C5 error on Visual FoxPro SQLEXEC() call after error
Previous:From: Francesco LilleyDate: 2005-12-12 09:12:54
Subject: ODBC error and concurrent connections question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group