Re: Win2K3 and the OleDb 8.0 driver

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

  • Next message: SQLScott: "List multiple tables in a Connection string?"
    Date: Thu, 26 Aug 2004 09:03:09 -0700
    
    

    An update to this issue. The VFPOleDb driver install that you get off the
    Microsoft Website has a bug in the install. It does not register the DLL
    correctly. Once the driver is installed, you have to manually register the
    DLL:

    regsvr32 c:\program files\commonfiles\.....\vfpoledb.dll

    And it will put the entry in the correct place in the registry.

    Scott

    "Dan Freeman" wrote:

    > 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
    >
    > SQLScott wrote:
    > > 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
    >
    >
    >


  • Next message: SQLScott: "List multiple tables in a Connection string?"