Thread: POSTOBDC
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
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.
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!