Useful Links for f90SQL Users

This section contains links that may be of interest to f90SQL and f90ADO users. Some links are to our server, other are to external sites. This is a very dynamical page, with new links added frequently, so make sure that you request a refresh or reload each time you visit.

Available ODBC drivers and vendors:

• Annotated list of ODBC drivers (with links to vendors)
• Ken North's list of ODBC drivers, servers and vendors. This is likely the most complete and up to date list in the web.

General Articles:

• Accessing Data from Multiple Sources with the Universal Data Access Technologies. 1998. Stephen Rauch.
• Understanding Multidatabase APIs and ODBC. 1994. Ken North.  A little bit outdated but still excellent reading material.
• Understanding ODBC Security Issues.
• Microsoft APIs Expand Web Data Access Options. 1998.  Ken North. Explains Universal Data Access with ODBC, OLE DB, and ADO.
• Understanding ODBC and OLE.
• Database Programming with OLE and ActiveX. 1996. Ken North. General article explaining OLD dB and ADO.
• Understanding ODBC 3.0 Standards and OLE dB 1996. Ken North. Another excellent article explaining ODBC standards and introducing OLE dB
• Performance Testing, ODBC, and Native SQL APIs. 1996. Ken North.
  

Web pages of compilers supported by f90SQL:

• Intel Visual Fortran (support under development)
• Absoft Pro-Fortran
• Lahey Fortran 90 and Fortran-95
• Salford FTN95

Microsoft Site. Links in Microsoft web site that may be of interest to f90SQL users:

• Microsoft's Universal Data Access Web Site: This is the main site for Microsoft's data access technology. It includes the Data Access SDK's, many technical and non-technical articles and the last gossips about ADO. A must for any Windows programmer working with databases.

• MDAC Frequently Asked Questions.
• ODBC Frequently Asked Questions.
• ADO Frequently Asked Questions.

• Articles from Microsoft's Knowledge-Base and ODBC Bug reports
  • Q134684 - MSQUERY: Some ODBC Drivers Do Not Support Delete
  • Q178717 - INF: Excel ODBC Driver and Text ODBC Driver Notes
  • Q189839 - BUG: Uninstalling VB 5.0 via VB 6.0 Removes All ODBC DSNs
  • Q190773 - INFO: ODBC/OLE dB/ADO/RDS Are Inter-Dependent for MDAC 2.0
  • Q130137 - How to Use ODBC to Run SQL SELECT on Microsoft Excel Data
  • Q198428 - BUG: ODBC Prepared Statement Errors with Temporary Tables
  • Q198265 - BUG: Failed Sp_prepare Incorrectly Closes Transaction
  • Q196384 - HOWTO: Perform Bulk Inserts Using SQLSetPos
  • Q195927 - INF: Using Version 3.6 Microsoft SQL Server ODBC Driver
  • Q195017 - BUG: Memory Leak in Microsoft Access ODBC Driver
  • Q187393 - BUG: "Error in Assignment" Accessing BLOB Data in FoxPro dB
  • Q186380 - BUG: Error When Using Table Aliases with Oracle ODBC Driver
  • Q181254 - INF: How to Use SQL_C_NUMERIC Data Type with Numeric Data
  • Q173097 - ACC: Query w/Time Criteria Returns No Records from MS SQL Server
  • Q171910 - BUG: If RPC Is Used, SQL Server ODBC Driver Converts in Place
  • Q169469 - BUG: SQLState S1000 with SQL_AUTOCOMMIT_OFF/SQLTransact
  • Q156500 - INF: Processing Procedures and Batches with Multiple SELECTS
  • Q151536 - INF: SQLPrepare and Temporary Stored Procedures in SQL Server