FoxPro7 components installation from the command prompt

[vlad074]

I have a little question about the FoxPro 7 components automatic installation from command prompt.
We have a Database interfaces made on FoxPro 7. It needs an ODBC connections with different types of database: MySQL, PostGres-SQL, but the main database is MS SQL DB. The ODBC connections needs the ODBC connectors (AKA drivers). 
To install ODBC drivers automatically according to the users server roles i have found the MySQL driver as "msi"-file, PostGres-SQL driver as "msi". These drivers is installed automatically using the vbs-script. But the MS SQL driver installes from the VFP7 distributive. And i can not find any information about si;ent installation of this connector. Would you please help with keys of automatic installation using command prompt? Like "x:\Setup\Setup.exe /NO_BSLN_CHECK" for installation without SOAP (Found there:

https://www.tek-tips.com/faqs.cfm?fid=5761

- <Mike Lewis>)?

 

[Chris Miller]

VFP7 included the soap toolkit - that has nothing to do with MSSQL.
It also included MSDE, which was like the Express editions are today. Any drivers you find there on the installation disc are for that version, comparable to MSSQL 2000.

You need current drivers for the current db versions. There is a catch because VFP7 is 32 bit, like VFP9 still also is. From that perspective you need 32 bit ODBC drivers, but you don't need the ODBC drivers from the VFP7 setup for MSDE or SQL2000, those are definitely outdated unless you really want to support an old SQL Server version, too, which surely is not recommended.

I don't think there is any difference between which drivers VFP7 and VFP9 can use as connectors, there might have been slight immprovements on the VFP cllient side of ODBC drivers. There are in fact some more modern ODBC drivers that are 32bit but not usable from VFP, not only because of different ODBC standards/versions, but also because of detail problems with certain data types.

All that aside, I'm sure you find ODBC driver setups that can be run non-interactive, the standard I know is prepared answer files that are used to auto-answer the setup questions and also make the setup silent. You better ask that in an SQL Server forum.



Chriss