Oh and one other thing.... if you programatically set up the datasource then you need to use the FULL path to get access to tables on a network/server device i.e the full UNC path or a mapped drive location. I prefer the mapped drive location myself because sometimes UNC paths with spaces in occasionally tend to screw up the ODBC driver for no reason whatsoever.
Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Cully Sent: 27 April 2011 16:52 To: [email protected] Subject: ODBC from FPDos? I just got a call from an AFUG collegue and he has a potential project for upsizing a FPDos application from using FP tables to some SQL Server. They're considering PostgreSQL which I've used in the past but only with VFP. These FPDos tables are hitting the 2G limit. Is it possible to use ODBC in FPDos? Any other 'gotchas'? Thanks, Kevin [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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.
