Can I extract ODBC driver version number?

[watabitha1]

I would like to be able to extract the version of SQL Server driver that is<br>being used on the machine running my application, so that I can enforce a<br>minimum version requirement. Any suggestions?<br><br><A HREF="mailto:charles@allecom.com">charles@allecom.com</A><br>

 

[jonscott8]

There is a useful .prg that comes with foxpro called registry.prg. It provides useful functions for manipulating registry key values. I would recommend that you first thoroughly examine the code and establish a good understanding for what its doing before proceeding cuz as you know, dealin with the registry can be dangerous. I believe the key path you are looking for is<br>HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\SQL Server<br>and the key name is DriverODBCVer<br><br>i think the syntax would be something like this:<br><br>getregkey('DriverODBCVer', @lcValue, 'Software\ODBC\ODBCINST.INI\SQLSERVER', HKEY_LOCAL_MACHINE)<br><br>Hope this helps<br><br>Jon Hawkins<br><A HREF="mailto:jonscott8@yahoo.com">jonscott8@yahoo.com</A>