Re: Connecing to Foxpro database from VB6 (1)
From: Rick Bean (rgbean_at_unrealmelange-inc.com)
Date: Fri, 14 May 2004 15:30:58 -0400
What version of the VFP OLEDB provider are you using? The current one is available at http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en - it was just released in February 2004.
I assume that your real code spells "Data Source" correctly.
"DennisC" <firstname.lastname@example.org> wrote in message news:8781411A-4BA7-4E09-B684-6EBD4B323607@microsoft.com...
> I'm having problems connecting to a Foxpro database via ADO in VB6. I've gotten it to work several places using the same method, but it always fails at this point with this message: 'Feature is not available.' Here is my code. Any ideas as to why this works sometimes, but not now?
> Dim cnFox As ADODB.Connection
> Set cnFox = New ADODB.Connection
> cnFox.Open "Provider=vfpoledb;Data Sorurce=\\port\imagedb$\Monthly_Inventory\LocalDB\CB_DB\IN\BR_inventory.dbc"
> The error occurs on the open connection statement. Any help would be greatly appreciated!