pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing psqlodb.dll with a 16-bits application
3+ messages / 2 participants
[nested] [flat]
* Using psqlodb.dll with a 16-bits application
@ 1998-07-07 10:35 Alexander Elsenaar <a.elsenaar@viewpoint.nl>
0 siblings, 0 replies; 3+ messages in thread
From: Alexander Elsenaar @ 1998-07-07 10:35 UTC (permalink / raw)
To: pgsql-interfaces
I have got an 16 bits application with I want to use with PostgreSQL via ODBC. On the PSQLODBC-site I found
that this i possible if the application is running on Windows95. This is the case.
Can anyone tell my how I can configure the 16-bits ODBC-Manager for use with PSQLODBC?
Thanks in advance!
Alexander Elsenaar
A.Elsenaar@viewpoint.nl
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: RE: [INTERFACES] Using psqlodb.dll with a 16-bits application
@ 1998-07-07 11:15 Alexander Elsenaar <a.elsenaar@viewpoint.nl>
0 siblings, 1 reply; 3+ messages in thread
From: Alexander Elsenaar @ 1998-07-07 11:15 UTC (permalink / raw)
To: pgsql-interfaces
-----Oorspronkelijk bericht-----
Van: Olaf Mittelstaedt [SMTP:MSTAEDT@va-sigi.va.fh-ulm.de]
Verzonden: dinsdag 7 juli 1998 13:05
Aan: Alexander Elsenaar
Onderwerp: Re: [INTERFACES] Using psqlodb.dll with a 16-bits application
> I have got an 16 bits application with I want to use with PostgreSQL via ODBC. On the PSQLODBC-site I found
> that this i possible if the application is running on Windows95. This is the case.
>
> Can anyone tell my how I can configure the 16-bits ODBC-Manager for use with PSQLODBC?
You can't use the 16Bit ODBC manager to create/configure 32Bit ODBC
data sources. And you don't need it because you can use any data
source created with the 32Bit ODBC manager ODBCAD32.EXE in your 16Bit
applications!
[Alexander Elsenaar] Thanks voor your reaction but my problem is bigger. The application I am talking about is calling directly the 16 -bits ODBC-manager (ODBCINST.DLL, found this out using Wine!). It is not a regular application but a development environment. (Clarion for Windows 2.003) and I am trying to import a table definition. Any other sugestion?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Using psqlodb.dll with a 16-bits application
@ 1998-07-07 16:49 James Olin Oden <joden@Lee.k12.nc.us>
parent: Alexander Elsenaar <a.elsenaar@viewpoint.nl>
0 siblings, 0 replies; 3+ messages in thread
From: James Olin Oden @ 1998-07-07 16:49 UTC (permalink / raw)
To: Alexander Elsenaar <a.elsenaar@viewpoint.nl>; pgsql-interfaces
> It is not a regular application but a development environment. (Clarion for Windows 2.003) and I am trying to import a table definition. Any other sugestion?
If this is just a one time thing and you are going from Clarion to Postgress, just export the DBF files (I believe Clarion is DBF formated) as SDF format, and transfer this file over to the Postgres machine. Once there use the copy command to get them in, or write a quick awk script to generate a bunch of selects.
If your going the other way do a select on the table selecting all fields, such as:
select * from blah;
write this select statement to a file and then type:
psql -f queryfile > results
Now you have a fixed length text file (with little bars between each field). With a little massaging you should be able to export it into Clarion.
These are one time solutions though, and will not help you if you need to do this over and over again...james
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-07-07 16:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-07 10:35 Using psqlodb.dll with a 16-bits application Alexander Elsenaar <a.elsenaar@viewpoint.nl>
1998-07-07 11:15 RE: RE: [INTERFACES] Using psqlodb.dll with a 16-bits application Alexander Elsenaar <a.elsenaar@viewpoint.nl>
1998-07-07 16:49 ` James Olin Oden <joden@Lee.k12.nc.us>
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