Open a connection - Error

[LeAnn]

I have an Access 2003 (2000 format) database that uses a file dsn to connect
to a Visual Fox Pro database. The code that makes the connection is:

---------code-------------
Set con = CreateObject("ADODB.Connection")
Set res = CreateObject("ADODB.Recordset")

con.Open = "FileDSN=" & UD_DBPATH & "ODBC\Net Test (v).dsn"

res.Open "SELECT ACCESS_NO, COUNT(ACCESS_NO) AS CNT FROM SPNET WHERE
ACCESS_NO = '" & strID & "' GROUP BY ACCESS_NO", con
---------end code----------

When I run it from my PC (Access 2003), or one of the older PCs (Access
2000) it is fine. However, on a couple of newer PCs that have Access 2002,
the following error occurs:

[Microsoft][ODBC Driver Manager] Driver does not support this function (0)

When I debug this it is the FileDSN = statement that is generating the
error. After doing a trace and a lot of research and reading I think I
discovered the source of the problem. The trace log has this entry which is
not present from a PC trace where the error does not occur…..

MSACCESS c28-514 EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 0A8F18D8
HWND 00000000
WCHAR * 0x74329A38 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x74329A38
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

DIAG [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this
function (0)

This is much more technical than I can decipher so can anyone help me out?
How do I resolve this on the new computers? Is it an Access version issue or
perhaps an OS issue? I have the same Windows XP SP2 as the PC it fails on.
Is this a reference issue? There is both DAO and ADO being used in the
database and the following reference libraries are checked:
Visual Basic for Applications
Microsoft Access 11.0 Object Library (10.0 for the XP box)
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Visual Basic for Applications Extensibility 5.3

Thanks for your assistance
LeAnn

 

[LeAnn]

Never mind - I figured it out. The older machines had the ODBC Visual Fox
Pro Driver already installed and the new machines don't come with that - I
had to go the msdn.microsoft.com/downloads site to download the ODBC driver
for VFP.