Win2K3 and the OleDb 8.0 driver

Discussion:

(too old to reply)

Michael Drozdov

2004-08-20 15:34:27 UTC

Hi, Scott!

Does the Foxpro 8.0 OleDb driver work on Windows 2003?

What version Foxpro 8.0 OleDb you have? ... if it's ver: 8.0.0.3006 ->
download just ver: 8.0.0.3117 (SP1VFP8) from:
http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en
see also: http://vfpdev.narod.ru/docs/spcall_e.html#oledbsolve - OLEDB VFP
8.0 access problem for MS IIS 6.0

Best regards.
Michael Drozdov, ICS Soft, Perm, Russia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
My Page: http://vfpdev.narod.ru/
ICS Page: http://www.ics.perm.ru/ [on Russian]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Does the Foxpro 8.0 OleDb driver work on Windows 2003? I have the driver
installed (Foxpro is NOT installed) on my Win2K3 box but I cannot connect

a FoxPro database.
--
Thanks,
Scott

SQLScott

2004-08-20 18:03:35 UTC

Permalink

Hi Michael,

Yes, I have version 8.0.0.3117 but the problem is I cannot connect to a
FoxPro database via my .Net app. My .Net app (with the oledb driver) is
running on a windows 2003 box but the database is on completely different box
(is either windows 2000 or 2003, not sure which).

The reason I ask is because the exact same code works great from my windows
xp box.

Post by Michael Drozdov
Hi, Scott!

Does the Foxpro 8.0 OleDb driver work on Windows 2003?

What version Foxpro 8.0 OleDb you have? ... if it's ver: 8.0.0.3006 ->
http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en
see also: http://vfpdev.narod.ru/docs/spcall_e.html#oledbsolve - OLEDB VFP
8.0 access problem for MS IIS 6.0
Best regards.
Michael Drozdov, ICS Soft, Perm, Russia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
My Page: http://vfpdev.narod.ru/
ICS Page: http://www.ics.perm.ru/ [on Russian]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Does the Foxpro 8.0 OleDb driver work on Windows 2003? I have the driver
installed (Foxpro is NOT installed) on my Win2K3 box but I cannot connect

a FoxPro database.
--
Thanks,
Scott

Dan Freeman

2004-08-20 18:43:11 UTC

Permalink

Are you getting errors? What code are you using?

My gut tells me this is probably a permissions problem, but that's just a
wild guess since you haven't posted exactly what you're doing and what's
failing.

Dan

Post by SQLScott
Hi Michael,
Yes, I have version 8.0.0.3117 but the problem is I cannot connect to
a FoxPro database via my .Net app. My .Net app (with the oledb
driver) is running on a windows 2003 box but the database is on
completely different box (is either windows 2000 or 2003, not sure
which).
The reason I ask is because the exact same code works great from my
windows xp box.

Post by Michael Drozdov
Hi, Scott!

Does the Foxpro 8.0 OleDb driver work on Windows 2003?

What version Foxpro 8.0 OleDb you have? ... if it's ver: 8.0.0.3006

http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en

Post by SQLScott

Post by Michael Drozdov
see also: http://vfpdev.narod.ru/docs/spcall_e.html#oledbsolve - OLEDB VFP
8.0 access problem for MS IIS 6.0
Best regards.
Michael Drozdov, ICS Soft, Perm, Russia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
My Page: http://vfpdev.narod.ru/
ICS Page: http://www.ics.perm.ru/ [on Russian]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Does the Foxpro 8.0 OleDb driver work on Windows 2003? I have the
driver installed (Foxpro is NOT installed) on my Win2K3 box but I
cannot connect to a FoxPro database.
--
Thanks,
Scott

SQLScott

2004-08-20 20:35:03 UTC

Permalink

Dan,

I have included the code below but here is an explination...

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?

Code:
Dim tVFPConnstr As String
Dim cVFPConn As OleDbConnection

tVFPConnstr = "Provider=VFPOLEDB;Data
Source=p:\csiwin\data\hr180.dbf;SourceType=DBF;UID=;PWD=;Exclusive=No"

cVFPConn = New OleDbConnection(tVFPConnstr)

cVFPConn.Open() -> ERRORS ON THIS LINE

Thanks...

Scott

Post by Dan Freeman
Are you getting errors? What code are you using?
My gut tells me this is probably a permissions problem, but that's just a
wild guess since you haven't posted exactly what you're doing and what's
failing.
Dan

Post by Michael Drozdov
Hi, Scott!

Does the Foxpro 8.0 OleDb driver work on Windows 2003?

What version Foxpro 8.0 OleDb you have? ... if it's ver: 8.0.0.3006

http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en

Post by SQLScott

Does the Foxpro 8.0 OleDb driver work on Windows 2003? I have the
driver installed (Foxpro is NOT installed) on my Win2K3 box but I
cannot connect to a FoxPro database.
--
Thanks,
Scott

Dan Freeman

2004-08-20 20:44:59 UTC

Permalink

I'm no expert, but the first thing I'd try is installing the VFP runtime on
the machine that's failing.

See this for starters: http://fox.wikis.com/wc.dll?Wiki~VFP8RuntimeFiles~VFP

Dan

Post by SQLScott
Dan,
I have included the code below but here is an explination...
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?
Dim tVFPConnstr As String
Dim cVFPConn As OleDbConnection
tVFPConnstr = "Provider=VFPOLEDB;Data
Source=p:\csiwin\data\hr180.dbf;SourceType=DBF;UID=;PWD=;Exclusive=No"
cVFPConn = New OleDbConnection(tVFPConnstr)
cVFPConn.Open() -> ERRORS ON THIS LINE
Thanks...
Scott

Post by Dan Freeman
Are you getting errors? What code are you using?
My gut tells me this is probably a permissions problem, but that's
just a wild guess since you haven't posted exactly what you're doing
and what's failing.
Dan

Post by SQLScott
Hi Michael,
Yes, I have version 8.0.0.3117 but the problem is I cannot connect
to a FoxPro database via my .Net app. My .Net app (with the oledb
driver) is running on a windows 2003 box but the database is on
completely different box (is either windows 2000 or 2003, not sure
which).
The reason I ask is because the exact same code works great from my
windows xp box.

Post by Michael Drozdov
Hi, Scott!

Does the Foxpro 8.0 OleDb driver work on Windows 2003?

What version Foxpro 8.0 OleDb you have? ... if it's ver: 8.0.0.3006

http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en

Post by SQLScott

Post by Dan Freeman

Post by SQLScott

Does the Foxpro 8.0 OleDb driver work on Windows 2003? I have the
driver installed (Foxpro is NOT installed) on my Win2K3 box but I
cannot connect to a FoxPro database.
--
Thanks,
Scott

Michael Drozdov

2004-08-20 21:58:06 UTC

Permalink

Hi, Scott!

Post by SQLScott
Dim tVFPConnstr As String
Dim cVFPConn As OleDbConnection
tVFPConnstr = "Provider=VFPOLEDB;Data
Source=p:\csiwin\data\hr180.dbf;SourceType=DBF;UID=;PWD=;Exclusive=No"
cVFPConn = New OleDbConnection(tVFPConnstr)
cVFPConn.Open() -> ERRORS ON THIS LINE
the error: "Referenced object has a value of 'Nothing'"
when attempting the Open command.

Hm... I am not the jewelry programmer in VB.NET :-) ... and I am not sure...
but:
if it's VB.NET-code(ADO.NET)... try to use code something similar to
following:
...
Dim cVFPConn As New OleDbConnection()
cVFPConn.ConnectionString = tVFPConnstr;
cVFPConn.Open()
...

Best regards.
Michael Drozdov, ICS Soft, Perm, Russia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
My Page: http://vfpdev.narod.ru/
ICS Page: http://www.ics.perm.ru/ [on Russian]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Michael Drozdov

2004-08-20 22:16:31 UTC

Permalink

Hi, Scott!

Post by SQLScott
Dim tVFPConnstr As String
Dim cVFPConn As OleDbConnection
tVFPConnstr = "Provider=VFPOLEDB;Data
Source=p:\csiwin\data\hr180.dbf;SourceType=DBF;UID=;PWD=;Exclusive=No"
cVFPConn = New OleDbConnection(tVFPConnstr)
cVFPConn.Open() -> ERRORS ON THIS LINE
returns the error: "Referenced object has a value of 'Nothing'"

Hm... I am not the "jewelry programmer" in VB.NET :-) ...and I am not
sure... but
try to use code, something similarly to following:
...
Dim cVFPConn As New OleDbConnection()
Conn.ConnectionString = tVFPConnstr
cVFPConn.Open()
...
Best regards.
Michael Drozdov, ICS Soft, Perm, Russia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
My Page: http://vfpdev.narod.ru/
ICS Page: http://www.ics.perm.ru/ [on Russian]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Michael Drozdov

2004-08-21 09:22:29 UTC

Permalink

Hi, Scott!

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

see http://support.microsoft.com/?id=175801

Best regards.
Michael Drozdov, ICS Soft, Perm, Russia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
My Page: http://vfpdev.narod.ru/
ICS Page: http://www.ics.perm.ru/ [on Russian]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~