Driver does not support this function in XP 1

[bobbarker]

Have a VB6 app which uses an ADODB connection.
Works fine in 98 and 2000. In XP I get "[Microsoft][ODBC Driver Manager] Driver does not support this function"
Have updated mDAC on my development machine (2000) to 2.7 and also ensured MDAC 2.7 is installed on the XP test machine.
My connection string (if its of any help?) is :
"Provider=MSDASQL.1;Extended Properties=DSN=Visual FoxPro Database;SourceDB=" & strFilePath & ";SourceType=DBF;Exclusive=No"
Any ideas?
Yours in hope.

 

[CCLINT]

What version of the OdFox32.dll do you have on the machine? [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[bobbarker]

Thansk for your response cclint.
I have version 4.0.6019.0 21KB dated 4th May 2001.

 

[CCLINT]

Also, why are you not using the OLEDB provider?

Conn.Provider ="Provider=VFPOLEDB.1"
Conn.Open "C:\Data\FoxPro7\xyz.dbc" [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[bobbarker]

Tried to use VFPOLEDB but I get "Provider cannot be found. It may not be properly installed."
I do not appear to have it installed. Having had a look around it appears that VFPOLEDB.dll is only available with Vis Fox 7 onwards or downloadable from MSDN as part of Vis Fox v8 Beta - which I have started to download.
In addition, have checked odfox32.dll on the XP machine and it is v4.0.5303.1 - ealier than mine. I attempted to copy my version over it and register using regsvr32 command but the version still reads on the XP as 4.0.5303.1.
What is my way forward? Should I be able to use odfox32.dll on XP? If so, any ideas on what else I can try? Or should I wait until my download of Vis Fox 8 has finished?
Thanks.

 

[bobbarker]

Now have vfpoledb and my app now works on XP. Thanks.

 

[CCLINT]

Thanks for responding back. Good for others who have the same problem and see this.