Hi All,

This is a copy of a post on the VFP Forum for which I found no solution. There is probably more experience in this forum with PostgreSQL so perhaps someone here will have a solution. Anyway.........



I'm experimenting with PostgreSQL on Linux and am having problems creating remote views.

Specifically, when I try to add a table to a new remote view from the selection of tables that it finds in the database, I get the error :

Connectivity error: Error while executing the query;
ERROR: parser: parser error at or near "."

An extract from the ODBC trace log is at the bottom of this post if it's helpful.

I have what I believe to be the latest ODBC driver (in that I downloaded it only yesterday) - version 6.50.00.00

I have no problems creating tables and executing queries using SPT - only with views.

I've come across others with this problem on the Net but have been unable to find a solution.

Anybody solve this before?

TIA

Liam



ODBC Trace Log Extract

VFP6            ffc0a4e9:ffc24415	ENTER SQLPrepare 
		HSTMT               0x02c702b0
		UCHAR *             0x014c151c [      -3] "SELECT * FROM liam.company\ 0"
		SDWORD                    -3

VFP6            ffc0a4e9:ffc24415	EXIT  SQLPrepare  with return code 0 (SQL_SUCCESS)
		HSTMT               0x02c702b0
		UCHAR *             0x014c151c [      -3] "SELECT * FROM liam.company\ 0"
		SDWORD                    -3

VFP6            ffc0a4e9:ffc24415	ENTER SQLNumResultCols 
		HSTMT               0x02c702b0
		SWORD *             0x00a3e84e

VFP6            ffc0a4e9:ffc24415	EXIT  SQLNumResultCols  with return code -1 (SQL_ERROR)
		HSTMT               0x02c702b0
		SWORD *             0x00a3e84e

		DIAG [S1010] No query has been executed with that handle;
ERROR:  parser: parse error at or near "." (3) 

VFP6            ffc0a4e9:ffc24415	ENTER SQLExecDirect 
		HSTMT               0x02c702b0
		UCHAR *             0x014c151c [      -3] "SELECT * FROM liam.company WHERE 1=0\ 0"
		SDWORD                    -3

VFP6            ffc0a4e9:ffc24415	EXIT  SQLExecDirect  with return code -1 (SQL_ERROR)
		HSTMT               0x02c702b0
		UCHAR *             0x014c151c [      -3] "SELECT * FROM liam.company WHERE 1=0\ 0"
		SDWORD                    -3

		DIAG [S1000] Error while executing the query;
ERROR:  parser: parse error at or near "." (1)