Re: Win2K3 and the OleDb 8.0 driver

From: SQLScott (SQLScott_at_discussions.microsoft.com)
Date: 08/20/04


Date: Fri, 20 Aug 2004 13:35:03 -0700

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

"Dan Freeman" wrote:

> 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
>
>
> SQLScott wrote:
> > 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.
> >
> > "Michael Drozdov" wrote:
> >
> >> 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]
> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >>
> >> "SQLScott" <SQLScott@discussions.microsoft.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
> >> ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
> >> news:2E755016-9151-42CE-8A92-759C28D7782D@microsoft.com...
> >>> 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
>
>
>