From: byronn@insightdist.com
To: kk@kdschmid.de
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [NOVICE] ODBC-Setup
Date: Tue, 2 Feb 99 9:31:36 EST
Message-ID: <9902021431.AA49810@ceodev> (raw)
In-Reply-To: <36B780B3.20A7@kdschmid.de>
>
> Hi,
>
> I believe this belongs to the novice section:
Actually, this is a good one for "interfaces".
>
> I got postgres6.4.2, it compiled and works fine, as long as I stay on th
> localhost. My server's name is Capella on 192.168.0.3 and I don`t get
> connected.
> - I can see networktraffic from my station to capella using tcpdump on
> capella when accessing samba-drives.
> -I can see NO networktraffic from my station to capella using tcpdump on
> capella when trying to connect to a database.
>
> -Postgres was configured --with-odbc
>
> -Yes, I do use the -i option with postmaster.
>
> This is what m$access says, when I try to connect
> ----------------------------------------------------------------------
> Verbindung fehlgeschlagen (connection failed)
> SQLStat 01000
> SQL Server Error: -1
> [Microsoft][ODBC SQL Server Driver][dbnmp3]ConnectionOpen (sopen())
> Verbindung fehlgeschlagen (connection failed)
> SQLStat 08001
> SQL Server Error: 0
> ----------------------------------------------------------------------
>
> Is [Microsoft][ODBC SQL Server Driver][dbnmp3] part of correct driver?
> Here is no hint, that I'm using the postgres driver
>
> This is a logfile (from postgresdriver?):
> ----------------------------------------------------------------------
> DSN info:
> DSN='PostgreSQL',server='192.168.0.3',port='5432',dbase='kk1',user='www',passwd='secret'
>
> readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
> conn_settings=''
> translation_dll='',translation_option=''
> ----------------------------------------------------------------------
Can you try again and this time try to get a better "psqlodbc.log" file. It is created during an odbc session. You should be able to see the connect attempt and error message. The clip above is either a different session or just a portion of it.
> user www had had a 'GRANT all on bar to www' and a 'create user www with
> password secret'
> and he can connect to the database when typing on the console of
> capella.
>
> Is there any idea outside what is wrong here, or where I can read about
> setting up ODBC for
> Windows95/98?
There is a good bit of information on the various settings at our web site (http://www.insightdist.com/psqlodbc). Should be an area there called configuration settings, as well as a FAQ.
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, kk@kdschmid.de
Subject: Re: [NOVICE] ODBC-Setup
In-Reply-To: <9902021431.AA49810@ceodev>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox