From: leif@danmos.dk
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Newbie question
Date: Tue, 2 Jun 98 20:51 WDT
Message-ID: <m0ygwJA-000G4UC@danmos> (raw)
Hello,
> > running
> > under Windows 95 without the ODBC interface, I just need to hook it up
> > to
> > my PostgreSQL database.
> >
> > Could someone please give me a step-by-step idea of how to get ODBC
> > running on Win95 and whatever tools/programs is needed for that?
> Well, I've never done it myself, but I'll give it a shot.
> 1) get the newest driver from http://www.insightdist.com/psqlodbc and
> compile it
> 2) set up your PostgreSQL database to use TCP/IP
> A) to do this add in the '-i' option when you start the postmaster
> B) edit you pg_hba.conf file appropriately.
> 3) Make sure you program is connecting to the correct machine, username,
> and password.
>
Thanks for the information. I had already done that. I am afraid I
forgot to tell you that I have never used ODBC on Windows before and I
have a hard to figuring out how to make my program connecting to the
PostgreSQL database on the server. Do I need a ODBC Manager or something ?
And if so where do I get it? How do I set up Windows 95?
> FYI, there is a self-extracting, fully functional installation there
> (postdrv.exe) for win95 -- you dont have to mess around with compiling if
> you don't want to. There is also just the compiled dll (postdll.zip), for
> those who have done the full install at least once (just unzip into
> \windows\system).
>
Great! Thanks! That helped, after fooling around in the ODBC DBA for
a while, I finally figured out to make a new SystemDSN, where I could
connect to the driver (well, I said it was a newbie question, also with
respect to ODBC ;-). Now I can connect and talk to the database.
Just a little additional question: I seem to have trouble with varchar.
I don't seem to get anything if it is defined as varchar, but it is OK if
it char ?!
Thanks in advance,
___________________________________________________________________________
/
_/ _/_/ / Leif Jensen (leif@danmos.dk)
_/ _/ _/ /
_/ _/_/ _/_/_/ /
_/ _/ _/ _/ _/ / Linux 2.0.29, gcc 2.7.2, wxWin 1.66F
_/ _/ _/_/ _/ _/ /
_/ _/ _/ _/ _/ /
_/_/_/_/ _/_/ _/_/ _/ / (and Windows 95 :-(
___________________________________________________________________________
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: leif@danmos.dk
Subject: Re: [INTERFACES] Newbie question
In-Reply-To: <m0ygwJA-000G4UC@danmos>
* 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