Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FoxPro 6.0 attempting to access PostgreSQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00648348
Message ID:
00648507
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform