Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FoxPro 6.0 attempting to access PostgreSQL
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00648348
Message ID:
00648507
Views:
15
Hi Nathan,

I tried the procedures you described. However, when I reached the point where asked to select the table for my remote view, I did not receive the "No result set has been returned". Instead a dialog is opened and I was able to select fields I wanted to make updateable and I also selected the send SQL update check box. I had no problem whatsoever. I checked my driver number and it is one version ahead of the driver you have installed. My driver version number is 7.01.00.10.

I don't feel like the driver is the problem; rather, I would suspect that the user name and password combination you are using has not been assigned to access your employee table, or the user name and password combination do not have the need permissions like to insert, update, and delete, and rules permission needed to query the table. Make sure the user has been granted all these permissions.

You might also check the pg_hba.conf file to make sure the local connection or the host IP address is authorized to access the table. I don't think this is the problem, because you were able to connect to the postgres database.
Leland F. Jackson, CPA
Software - Master (TM)
smvfp@mail.smvfp.com
Software Master TM
Previous
Reply
Map
View

Click here to load this message in the networking platform