[GENERAL] Problems with ODBC Driver

2010-08-31 Thread Phil Jackson
I have a notebook that I am using as a server for testing purposes and it has the official ODBC driver installed. I can access this and use it connect to PostreSql. On a second machine on the same network - I also have the same ODBC driver installed. The behaviour of this one is quite diffe

[GENERAL] Problems with ODBC Driver

2010-09-01 Thread Phil Jackson
Hi Hiroshi The same program works on the server unchanged - that's why I think it is something to do with the driver. The error message says that the field name doesn't exist when it does as can be verified by looking at the database in Postgresql. Cheers Phil Jackson On 9/2/2010 3:19 AM,

Re: [GENERAL] Problems with ODBC Driver

2010-09-01 Thread Hiroshi Saito
Hi. There is very little information which explores a problem. What thing is an actual error message? The following is my imagination As for specific field, it may be the LOWER problem of a character. example) -- CREATE TABLE xx("Field" TEXT); postgres=# SELECT Field FROM xx; ERROR:

Re: [GENERAL] Problems with ODBC Driver

2010-09-01 Thread Joshua D. Drake
On Thu, 2010-09-02 at 14:04 +1200, Phil Jackson wrote: > Does anyone have any suggestions? > What does the ODBC log say? What does the PostgreSQL Log (or event viewer) say? JD > Cheers > > Phil Jackson > > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.c

Re: [GENERAL] Problems with ODBC Driver

2010-09-01 Thread z-saito
Hi. Um, it is very strange. Can you send us the mylog of psqlODBC? Regards, Hiroshi Saito > Hi Hiroshi > >The same program works on the server unchanged - that's why I think it >is something to do with the driver. The error message says that the >field name doesn't exist when it does as can