Thread: Re: [INTERFACES] Newbie question

Re: [INTERFACES] Newbie question

From
leif@danmos.dk
Date:
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 :-(
___________________________________________________________________________