Microsoft Visual FoxPro is a powerful object-oriented environment for database construction and application development. The Microsoft Visual FoxPro ODBC Driver enables applications to open, query, and update data in Visual FoxPro and earlier versions of FoxPro through the Open Database Connectivity.
Overview Progress DataDirect’s ODBC Driver for FoxPro offers a high-performing, secure and reliable connectivity solution for ODBC applications to access FoxPro data. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more. Priority.
Time Guideline Version(s) High Risk (CVSS 8+ or industry equivalent) 30 days Active (i.e. Latest shipping version) and all Supported versions Medium Risk (CVSS 5-to-8 or industry equivalent) 180 days Active (i.e. Latest shipping version) Low Risk (CVSS 0-to-5 or industry equivalent) Next major release or best effort Active (i.e.
Latest shipping version). Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to.
Hi Mike, I have been using Visual FoxPro with Postgresql for two years. Currently my front end is Visual Foxpro 9.
I do not have the Postgresql on a Windows server, I am on a Linux server that is running RedHat 9. I upgraded my Postgresql two months ago and I am on version 8.1.4. My clients connect with the Postgresql ODBC driver for Windows. I haven't had any problems with this combination.
I handle most of the access rights in the VFP application. To access the server data I am using SQLCONNECT and then SQLEXEC to send queries. The program I use to manage the databases is PGADMIN III on Windows. There are other VFP programmers on the pgsql-general maillist and some of them work with both Postgresql and MySql (Windows and LInux).
They have helped me before when I hit snags. Many of them have been using this combo since VFP 6. There are programmers on the www.UniversalThread.com which use this combo too. Hope this helps. Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient(s), please contact the sender by reply email and destroy the original message and any copies of the message as well as any attachment(s) to the original message. Mike Copeland 12:27 AM Please respond to [email protected] To [email protected] cc Subject Foxpro + PostgreSQL Margaret, I found a post of yours on the PostgreSQL website.
It didn't look like you had ever gotten a response so I am writing to ask if you have pursued the Foxpro+PostgreSQL combo, or not. I have years of Foxpro (currently on 9) experience, and began using MySQL as a backend a couple of years ago.
Now that I'm getting close to rolling out an application I wrote (Foxpro frontend, MySQL backend) I'm getting nervous about the licensing issues with MySQL. So, I'm looking into switching from MySQL to PostgreSQL. All that to ask, did you have any success in your attempts to use this combo?
I've been using the sqlstringconnect function in Foxpro 9, but is that possible with PostgreSQL? There seems to be a dearth of info available about using FP9 as a frontend to PostgreSQL.everyone seems to focus on which is better, blah blah blah. Thanks for any and all feedback! Mike Copeland Genesis Software Group. Margaretgillon I have not had problems with integers but I am using a VFP class for SQL server backends that was written by someone else.
Best thing is to try it yourself. If you need support sign up for the psql-general list. They're a good resource and have subscribers from all platforms. Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext.
297 This e-mail message and any attachment(s) are for the sole use of the intended. I have not had problems with integers but I am using a VFP class for SQL server backends that was written by someone else.
Best thing is to try it yourself. If you need support sign up for the psql-general list. They're a good resource and have subscribers from all platforms. Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient(s), please contact the sender by reply email and destroy the original message and any copies of the message as well as any attachment(s) to the original message.
Mike Copeland 11:06 AM Please respond to [email protected] To [email protected] cc Subject Re: Foxpro + PostgreSQL Margaret, It helps a lot! Now all I have to do is figure out why another guy wrote me back saying that he had struggled with using PostgreSQL for 2 years and recently switched to MySQL (along with buying licenses for his customers) and, in his words, 'it was a breath of fresh air!' From the rest of what he wrote, he indicates that PostgreSQL is a pain to manage.as in adding users, etc. I think I'll try PGADMIN III as you recommended below. Do you recall running into any weird data type problems with the ODBC connection?
With MySQL, there's a weird thing with whole Integers versus decimal place number field types.I don't recall the exact problem but I do remember it drove me up the wall last year before I figured it out. Turned out to be an ODBC bug that no one has any desire to fix since there's a workaround. Thanks again and thanks for any feedback. Mike [email protected] wrote: Hi Mike, I have been using Visual FoxPro with Postgresql for two years. Currently my front end is Visual Foxpro 9. I do not have the Postgresql on a Windows server, I am on a Linux server that is running RedHat 9.
I upgraded my Postgresql two months ago and I am on version 8.1.4. My clients connect with the Postgresql ODBC driver for Windows. I haven't had any problems with this combination. I handle most of the access rights in the VFP application. To access the server data I am using SQLCONNECT and then SQLEXEC to send queries. The program I use to manage the databases is PGADMIN III on Windows. There are other VFP programmers on the pgsql-general maillist and some of them work with both Postgresql and MySql (Windows and LInux).
They have helped me before when I hit snags. Many of them have been using this combo since VFP 6. There are programmers on the www.UniversalThread.com which use this combo too. Hope this helps. Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure.
Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient(s), please contact the sender by reply email and destroy the original message and any copies of the message as well as any attachment(s) to the original message.
Mike Copeland 12:27 AM Please respond to [email protected] To [email protected] cc Subject Foxpro + PostgreSQL Margaret, I found a post of yours on the PostgreSQL website. It didn't look like you had ever gotten a response so I am writing to ask if you have pursued the Foxpro+PostgreSQL combo, or not. I have years of Foxpro (currently on 9) experience, and began using MySQL as a backend a couple of years ago.
Now that I'm getting close to rolling out an application I wrote (Foxpro frontend, MySQL backend) I'm getting nervous about the licensing issues with MySQL. So, I'm looking into switching from MySQL to PostgreSQL. All that to ask, did you have any success in your attempts to use this combo?
I've been using the sqlstringconnect function in Foxpro 9, but is that possible with PostgreSQL? There seems to be a dearth of info available about using FP9 as a frontend to PostgreSQL.everyone seems to focus on which is better, blah blah blah.
Thanks for any and all feedback! Mike Copeland Genesis Software Group. On 9/7/06, [email protected] wrote: I have not had problems with integers but I am using a VFP class for SQL server backends that was written by someone else. Best thing is to try it yourself. If you need support sign up for the psql-general list.
They're a good resource and have subscribers from all platforms.I used VFP for pg ages ago and found it to be an 'ok' combination. Honestly, if you want to do that type of development, Delphi is superior in every way. However, if you must do it that way, pg is fine. The performance will be largely driven by the vfp odbc pass though engine, not the backend server.