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
>
>
>



Relevant Pages

  • Re: Access a DBF on another PC
    ... Machine A is a Windows XP machine that has Foxpro 8.0 with Service ... version 8.0.0.3117 oledb driver on it. ... Both machine A and machine B run the same code to access the database on ...
    (microsoft.public.fox.vfp.dbc)
  • Can FoxPro 2.6 runs in Windows 2000 operating system
    ... Have been running an application developed using FoxPro for Windows version 2.6 under the Windows 95/98 operating system for some years now. ... Does this mean that FoxPro ver 2.6 database is not supported in the Windows 2000 operating system? ...
    (microsoft.public.fox.programmer.exchange)
  • SourceForge.net Sitewide Update: Jan 26th, 2005 (fwd)
    ... I just returned from an enjoyable Open Source conference in Hawaii ... open sourced the database under the name Derby. ... The CVS client SF.net staff recommend for MS Windows users is ... priority technical support. ...
    (comp.os.linux.announce)
  • Re: Is this possible??
    ... I understand Windows security but since I've not seen A2007 live, ... The backend is on the server in it's own file. ... database, but everyone does not need to have access to tblwage which is ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many companies are buying new AS400s
    ... Just like you do in iSeries navigator. ... SAVEPOINTs and ROLLBACKs are easy in any database that supports them, but what about analysis of the actual individual entries? ... Is it as easy to do this in Windows or Linux? ... I know how OS/400 work management lets me tune it so the customer is happy during those three or four minutes and is just as happy during the remaining 23:56 of the day. ...
    (comp.sys.ibm.as400.misc)