Hi,
Accessing a Microsoft SQL Server 2008 database from IDL may be accomplished through the use of the IDL Dataminer ODBC drivers (provided by Progress/DataDirect, for use with IDL), provided in a separately purchased add-on module. You’ll need to contact your local Exelis VIS office or distributor to obtain an IDL Dataminer license. For IDL 8.3, Dataminer the supported versions of Microsoft SQL Server are listed in the Progress® DataDirect Connect® Series for ODBC Users Guide, Release 7.1, which is included as HTML documentation with an IDL 8.3 installation that includes the installation of the optional Dataminer module. The main DataDirect help file is located under the IDL installation at:
[IDL-directory]/help/[DataDirect or DataDirect64]/help.htm
For example:
C:\Program Files\IDL83\help\DataDirect64\help.htm
In this case, the file URL to the page listing the supported MS SQL database versions (Chapter 11 of the User's Guide "The SQL Server Wire Protocol Driver") is:
file:///C:/Program%20Files/Exelis/IDL...
For MS SQL 2008, the following versions are supported:
Microsoft SQL Server 2008 R1, R2
Also included with the IDL 8.3 Help is the IDL Dataminer PDF document file (datamine.pdf, also available from the Exelis VIS Documentation Center at the page
http://www.exelisvis.com/docs/PDF_Gui...) which provides IDL API details, as well a a general list of supported databases (note that this document is not fully updated for product version details; for clarification of supported versions of your database that work with your version of IDL, contact Exelis VIS or your local distributor).
Please note that the IDL Dataminer interface was programmed for use specifically with the DataDirect ODBC drivers included with that specific version IDL. Use of 3rd party ODBC driver is not supported and may not function as expected with IDL.
I hope this can be helpful.
Regards,
Jim (Exelis VIS)