We are using the microsoft visual foxpro ODBC driver that comes with the latest version of MDAC. Where can I find alternative drivers to replace this one? The reason for this is because we want to use a query tool (called BI/Query made by Hummingbird) for our visual foxpro 6 database, but since our current ODBC driver does not support outer joins, we can't use this query tool. <br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need new Visual Foxpro ODBC Driver
- Thread starter akian
- Start date
Are you certain it does not support outer joins? Not knowing how this tool operates, there are two methods that could be used for outer joins: one is the native VFP syntax, and the other is the ODBC syntax, which uses the <font color=red>oj</font> instruction (all ODBC commands are contained within curly braces {} ).<br><br>For an explanation of ODBC outer join syntax, see here:<br><A HREF=" TARGET="_new"> <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
