oracle not returning any results when trying to create remote view

[Pollock]

Ok, last week this was working fine now its not. I am creating a remote view from an oracle 10g. server.

"CREATE SQL VIEW TMPVUE REMOTE CONNECTION REMOTECONNECTION AS SELECT * FROM "+tblname

when I go to execute this command I get error
"No result set has been returned by the server."

It was working fine last week and have done nothing to the server and use sqlexec command I get the expected returned empty remote view.

note: table in oracle is empty.

 

[JRB-Bldr]

Have you tried testing the ODBC connection to the Oracle database all by itself outside of VFP?

If you have not, I'd recommend create a UDL file and do so before any other investigation.
Reference:

http://msdn.microsoft.com/en-us/library/e38h511e(VS.71).aspx

If the connection does not work, then find out why. It will have nothing to do with VFP.

If the connection works, then you can look into your VFP Database Connection Settings.

Good Luck,
JRB-Bldr

 

[Pollock]

Odbc Connection works fine to the database as I can do other things with it. Its just trying to create an empty remote view copy of the table is where the error is occuring. Note if the oracle table has data, it returns an empty view but when the table is empty it throws up this error