RE: using Access to open VFP 9 DBC via ODBC
Quick question Tracy, how do you set up the ADO connection? Can you provide a quick example? -Charlie At 01:04 PM 10/4/2007 -0400, Tracy Pearson wrote: The ODBC driver supports VFP 6 and lower. If you are using features that have been added after that, you'll need to access the DBC and tables with ADO. HTH, Tracy -Original Message- From: Philip Borkholder Sent: Thursday, October 04, 2007 11:43 AM Hey All, I've been trying to connect to VFP 9 database containers from Access and am getting an error that does not recognize the tables as tables. Using the ODBC Visual Foxpro Database driver. Anyone know what to do to connect Access to VFP 9 databases? Here's the error I get: Could not execute query; could not find linked table. [Microsoft][ODBC Visual FoxPro driver]Not a table.(#123) Thanks, Philip ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using Access to open VFP 9 DBC via ODBC
I usually reference this http://www.connectionstrings.com/ I've not used Access in years for anything then a quick glance of an MDB before extracting it to VFP. HTH, Tracy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Coleman Sent: Friday, October 05, 2007 11:07 AM To: [EMAIL PROTECTED] Subject: RE: using Access to open VFP 9 DBC via ODBC Quick question Tracy, how do you set up the ADO connection? Can you provide a quick example? -Charlie ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
using Access to open VFP 9 DBC via ODBC
Hey All, I've been trying to connect to VFP 9 database containers from Access and am getting an error that does not recognize the tables as tables. Using the ODBC Visual Foxpro Database driver. Anyone know what to do to connect Access to VFP 9 databases? Here's the error I get: Could not execute query; could not find linked table. [Microsoft][ODBC Visual FoxPro driver]Not a table.(#123) Thanks, Philip --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@automationplus.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using Access to open VFP 9 DBC via ODBC
The ODBC driver supports VFP 6 and lower. If you are using features that have been added after that, you'll need to access the DBC and tables with ADO. HTH, Tracy -Original Message- From: Philip Borkholder Sent: Thursday, October 04, 2007 11:43 AM Hey All, I've been trying to connect to VFP 9 database containers from Access and am getting an error that does not recognize the tables as tables. Using the ODBC Visual Foxpro Database driver. Anyone know what to do to connect Access to VFP 9 databases? Here's the error I get: Could not execute query; could not find linked table. [Microsoft][ODBC Visual FoxPro driver]Not a table.(#123) Thanks, Philip ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.