From ErikFerencz@seznam.cz Mon Jul 24 15:56:34 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9EC4A9FA7B6 for ; Mon, 24 Jul 2006 12:56:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 78752-02 for ; Mon, 24 Jul 2006 15:56:25 +0000 (UTC) X-Greylist: delayed 00:18:08.709475 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id DB88E9FAC9B for ; Mon, 24 Jul 2006 12:56:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from tron.kn.vutbr.cz (tron.kn.vutbr.cz [147.229.191.152]) by svr4.postgresql.org (Postfix) with ESMTP id EF8E75AFB21 for ; Mon, 24 Jul 2006 15:38:11 +0000 (GMT) Received: from a040726a (a04-0726a.kn.vutbr.cz [147.229.217.140]) by tron.kn.vutbr.cz (8.12.9p2/8.12.9) with SMTP id k6OFc7L3070458 for ; Mon, 24 Jul 2006 17:38:07 +0200 (CEST) (envelope-from ErikFerencz@seznam.cz) Message-ID: <000601c6af37$28260440$8cd9e593@a040726a> From: "Erik Ferencz" To: Subject: ODBC connection problem Date: Mon, 24 Jul 2006 17:37:59 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0003_01C6AF47.E818DC40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Scanned: clamd / ClamAV version 0.70, clamav-milter version 0.70j X-Scanned-By: milter-spamc/0.19.268 (tron [147.229.191.152]); Mon, 24 Jul 2006 17:38:07 +0200 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.227 tagged_above=0 required=5 tests=DNS_FROM_RFC_POST, HTML_50_60, HTML_MESSAGE, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200607/229 X-Sequence-Number: 22475 This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C6AF47.E818DC40 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi. I have got a problem with connection to my Postgres DB. I have Win2003 server with Postgres 8.1.4 instalation. Let's call this server server2003 I wrote an application in C#.This application is connecting to my = Postgre DB on server2003. When I start this application on my local computer,everithing is fine,it = connect to DB.(the .exe file is stored on local computer) When I start this application on server2003 computer,everithing is = fine,it connect to DB.(the .exe file is stored on server2003 computer) But,when I store this application on server2003 and trying to run this = application from my local computer (via File Shareing(SMB)) I can't = connect to PostgreDB. I heve temporally stoped firewall,but it does not helped.=20 Could anyone help me please. I will be gratful. Thank you Erik Ferencz ------=_NextPart_000_0003_01C6AF47.E818DC40 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
Hi.
I have got a problem with connection to = my Postgres=20 DB.
 
I have Win2003 server with Postgres = 8.1.4=20 instalation.
Let's call this server = server2003
 
I wrote an application in C#.This = application is=20 connecting to my Postgre DB on server2003.
When I start this application on my = local=20 computer,everithing is fine,it connect to DB.(the .exe file is stored on = local=20 computer)
When I start this application = on server2003=20 computer,everithing is fine,it connect to DB.(the .exe file is stored=20 on server2003 computer)
But,when I store this application on = server2003 and=20 trying to run this application from my local computer (via File = Shareing(SMB)) I=20 can't connect to PostgreDB.
I heve temporally stoped = firewall,but it does=20 not helped. 
 
Could anyone help me please. I will be=20 gratful.
 
Thank you
 
Erik Ferencz
------=_NextPart_000_0003_01C6AF47.E818DC40-- From postgresql@aranya.com Fri Jul 28 18:54:11 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1BB919FB27A for ; Fri, 28 Jul 2006 15:54:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 75024-07 for ; Fri, 28 Jul 2006 15:53:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 256179FB278 for ; Fri, 28 Jul 2006 15:53:50 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so275091nfc for ; Fri, 28 Jul 2006 11:53:49 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=iWdhdLsVYpwhn3cELynAzq+ayYMiDlWbvB+tr1VpTo9JUXQVEdMTiaVxiYg2NQ35Fhzjlgy5t8GZAU459bY6mBBTXA7XwPRwGmPgPRE+n7Did9HLFlqM+w3vUkI7swq1ultZyHY46afVVZzEutm6+nfng65w+VLFUgQYluIGx58= Received: by 10.78.118.19 with SMTP id q19mr266834huc; Fri, 28 Jul 2006 11:53:49 -0700 (PDT) Received: by 10.78.32.10 with HTTP; Fri, 28 Jul 2006 11:53:49 -0700 (PDT) Message-ID: Date: Fri, 28 Jul 2006 13:53:49 -0500 From: "Aaron Bono" To: "Erik Ferencz" Subject: Re: ODBC connection problem Cc: pgsql-admin@postgresql.org In-Reply-To: <000601c6af37$28260440$8cd9e593@a040726a> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13188_9125517.1154112829060" References: <000601c6af37$28260440$8cd9e593@a040726a> X-Google-Sender-Auth: da5e13b4b4d1d2ea X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.576 tagged_above=0 required=5 tests=AWL, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/265 X-Sequence-Number: 22511 ------=_Part_13188_9125517.1154112829060 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/24/06, Erik Ferencz wrote: > > Hi. > I have got a problem with connection to my Postgres DB. > > I have Win2003 server with Postgres 8.1.4 instalation. > Let's call this server server2003 > > I wrote an application in C#.This application is connecting to my Postgre > DB on server2003. > When I start this application on my local computer,everithing is fine,it > connect to DB.(the .exe file is stored on local computer) > When I start this application on server2003 computer,everithing is fine,it > connect to DB.(the .exe file is stored on server2003 computer) > But,when I store this application on server2003 and trying to run this > application from my local computer (via File Shareing(SMB)) I can't connect > to PostgreDB. > I heve temporally stoped firewall,but it does not helped. > > Could anyone help me please. I will be gratful. > Sounds more like a network or application configuration issue than a PostgreSQL issue. What error message are you getting when it fails to connect? Did you add any debugging to the application? What does your connection string look like in each of the 3 above situations? ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com ================================================================== ------=_Part_13188_9125517.1154112829060 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/24/06, Erik Ferencz <ErikFerencz@seznam.cz> wrote:
Hi.
I have got a problem with connection to my Postgres DB.
 
I have Win2003 server with Postgres 8.1.4 instalation.
Let's call this server server2003
 
I wrote an application in C#.This application is connecting to my Postgre DB on server2003.
When I start this application on my local computer,everithing is fine,it connect to DB.(the .exe file is stored on local computer)
When I start this application on server2003 computer,everithing is fine,it connect to DB.(the .exe file is stored on server2003 computer)
But,when I store this application on server2003 and trying to run this application from my local computer (via File Shareing(SMB)) I can't connect to PostgreDB.
I heve temporally stoped firewall,but it does not helped. 
 
Could anyone help me please. I will be gratful.

 
Sounds more like a network or application configuration issue than a PostgreSQL issue.

What error message are you getting when it fails to connect?  Did you add any debugging to the application?  What does your connection string look like in each of the 3 above situations?

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
================================================================== ------=_Part_13188_9125517.1154112829060--