pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPOSTOBDC
9+ messages / 6 participants
[nested] [flat]
* POSTOBDC
@ 1998-11-19 18:22 Warren Craig <CWarren@iclretail.com>
0 siblings, 2 replies; 9+ messages in thread
From: Warren Craig @ 1998-11-19 18:22 UTC (permalink / raw)
To: pgsql-interfaces
I have set up a couple of tables on Postgresql and I have installed
PostODBC drivers on my NT 4.0 machine. I have been testing out the drivers
by using MSQuery tool. In that tool if I pick the datasource as Postgres I
get a list of tables, I can select a table and it shows all the columns for
that table, but if I do a "Select *" for that table it doesn't work
correctly. The only thing that I get back is the field "xmin" and no other
fields. Any help would be appreciated. Has anybody got Access to link
tables through PostODBC drivers correctly?
Craig Warren
Work # (619) 458-5541
e-mail CWarren@iclretail.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [INTERFACES] POSTOBDC
@ 1998-11-19 19:00 Michael Meskes <meskes@usa.net>
parent: Warren Craig <CWarren@iclretail.com>
1 sibling, 0 replies; 9+ messages in thread
From: Michael Meskes @ 1998-11-19 19:00 UTC (permalink / raw)
To: Warren Craig <CWarren@iclretail.com>; +Cc: pgsql-interfaces
On Thu, Nov 19, 1998 at 01:22:43PM -0500, Warren Craig wrote:
> I have set up a couple of tables on Postgresql and I have installed
> PostODBC drivers on my NT 4.0 machine. I have been testing out the drivers
> by using MSQuery tool. In that tool if I pick the datasource as Postgres I
> get a list of tables, I can select a table and it shows all the columns for
> that table, but if I do a "Select *" for that table it doesn't work
> correctly. The only thing that I get back is the field "xmin" and no other
> fields. Any help would be appreciated. Has anybody got Access to link
> tables through PostODBC drivers correctly?
Would you tell us there version you use? I did run Access to access my
PostgreSQL DB earlier this year. Sorry, but I cannot test this anymore as I
don't have access to the machines anymore.
Michael
--
Dr. Michael Meskes, Manager of the Western Branch Office, Datenrevision GmbH
work: Cuxhavener Str. 36, D-21149 Hamburg
home: Th.-Heuss-Str. 61, D-41812 Erkelenz, Michael.Meskes@usa.net
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!
^ permalink raw reply [nested|flat] 9+ messages in thread
* FW: POSTOBDC
@ 1998-11-19 19:03 Warren Craig <CWarren@iclretail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Warren Craig @ 1998-11-19 19:03 UTC (permalink / raw)
To: pgsql-interfaces
-----Original Message-----
From: Warren Craig
Sent: Thursday, November 19, 1998 11:02 AM
To: Warren Craig
Subject: POSTOBDC
If I turn on KSQO in the driver settings I get an error on my Linux Box that
says
"unrecognizable variable ksqo".
I am also getting errors on the linux side that say
"Can't find a default operator class for type 28."
Any suggestions. Thanks
Craig Warren
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [INTERFACES] POSTOBDC
@ 1998-11-19 19:12 David Hartwig <daveh@insightdist.com>
parent: Warren Craig <CWarren@iclretail.com>
1 sibling, 0 replies; 9+ messages in thread
From: David Hartwig @ 1998-11-19 19:12 UTC (permalink / raw)
To: Warren Craig <CWarren@iclretail.com>; +Cc: pgsql-interfaces
Warren Craig wrote:
> I have set up a couple of tables on Postgresql and I have installed
> PostODBC drivers on my NT 4.0 machine. I have been testing out the drivers
> by using MSQuery tool. In that tool if I pick the datasource as Postgres I
> get a list of tables, I can select a table and it shows all the columns for
> that table, but if I do a "Select *" for that table it doesn't work
> correctly. The only thing that I get back is the field "xmin" and no other
> fields. Any help would be appreciated. Has anybody got Access to link
> tables through PostODBC drivers correctly?
>
Both MS Query and MS Access are fairly routine setups.
What version of driver? PostgreSQL?
Could you send a log file? Activate CommLog in the driver and send
C:/psqlodbc_#######.log Where ##### is the PID.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [INTERFACES] FW: POSTOBDC
@ 1998-11-24 02:40 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
parent: Warren Craig <CWarren@iclretail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Thomas G. Lockhart @ 1998-11-24 02:40 UTC (permalink / raw)
To: Warren Craig <CWarren@iclretail.com>; +Cc: pgsql-interfaces
> If I turn on KSQO in the driver settings I get an error on my Linux
> Box that says: "unrecognizable variable ksqo".
> I am also getting errors on the linux side that say:
> "Can't find a default operator class for type 28."
I'm not certain, but what version of Postgres are you running? I would
guess that KSQO is specific to a recent version, perhaps only the most
recent (v6.4).
- Tom
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [INTERFACES] FW: POSTOBDC
@ 1998-11-25 22:53 David Hartwig <daybee@bellatlantic.net>
parent: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 9+ messages in thread
From: David Hartwig @ 1998-11-25 22:53 UTC (permalink / raw)
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; +Cc: Warren Craig <CWarren@iclretail.com>; pgsql-interfaces
"Thomas G. Lockhart" wrote:
> > If I turn on KSQO in the driver settings I get an error on my Linux
> > Box that says: "unrecognizable variable ksqo".
> > I am also getting errors on the linux side that say:
> > "Can't find a default operator class for type 28."
>
> I'm not certain, but what version of Postgres are you running? I would
> guess that KSQO is specific to a recent version, perhaps only the most
> recent (v6.4).
That is correct. KSQO is an optimizing option which is only available
with the 6.4 backend.
^ permalink raw reply [nested|flat] 9+ messages in thread
* PostOBDC
@ 1998-11-30 23:29 Warren Craig <CWarren@iclretail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Warren Craig @ 1998-11-30 23:29 UTC (permalink / raw)
To: pgsql-interfaces
I am trying to copy over a table (schema and Data) from a SQL Server
Database table to Postgres. I am using pgAdmin tool on my NT machine and I
have the lates drivers of PostOBDC. I get an error that says "Error 3146:
ODBC called failed" Here is the run log from the pgAdmin It looks like the
error is coming from my DAO object. Has anybody seen this before?
Software
********
Program: pgAdmin
Version: 6.4.0
Sub or Function: frmMigration, Migrate_Data
Error Details
*************
Error No: 3146
Error Description: ODBC--call failed.
Error Source: DAO.QueryDef
DLL Error Code: 0
Memory Details
**************
Total Physical: 100061184
Total Swap: 167112704
Total Virtual: 2147352576
Available Physical: 39071744
Available Swap: 102445056
Available Virtual: 2016604160
Percentage Free: 0
System Details
**************
Processor: 586
OEM ID: 0
No. Processors: 1
Page Size: 4096
OS Details
**********
Platform: Windows NT
Version: 4.0
Build: 1381
OS Info: Service Pack 3
Craig Warren
Work # (619) 458-5541
e-mail CWarren@iclretail.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: [INTERFACES] PostOBDC
@ 1998-12-01 08:24 Dave Page <dpage@vale-housing.co.uk>
parent: Warren Craig <CWarren@iclretail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Dave Page @ 1998-12-01 08:24 UTC (permalink / raw)
To: 'Warren Craig' <CWarren@iclretail.com>; +Cc: pgsql-interfaces
Hi,
I'd bet a fiver that you have a ' somewhere in your data! Can you switch on
the Commlog option in PostODBC, re-run the Migration Wizard as before and
then send me the commlog please.
Unfortunately single quotes in data have my life a misery as far as the
Import and Migration wizards in pgAdmin are concerned!!
Regards,
Dave.
--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.vale-it.demon.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!
> -----Original Message-----
> From: owner-pgsql-interfaces@postgreSQL.org
> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of
> Warren Craig
> Sent: 30 November 1998 23:30
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] PostOBDC
>
>
> I am trying to copy over a table (schema and Data) from a SQL Server
> Database table to Postgres. I am using pgAdmin tool on my NT
> machine and I
> have the lates drivers of PostOBDC. I get an error that says
> "Error 3146:
> ODBC called failed" Here is the run log from the pgAdmin It
> looks like the
> error is coming from my DAO object. Has anybody seen this before?
>
> Software
> ********
> Program: pgAdmin
> Version: 6.4.0
> Sub or Function: frmMigration, Migrate_Data
>
> Error Details
> *************
> Error No: 3146
> Error Description: ODBC--call failed.
> Error Source: DAO.QueryDef
> DLL Error Code: 0
>
> Memory Details
> **************
> Total Physical: 100061184
> Total Swap: 167112704
> Total Virtual: 2147352576
> Available Physical: 39071744
> Available Swap: 102445056
> Available Virtual: 2016604160
> Percentage Free: 0
>
> System Details
> **************
> Processor: 586
> OEM ID: 0
> No. Processors: 1
> Page Size: 4096
>
> OS Details
> **********
> Platform: Windows NT
> Version: 4.0
> Build: 1381
> OS Info: Service Pack 3
>
> Craig Warren
> Work # (619) 458-5541
> e-mail CWarren@iclretail.com
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: [INTERFACES] PostOBDC
@ 1998-12-02 08:08 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 9+ messages in thread
From: Dave Page @ 1998-12-02 08:08 UTC (permalink / raw)
To: 'Warren Craig' <CWarren@iclretail.com>; +Cc: pgsql-interfaces
Good, I'm glad you got it sorted. I'm suprised that a . threw it though,
it's usually spaces or single quotes that cause problems because of the way
that the SQL to create the table is formed. I would appreciate it if you
could still send me the relevant section of the commlog so I can try to fix
the problem for the next release.
Regards,
Dave.
> -----Original Message-----
> From: Warren Craig [mailto:CWarren@iclretail.com]
> Sent: 01 December 1998 15:32
> To: 'Dave Page'
> Subject: RE: [INTERFACES] PostOBDC
>
>
> Thanks for your help. I found the error to be a "." in the
> table name. I
> was trying to copy a table from SQLServer and the table name
> was dbo.<the
> table name> . I then imported the table to Access and
> changed the name
> without the "dbo" and it worked.
>
> :)-----Original Message-----
> :)From: Dave Page [mailto:dpage@vale-housing.co.uk]
> :)Sent: Tuesday, December 01, 1998 12:25 AM
> :)To: 'Warren Craig'
> :)Cc: pgsql-interfaces@postgreSQL.org
> :)Subject: RE: [INTERFACES] PostOBDC
> :)
> :)
> :)Hi,
> :)
> :)I'd bet a fiver that you have a ' somewhere in your data! Can
> :)you switch on
> :)the Commlog option in PostODBC, re-run the Migration Wizard
> :)as before and
> :)then send me the commlog please.
> :)
> :)Unfortunately single quotes in data have my life a misery as
> :)far as the
> :)Import and Migration wizards in pgAdmin are concerned!!
> :)
> :)Regards,
> :)
> :)Dave.
> :)
> :)--
> :)Dave Page, Network & Systems Manager, The Vale Housing
> :)Association Ltd.
> :)dpage@vale-housing.co.uk
> :)http://www.vale-housing.co.uk (Work)
> :)http://www.vale-it.demon.co.uk/ (Home of pgAdmin)
> :)Beer can be a permanent solution - but only if you have
> enough of it!
> :)
> :)> -----Original Message-----
> :)> From: owner-pgsql-interfaces@postgreSQL.org
> :)> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of
> :)> Warren Craig
> :)> Sent: 30 November 1998 23:30
> :)> To: pgsql-interfaces@postgreSQL.org
> :)> Subject: [INTERFACES] PostOBDC
> :)>
> :)>
> :)> I am trying to copy over a table (schema and Data) from a
> :)SQL Server
> :)> Database table to Postgres. I am using pgAdmin tool on my NT
> :)> machine and I
> :)> have the lates drivers of PostOBDC. I get an error that says
> :)> "Error 3146:
> :)> ODBC called failed" Here is the run log from the pgAdmin It
> :)> looks like the
> :)> error is coming from my DAO object. Has anybody seen this before?
> :)>
> :)> Software
> :)> ********
> :)> Program: pgAdmin
> :)> Version: 6.4.0
> :)> Sub or Function: frmMigration, Migrate_Data
> :)>
> :)> Error Details
> :)> *************
> :)> Error No: 3146
> :)> Error Description: ODBC--call failed.
> :)> Error Source: DAO.QueryDef
> :)> DLL Error Code: 0
> :)>
> :)> Memory Details
> :)> **************
> :)> Total Physical: 100061184
> :)> Total Swap: 167112704
> :)> Total Virtual: 2147352576
> :)> Available Physical: 39071744
> :)> Available Swap: 102445056
> :)> Available Virtual: 2016604160
> :)> Percentage Free: 0
> :)>
> :)> System Details
> :)> **************
> :)> Processor: 586
> :)> OEM ID: 0
> :)> No. Processors: 1
> :)> Page Size: 4096
> :)>
> :)> OS Details
> :)> **********
> :)> Platform: Windows NT
> :)> Version: 4.0
> :)> Build: 1381
> :)> OS Info: Service Pack 3
> :)>
> :)> Craig Warren
> :)> Work # (619) 458-5541
> :)> e-mail CWarren@iclretail.com
> :)>
> :)>
> :)
> :)
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~1998-12-02 08:08 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-11-19 18:22 POSTOBDC Warren Craig <CWarren@iclretail.com>
1998-11-19 19:00 ` Michael Meskes <meskes@usa.net>
1998-11-19 19:12 ` David Hartwig <daveh@insightdist.com>
1998-11-19 19:03 FW: POSTOBDC Warren Craig <CWarren@iclretail.com>
1998-11-24 02:40 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-11-25 22:53 ` David Hartwig <daybee@bellatlantic.net>
1998-11-30 23:29 PostOBDC Warren Craig <CWarren@iclretail.com>
1998-12-01 08:24 ` RE: [INTERFACES] PostOBDC Dave Page <dpage@vale-housing.co.uk>
1998-12-02 08:08 RE: [INTERFACES] PostOBDC Dave Page <dpage@vale-housing.co.uk>
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