|
Home > Archive > FoxPro database connector > November 2005 > Error from FoxPro connection in Visual Basic 6
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error from FoxPro connection in Visual Basic 6
|
|
| stjulian 2005-11-09, 8:25 pm |
| I am getting an error in a program written in VB6 when connecting to a VFP
free table directory. It works on the deveopment machine (XP Pro SP2) and
not on the server where the app is to run.
The (pertinent) code is as follows
Dim CONN As New ADODB.Connection
cnFox = "Driver={Microsoft Visual FoxPro Driver}; " _
& "SourceType=DBF;" _
& " SourceDB=c:\foxproda
ta;" _
& "Exclusive=No;" _
& "Collate=Machine;" _
& "NULL=NO;" _
& "DELETED=NO;" _
& "BACKGROUNDFETCH=NO"
CONN.ConnectionString = cnFox
This is where it fails with Error #-2147467259
The program references "Microsoft ActiveX Data Objects 2.8"
The Server is running "MDAC 2.8 RTM"
The Development machine is running "MDAC 2.8 SP1 on Windows XP SP2"
Neither one of these MDACs supposedly have a driver for FoxPro
The OLE DB Provider for Visual FoxPro 9.0 doesn't seem to be installed on my
development machine. And the ODBC drivers are different.
The "Microsoft FoxPro Driver" in the ODBC panel on the Server is not present
The "Microsoft FoxPro Driver" in the ODBC panel on the Development machine
reports version 4.00.6304.00
The "Microsoft Visual FoxPro Driver" in the ODBC panel on the Server reports
version 1.00.02.00
The "Microsoft Visual FoxPro Driver" in the ODBC panel on the Development
machine reports version 6.00.8167.00
The "Microsoft FoxPro VFP Driver" in the ODBC panel on the Server reports
version 1.00.02.00
The "Microsoft FoxPro VFP Driver" in the ODBC panel on the Development
machine reports version 6.00.8167.00
What (at the minimum) is needed to be installed on the server to allow this
to go through?
Julian
| |
| Lee Mitchell 2005-11-09, 8:25 pm |
| Hi Julian:
Try installing the VFP ODBC driver on the server. Get if from this link:
http://www.msdn.microsoft.com/vfoxp...es/default.aspx
Look at the bottom of the page.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/
*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
>I am getting an error in a program written in VB6 when connecting to a VFP
>free table directory. It works on the deveopment machine (XP Pro SP2) and
>not on the server where the app is to run.
>The (pertinent) code is as follows
Dim CONN As New ADODB.Connection
cnFox = "Driver={Microsoft Visual FoxPro Driver}; " _
& "SourceType=DBF;" _
& " SourceDB=c:\foxproda
ta;" _
& "Exclusive=No;" _
& "Collate=Machine;" _
& "NULL=NO;" _
& "DELETED=NO;" _
& "BACKGROUNDFETCH=NO"
CONN.ConnectionString = cnFox
>This is where it fails with Error #-2147467259
>The program references "Microsoft ActiveX Data Objects 2.8"
>The Server is running "MDAC 2.8 RTM"
>The Development machine is running "MDAC 2.8 SP1 on Windows XP SP2"
>Neither one of these MDACs supposedly have a driver for FoxPro
>The OLE DB Provider for Visual FoxPro 9.0 doesn't seem to be installed on
my
>development machine. And the ODBC drivers are different.
>The "Microsoft FoxPro Driver" in the ODBC panel on the Server is not
present
>The "Microsoft FoxPro Driver" in the ODBC panel on the Development machine
>reports version 4.00.6304.00
>The "Microsoft Visual FoxPro Driver" in the ODBC panel on the Server
reports
>version 1.00.02.00
>The "Microsoft Visual FoxPro Driver" in the ODBC panel on the Development
>machine reports version 6.00.8167.00
>The "Microsoft FoxPro VFP Driver" in the ODBC panel on the Server reports
>version 1.00.02.00
>The "Microsoft FoxPro VFP Driver" in the ODBC panel on the Development
>machine reports version 6.00.8167.00
>What (at the minimum) is needed to be installed on the server to allow
this
>to go through?
>Julian
| |
| stjulian 2005-11-09, 8:25 pm |
| Will this work on Windows Server 2003?
Julian
"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:k4Uma1W5FHA.832@TK2MSFTNGXA02.phx.gbl...
> Hi Julian:
>
> Try installing the VFP ODBC driver on the server. Get if from this link:
>
> http://www.msdn.microsoft.com/vfoxp...es/default.aspx
>
> Look at the bottom of the page.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
>
>
> Dim CONN As New ADODB.Connection
>
> cnFox = "Driver={Microsoft Visual FoxPro Driver}; " _
> & "SourceType=DBF;" _
> & " SourceDB=c:\foxproda
ta;" _
> & "Exclusive=No;" _
> & "Collate=Machine;" _
> & "NULL=NO;" _
> & "DELETED=NO;" _
> & "BACKGROUNDFETCH=NO"
>
> CONN.ConnectionString = cnFox
>
>
>
>
>
>
> my
>
> present
>
> reports
>
>
>
>
> this
>
>
| |
| Lee Mitchell 2005-11-09, 8:25 pm |
| Hi Julian:
I have installed the VFP ODBC driver on my Windows 2003 Server without a
problem.
Look at the bottom of the page.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/
*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
>Will this work on Windows Server 2003?
>Julian
>"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
>news:k4Uma1W5FHA.832@TK2MSFTNGXA02.phx.gbl...
> Hi Julian:
>
> Try installing the VFP ODBC driver on the server. Get if from this link:
>
> http://www.msdn.microsoft.com/vfoxp...es/default.aspx
>
> Look at the bottom of the page.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
>
http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
>
>
> Dim CONN As New ADODB.Connection
>
> cnFox = "Driver={Microsoft Visual FoxPro Driver}; " _
> & "SourceType=DBF;" _
> & " SourceDB=c:\foxproda
ta;" _
> & "Exclusive=No;" _
> & "Collate=Machine;" _
> & "NULL=NO;" _
> & "DELETED=NO;" _
> & "BACKGROUNDFETCH=NO"
>
> CONN.ConnectionString = cnFox
>
>
>
>
>
>
> my
>
> present
>
> reports
>
>
>
>
> this
>
>
| |
| Cindy Winegarden 2005-11-09, 8:25 pm |
| Hi Julian,
In addition to the ODBC driver, the page Lee gave you also has the FoxPro
and Visual FoxPro OLE DB data provider. You'll need a different connection
string though: something like "Provider=VFPOLEDB.1;Data Source=C:\Temp\;") .
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"stjulian" < anonymous@discussion
s.microsoft.com> wrote in message
news:OD30iqW5FHA.1148@TK2MSFTNGP10.phx.gbl...
> The OLE DB Provider for Visual FoxPro 9.0 doesn't seem to be installed on
> my development machine. And the ODBC drivers are different.
|
|
|
|
|