Looking for any help that anyone wants to offer. I cannot get FoxPro to access the PostgreSQL database to save my life on the network that I am working on. I can, however, get Access to access the PostgreSQL database with no problems at all. Access does take about a minute before it returns the results from the Employee table when I select all records from it. Currently the Employee table in PostgreSQL has 130 records.

I really believe the problem is at my end or the end of Windows2000. I have a home PC running98 and I am able to access a different PostgreSQL database over the net. At this point I am not sure if I may have made changes to the BDE Administrator in Windows2000 that might be causing some of my problems. Below are the steps I am using and the result of those steps.

At one point I was getting a message about the Database not being found in the System Catalog. I have no idea why I was getting that one.

1.) Create a new database in FoxPro 6.0 and name it Data1.dbc
2.) Right click in the Database Designer and select “Remote View” from the dropdown list.
3.) From the “New Remote View” form I click “New View”
4.) From the “Select Connection or Data Source” I click the “New”
a. From the “Connection Designer” I click “Connection String” and then click the three dots for the Connection. From the “Select Data Source” form I select “Timecard.DSN” from the “File Data Source” tab.
5.) From the “PostgreSQL Connection” form I add my password and click “OK” I then get a message box that says, “Connection succeeded.” And I click the “OK” button on that form.
6.) Then I click the “OK” button on the “Connection Designer”. I give it a name of “remoteTimeCard”.
7.) At this point the “View Designer” opens and another form opens listing the two tables that are in the “TimeCard” database. The Tables are “Employees” and “Timecards”. I click on “Employees” and then click the “Add” button.
8.) I then get a message box saying, “No result set has been returned by the server.”

My current setup: DellDimensionXPS T450 running Windows2000 version 5.00.2195 Service Pack 2, running with FoxPro 6.0, PostgreSQL ODBC driver version 7.01.00.09, I have setup both a System DSN and a File DSN in the ODBC Administrator, pgAdmin 1.2.0. I have also installed Microsoft Data Access Components 2.6.

Here is a copy of the DSN file from the File DSN tab:
[ODBC]
DRIVER=PostgreSQL
UID=nathan
EXTRASYSTABLEPREFIXES=dd_
CANCELASFREESTMT=0
PARSE=0
BOOLSASCHAR=1
UNKNOWNSASLONGVARCHAR=0
TEXTASLONGVARCHAR=1
USEDECLAREFETCH=0
KSQO=1
OPTIMIZER=1
COMMLOG=0
DEBUG=0
MAXLONGVARCHARSIZE=8190
MAXVARCHARSIZE=254
UNKNOWNSIZES=0
SOCKET=4096
FETCH=100
CONNSETTINGS=
SHOWSYSTEMTABLES=0
ROWVERSIONING=0
SHOWOIDCOLUMN=0
FAKEOIDINDEX=0
PROTOCOL=6.4
READONLY=0
PORT=5432
SERVER=stan.aretoo.com
DATABASE=Timecard