OK. OK. We here at Perficient don’t always work with bleeding edge technology. And who can resist a chance to blog about FoxPro!
I’ve recently been working on converting some DTS packages to SSIS and ran across a strange issue with the OLE DB provider for Visual FoxPro 9.0. Long story short, I created a connection manager that pointed to a “free table directory” that hosted a couple of .dbf files. No big deal. I was able to validate connections in BIDS and also run a preview from the OLE DB source object. Everything looked good. However, any attempt to run the task in the debugger resulted in the following error:
[CLLREC [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “FoxPro Tables” failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
I found a lot of hits on the web with similar issues, but nothing that pointed to this exact situation. After lots of poking around and fruitless troubleshooting efforts, I was about to throw in the towel. But then I realized that my test server was 64 bit….so I decided to try to flip the Run64BitRuntime setting to “False” in the Debug Options settings for the project.
Happily, that did the trick. FoxPro lives on! So the moral so the story is: Be especially careful about 64 bit support when working with legacy drivers and middleware.
I’ve recently been working on converting some DTS packages to SSIS and ran across a strange issue with the OLE DB provider for Visual FoxPro 9.0. Long story short, I created a connection manager that pointed to a “free table directory” that hosted a couple of .dbf files. No big deal. I was able to validate connections in BIDS and also run a preview from the OLE DB source object. Everything looked good. However, any attempt to run the task in the debugger resulted in the following error:
[CLLREC [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “FoxPro Tables” failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
I found a lot of hits on the web with similar issues, but nothing that pointed to this exact situation. After lots of poking around and fruitless troubleshooting efforts, I was about to throw in the towel. But then I realized that my test server was 64 bit….so I decided to try to flip the Run64BitRuntime setting to “False” in the Debug Options settings for the project.
Happily, that did the trick. FoxPro lives on! So the moral so the story is: Be especially careful about 64 bit support when working with legacy drivers and middleware.
Excelent!!! thank you very much!!..i was looking for this error all day!