Discussion:
Access a DBF on another PC
(too old to reply)
Olaf Doschke
2004-08-20 09:54:44 UTC
Permalink
"Referenced object has a value of 'Nothing'"
However, this same code works on the pc local to the FP database.
Does p:\data\hr180.dbf resolve to the same drive/directory
on both computers? Is the drive P: mapped correctly?
Do you simply have some permission problem for that
directory?

Bye, Olaf.
SQLScott
2004-08-20 12:27:02 UTC
Permalink
Hi Olaf,

Yes, both resolve to the same directory, and both machines have the drive
mapped using the same credentials. The only difference is that on the
machine that works, I have the full version of VFP 8 installed, but on the
machine that doesn't work I only have the 8.0 FP OleDb driver installed.

Scott
Post by Olaf Doschke
"Referenced object has a value of 'Nothing'"
However, this same code works on the pc local to the FP database.
Does p:\data\hr180.dbf resolve to the same drive/directory
on both computers? Is the drive P: mapped correctly?
Do you simply have some permission problem for that
directory?
Bye, Olaf.
Sietse Wijnker
2004-08-20 15:08:36 UTC
Permalink
Hi Scott,

There's been an update for the OLEDB provider that was included in SP1 for
VFP8. Have you installed VFP8 SP1 on the other machine?
Download the VFP OLEDB update here:
http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en

HTH,
Sietse WIjnker
Post by SQLScott
Hi Olaf,
Yes, both resolve to the same directory, and both machines have the drive
mapped using the same credentials. The only difference is that on the
machine that works, I have the full version of VFP 8 installed, but on the
machine that doesn't work I only have the 8.0 FP OleDb driver installed.
Scott
Post by Olaf Doschke
"Referenced object has a value of 'Nothing'"
However, this same code works on the pc local to the FP database.
Does p:\data\hr180.dbf resolve to the same drive/directory
on both computers? Is the drive P: mapped correctly?
Do you simply have some permission problem for that
directory?
Bye, Olaf.
SQLScott
2004-08-20 20:13:02 UTC
Permalink
Machine A and B are my development computers. Machine C has the Foxpro
database. Machine A is a Windows XP machine that has Foxpro 8.0 with Service
Pack 1 loaded on it. Machine B is a Windows 2003 machine with ONLY the
version 8.0.0.3117 oledb driver on it. MDAC leve on that box is 2.8.

Both machine A and machine B run the same code to access the database on
Machine C. Machine A works, Machine B does not.

Machine B returns the error: "Referenced object has a value of 'Nothing'"
when attempting the Open command.

Does this make sense?
Post by Sietse Wijnker
Hi Scott,
There's been an update for the OLEDB provider that was included in SP1 for
VFP8. Have you installed VFP8 SP1 on the other machine?
http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en
HTH,
Sietse WIjnker
Post by SQLScott
Hi Olaf,
Yes, both resolve to the same directory, and both machines have the drive
mapped using the same credentials. The only difference is that on the
machine that works, I have the full version of VFP 8 installed, but on the
machine that doesn't work I only have the 8.0 FP OleDb driver installed.
Scott
Post by Olaf Doschke
"Referenced object has a value of 'Nothing'"
However, this same code works on the pc local to the FP database.
Does p:\data\hr180.dbf resolve to the same drive/directory
on both computers? Is the drive P: mapped correctly?
Do you simply have some permission problem for that
directory?
Bye, Olaf.
Loading...