ODBC driver error with Visual Foxpro Version 9
in [Visual Basic]
|
Prev: Freehand Lasso
Next: Snapshot of screen
From: Vanny on 19 Nov 2009 15:07 We have a VB6 application that works fine up to version 6 when using Microsoft Visual Foxpro driver (6.01.8629.01) to connect to a .dbf file . With Visual Foxpro version 9 (driver version 1.00.02.00) run on XP it gives the error message: [Microsoft][ODBC Driver Manager] Driver does not support this function. Is this the problem with the new odbc driver or something else? If true, how to fix it without moving to OLEDB. Thanks in advance for help Vanny
From: Nobody on 19 Nov 2009 16:48 "Vanny" <lim_v(a)bls.gov> wrote in message news:he48ip$hjm$1(a)blsnews.bls.gov... > We have a VB6 application that works fine up to version 6 when using > Microsoft Visual Foxpro driver (6.01.8629.01) to connect to a .dbf file . > With Visual Foxpro version 9 (driver version 1.00.02.00) run on XP it > gives the error message: > [Microsoft][ODBC Driver Manager] Driver does not support this function. > Is this the problem with the new odbc driver or something else? If true, > how to fix it without moving to OLEDB. Not enough information. What error code or line that generated the error? I am not familiar with Foxpro ODBC driver, but if this is happening when you open the connection, check out the connection string, maybe there is something in it that is no longer supported. Also, try searching MSKB for "Foxpro ODBC driver 9.0" and similar words. http://support.microsoft.com/search/?adv=1
From: Ralph on 19 Nov 2009 17:14 "Vanny" <lim_v(a)bls.gov> wrote in message news:he48ip$hjm$1(a)blsnews.bls.gov... > We have a VB6 application that works fine up to version 6 when using > Microsoft Visual Foxpro driver (6.01.8629.01) to connect to a .dbf file . > With Visual Foxpro version 9 (driver version 1.00.02.00) run on XP it gives > the error message: > [Microsoft][ODBC Driver Manager] Driver does not support this function. Is > this the problem with the new odbc driver or something else? If true, how to > fix it without moving to OLEDB. > Not much help, but here goes .... AFAIK MS, in general, pulled-the-plug with older FoxPro file versions, similar xBase databases, and with ODBC, with its newer Fox Pro Drivers. And unfortunately the only solution generally offered is to migrate to OLE DB. However, you mentioned "connect to a .dbf file"? If you are not actually using FoxPro file versions greater than 6, then there are plenty of alternative DBF ODBC drivers out there. Some free, some expensive. Or just continue to use the older driver. hth -ralph
From: Vanny on 20 Nov 2009 11:49 Thank for your response. Our users have Visual Foxpro 9 driver and software installed in their machines. Like you mention, we notice that the new ODBC driver that comes with Version 9, does not function as the old one even it has the same name (Microsoft Visual Foxpro driver ). I could make the application work by applying the VFPODBC.msi which put the driver back to 6.01.8629.01 version. My question is : could this old driver harms the other functions of VPF9?? Thanks Vanny "Ralph" <nt_consulting64(a)yahoo.com> wrote in message news:uPN37XWaKHA.616(a)TK2MSFTNGP04.phx.gbl... > > "Vanny" <lim_v(a)bls.gov> wrote in message > news:he48ip$hjm$1(a)blsnews.bls.gov... >> We have a VB6 application that works fine up to version 6 when using >> Microsoft Visual Foxpro driver (6.01.8629.01) to connect to a .dbf file . >> With Visual Foxpro version 9 (driver version 1.00.02.00) run on XP it > gives >> the error message: >> [Microsoft][ODBC Driver Manager] Driver does not support this function. > Is >> this the problem with the new odbc driver or something else? If true, how > to >> fix it without moving to OLEDB. >> > > Not much help, but here goes .... > > AFAIK MS, in general, pulled-the-plug with older FoxPro file versions, > similar xBase databases, and with ODBC, with its newer Fox Pro Drivers. > And > unfortunately the only solution generally offered is to migrate to OLE DB. > > However, you mentioned "connect to a .dbf file"? If you are not actually > using FoxPro file versions greater than 6, then there are plenty of > alternative DBF ODBC drivers out there. Some free, some expensive. Or just > continue to use the older driver. > > hth > -ralph > >
From: Vanny on 20 Nov 2009 11:58
The error happened when open the connection. Here is the piece of code cnnDBF.Open "Driver=Microsoft Visual Foxpro Driver; " & _ "UID=;SourceType=DBF;" & _ "SourceDB=" & pstrFileName I try to find the info how to change the code to work with VFP version 9 driver or what file should be added along ? Thanks, Vanny "Nobody" <nobody(a)nobody.com> wrote in message news:%23jleTIWaKHA.1652(a)TK2MSFTNGP05.phx.gbl... > "Vanny" <lim_v(a)bls.gov> wrote in message > news:he48ip$hjm$1(a)blsnews.bls.gov... >> We have a VB6 application that works fine up to version 6 when using >> Microsoft Visual Foxpro driver (6.01.8629.01) to connect to a .dbf file . >> With Visual Foxpro version 9 (driver version 1.00.02.00) run on XP it >> gives the error message: >> [Microsoft][ODBC Driver Manager] Driver does not support this function. >> Is this the problem with the new odbc driver or something else? If true, >> how to fix it without moving to OLEDB. > > Not enough information. What error code or line that generated the error? > I am not familiar with Foxpro ODBC driver, but if this is happening when > you open the connection, check out the connection string, maybe there is > something in it that is no longer supported. > > Also, try searching MSKB for "Foxpro ODBC driver 9.0" and similar words. > > http://support.microsoft.com/search/?adv=1 > > |