Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: plz do help me.

Re: plz do help me.

From
"Mohan "
Date:
Dear sir/madam,

we r using postgres-7.4.6 in redhat 9 & fedora core 2. i am facing problem
in odbc connectivity in visual basic to pgsql linux , while i try to connect
odbc in VB i am getting error message as "Data Access Error".pls do help me
in this regard, waiting ur valuable reply in this regard.

with regards
Mohan

Re: plz do help me.

From
Richard Huxton
Date:
Mohan wrote:
> Dear sir/madam,
> we r using postgres-7.4.6 in redhat 9 & fedora core 2. i am facing problem
> in odbc connectivity in visual basic to pgsql linux , while i try to
> connect odbc in VB i am getting error message as "Data Access Error".pls
> do help me  in this regard, waiting ur valuable reply in this regard.

What is the full error message?
When do you get it?
Do the PostgreSQL logs show anything?

--
   Richard Huxton
   Archonet Ltd

Re: plz do help me.

From
Richard Huxton
Date:
Could you cc: the mailing list as well as replying to me? That way, if
anyone else can help they can see the messages too.

Mohan wrote:
> Sir,
> i have installed pgsql in fedora core 2, i have created users in pgsql,
> we have created tables, there is no problem in creating tables ,
> everything working fine when we connect to pgsql and work by using ssh
> login.

Can you connect over the network from your Windows client (using
pgadmin/psql)?

> The pgsql windows odbc package has been installed in windows machine, i
> have created dsn in windows machine for pgsql by odbc connectivity,
> the problem is that "unable to connect to server" and after that we got
> Data Access Error"

What do the PostgreSQL logs show? Is there any record of your connection
attempt?
1. Update your postgresql.conf to record connections, restart PG and
test the logging works by connecting locally.
2. Then, try connecting from the Windows PC.
3. If there is no record of a connection in the PostgreSQL logs, you
should check two things:
   i. Have you enabled internet connections in postgresql.conf?
(tcpip_socket or listen_addresses)
  ii. Is your firewall blocking connections (check system logs)

If there is a connection attempt in the logs, it should say why it
failed. You can post the log here and we'll see what we can do.
--
   Richard Huxton
   Archonet Ltd

Re: i will reinstall it & check it- reg

From
Richard Huxton
Date:
Mohan wrote:
> Sir,
> i will install freshly fedora core 3 in the machine and i check it, sir
> plz give me the details how to check that there is no problem with odbc
> connectivity, give me ur valuable tips for me, tomorrow morning i check
> it and mail u regarding it.

Please CC the mailing list as well as me - that way others can help you.

As I said in my last email:

1. Turn connection logging on.
2. Make sure you can connect over the network without using ODBC
3. Post the error message you will see in the logs.

--
   Richard Huxton
   Archonet Ltd