General information
Category:
Coding, syntax & commands
Title:
VB6 and Visual Foxpro Data Access
Environment versions
Network:
Windows 2000 Server
Okay, I give. I know there has to be a thread around here that addresses this issue, but have yet to figure out my problem. Here's the deal, I have a VB6 app that pulls data from a VFP9 table
Dim rstTLVTable As New ADODB.Recordset
strQuery = "Select * From FoxProTableName Where FieldXYZ = " & _
SingleQuote & m_colIvoc(intInnerIndex).XYZValue & SingleQuote
rstTLVTable.Open strQuery, m_adodbFoxPro, adOpenStatic
m_adodbFoxPro is defined as "\\server\directory\subdirectory\"
When this is attempted, I get an error message
"An error has occured in the program and is forced to shutdown. Cannot open file \\server\directory\subdirectory\FoxProTableName.cdx" and yes the cdx is in the same directory as the dbf.
Here's the real puzzling piece. It works fine on the development system which has VFP9 loaded. It is only on the systems with Runtime that I get the error. I believe all are at same MDAC level. I thought it might be the VFP driver (Development 6.01.8630.01) but have a mix of systems with 6.01.8629.01 and 6.01.8630.01 that have the same issue.
My hair is getting thinner as I try to figure out this thing. Help.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only