pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedNewbie question
8+ messages / 7 participants
[nested] [flat]
* Newbie question
@ 1998-06-01 16:59 leif@danmos.dk
0 siblings, 0 replies; 8+ messages in thread
From: leif@danmos.dk @ 1998-06-01 16:59 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
Please forgive me for a newbie question!
I have just installed and are running PostgreSQL 6.3.2 fine including
psql on Linux 2.0.33.
I need to get access to it from several Windows 95 worstations using ODBC.
I have a C++ program that are using ODBC/SQL... calls, which works fine on
Linux using Sergey's pgodbc interface. The C++ program is written using a
cross platform GUI library called wxWindows. This program is already 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?
I also have a PostgreSQL question: I have had the need for changing
the attribute of a column, e.g. int2 -> int4 or char(10) -> char(20).
psql doesn't seem to report how to do it, and whatever I tried failed.
Is it at all possible? I have been working quite a lot with the very old
Informix database, and here it is a simple matter for 'isql'.
Thanks in advance,
___________________________________________________________________________
/
_/ _/_/ / Leif Jensen (leif@danmos.dk)
_/ _/ _/ /
_/ _/_/ _/_/_/ /
_/ _/ _/ _/ _/ / Linux 2.0.29, gcc 2.7.2, wxWin 1.66F
_/ _/ _/_/ _/ _/ /
_/ _/ _/ _/ _/ /
_/_/_/_/ _/_/ _/_/ _/ / (and Windows 95 :-(
___________________________________________________________________________
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: [INTERFACES] Newbie question
@ 1998-06-01 20:13 Jackson, DeJuan <djackson@cpsgroup.com>
0 siblings, 1 reply; 8+ messages in thread
From: Jackson, DeJuan @ 1998-06-01 20:13 UTC (permalink / raw)
To: leif@danmos.dk; pgsql-interfaces
> Hello,
>
> Please forgive me for a newbie question!
>
> I have just installed and are running PostgreSQL 6.3.2 fine
> including
> psql on Linux 2.0.33.
>
> I need to get access to it from several Windows 95 worstations using
> ODBC.
> I have a C++ program that are using ODBC/SQL... calls, which works
> fine on
> Linux using Sergey's pgodbc interface. The C++ program is written
> using a
> cross platform GUI library called wxWindows. This program is already
> 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.
> I also have a PostgreSQL question: I have had the need for changing
> the attribute of a column, e.g. int2 -> int4 or char(10) -> char(20).
> psql doesn't seem to report how to do it, and whatever I tried failed.
> Is it at all possible? I have been working quite a lot with the very
> old
> Informix database, and here it is a simple matter for 'isql'.
You could try:
ALTER TABLE table_name RENAME TO tmp_table;
CREATE TABLE table_name (new_columns ...);
INSERT INTO table_name SELECT old_columns ... FROM tmp_table;
DROP TABLE tmp_table;
recreate the indexes and maybe VACUUM ANALYZE
The only problem with this is you'll have to make sure you can convert
from the original column type to the new one, 6.4 should handle this a
lot better when it comes out.
> Thanks in advance,
You're welcome.
Hope this helps,
-DEJ
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Newbie question
@ 1998-06-01 20:36 Byron Nikolaidis <byronn@insightdist.com>
parent: Jackson, DeJuan <djackson@cpsgroup.com>
0 siblings, 0 replies; 8+ messages in thread
From: Byron Nikolaidis @ 1998-06-01 20:36 UTC (permalink / raw)
To: Jackson, DeJuan <djackson@cpsgroup.com>; +Cc: leif@danmos.dk; pgsql-interfaces
Jackson, DeJuan wrote:
> > 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
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).
Byron
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Newbie question
@ 1998-06-02 20:51 leif@danmos.dk
0 siblings, 0 replies; 8+ messages in thread
From: leif@danmos.dk @ 1998-06-02 20:51 UTC (permalink / raw)
To: pgsql-interfaces
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 :-(
___________________________________________________________________________
^ permalink raw reply [nested|flat] 8+ messages in thread
* newbie question ?
@ 2000-01-17 16:45 Pascal Drouilly <pascal_drouilly@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: Pascal Drouilly @ 2000-01-17 16:45 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
Hi,
I searched and cannot find if
PsqlODBC driver for Windows from
Insight Distribution Systems
will be upgraded to version 6.5.x
of PosgreSQL
(I had a bug in postgres 6.4.2 solved
by upgrading to 6.5.3, but now
I have lost my Excel<->Postgres link...)
anyone can help me on this one ?
(6.5.x is out since ~1 years ?)
Thanks
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Fwd: Re: [INTERFACES] newbie question ?
@ 2000-01-17 21:10 Compte utilisateur Sultan-advl <webmaster@advl.org>
0 siblings, 0 replies; 8+ messages in thread
From: Compte utilisateur Sultan-advl @ 2000-01-17 21:10 UTC (permalink / raw)
To: pgsql-interfaces
Le lun, 17 jan 2000, vous avez écrit :
Postgresql 6.5.2 & PostODBC 6.40.0007 'works' for me.
Emmanuel.
> Hi,
>
> I searched and cannot find if
> PsqlODBC driver for Windows from
> Insight Distribution Systems
> will be upgraded to version 6.5.x
> of PosgreSQL
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] newbie question ?
@ 2000-01-18 02:40 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Pascal Drouilly <pascal_drouilly@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: Thomas Lockhart @ 2000-01-18 02:40 UTC (permalink / raw)
To: Pascal Drouilly <pascal_drouilly@yahoo.com>; +Cc: pgsql-interfaces@hub.org
> I searched and cannot find if
> PsqlODBC driver for Windows from
> Insight Distribution Systems
> will be upgraded to version 6.5.x
> of PosgreSQL
> anyone can help me on this one ?
> (6.5.x is out since ~1 years ?)
Right. And the driver was too. Try it!
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] newbie question ?
@ 2000-01-18 09:05 Moray McConnachie <moray.mcconnachie@computing-services.oxford.ac.uk>
parent: Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Moray McConnachie @ 2000-01-18 09:05 UTC (permalink / raw)
To: Thomas Lockhart <lockhart@alumni.caltech.edu>; +Cc: pgsql-interfaces@hub.org
Presumably the question arises because the driver options dialogue box
specifies only 6.2, 6.3 and 6.4 . It is not immediately obvious to new users
that the 6.4 option will work with 6.5.
Yours,
Moray
----- Original Message -----
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Pascal Drouilly <pascal_drouilly@yahoo.com>
Cc: <pgsql-interfaces@hub.org>
Sent: Tuesday, January 18, 2000 2:40 AM
Subject: Re: [INTERFACES] newbie question ?
> > I searched and cannot find if
> > PsqlODBC driver for Windows from
> > Insight Distribution Systems
> > will be upgraded to version 6.5.x
> > of PosgreSQL
> > anyone can help me on this one ?
> > (6.5.x is out since ~1 years ?)
>
> Right. And the driver was too. Try it!
>
> - Thomas
>
> --
> Thomas Lockhart lockhart@alumni.caltech.edu
> South Pasadena, California
>
> ************
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2000-01-18 09:05 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-01 16:59 Newbie question leif@danmos.dk
1998-06-01 20:13 RE: [INTERFACES] Newbie question Jackson, DeJuan <djackson@cpsgroup.com>
1998-06-01 20:36 ` Byron Nikolaidis <byronn@insightdist.com>
1998-06-02 20:51 Re: [INTERFACES] Newbie question leif@danmos.dk
2000-01-17 16:45 newbie question ? Pascal Drouilly <pascal_drouilly@yahoo.com>
2000-01-18 02:40 ` Re: [INTERFACES] newbie question ? Thomas Lockhart <lockhart@alumni.caltech.edu>
2000-01-18 09:05 ` Re: [INTERFACES] newbie question ? Moray McConnachie <moray.mcconnachie@computing-services.oxford.ac.uk>
2000-01-17 21:10 Fwd: Re: [INTERFACES] newbie question ? Compte utilisateur Sultan-advl <webmaster@advl.org>
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