- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
With the permission of Canaima Software, I have attached a version of their f90SQL-Lite which works with Intel Visual Fortran. f90SQL is a Fortran-friendly library for ODBC database access, and is an easy way to interact with Oracle, Access, Excel and other ODBC-compliant applications. This is their CVF version with replacement modules that are edited and compiled for use with Intel Visual Fortran.
Unpack this to a convenient location on your system and follow the instructions in f90SQLIFORTREADME.TXT I have not (yet) gone through all of the examples and changed the batch files for ifort.
This software is not supported by Intel.
Edit: I missed two DLL files - f90SQLDVF.DLL and DFORRT.DLL See the updated README for information.
Message Edited by Steve_Lionel on 02-28-2006 08:59 AM
Link Copied
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you.
david
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You may also require another DLL (DFORRT.DLL) which can be extracted from VFRUN66BI.exe (get it here - http://h21007.www2.hp.com/dspp/ddl/ddl_Download_File_TRX/1,1249,2432,00.exe).
Edmund.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Will the f90sqldvf.dll work with the Pro version of f90sql as well?
I cant test it because we havent received our copy of IVF yet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unhandled exception at 0x100015eb in fconsole1.exe: 0xC00000FD: Stack overflow.
at ExcelRead.f90, in line:
call f90SQLDriverConnect(ConnHndl, f90SQL_NULL_PTR, ConnStr, ConnStrOut, ConnStrLength, SQL_DRIVER_COMPLETE,iRet)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But now I'm getting
Unhandled exception at 0x0024f804 in fconsole1.exe: 0xC0000005: Access violation reading location 0x0098293c.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
0024F804 rep movs dword ptr es:[edi],dword ptr [esi]
(bad line above)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But now the linker can't find _SYSTEM@8, thanks to the CVF calling convention. How do I deal with CALL SYSTEM(...)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unfortunately, you only posted the free version. I would bet most people experienced with SQLhabitually usethe functions in the "pro" version. In the end - being thatF90SQLis very very very similar to ODBC API, I'd be willing to use ODBC API functions if anyone has a few samples; I have not yet done Windows API or anything similar in Fortran. Also, being that they actually discontinued F90SQL, perhaps they would be willing to give you a "pro" version for the Intel compiler?
But I got off my original question. I included libIFPORT.lib, and I'm still getting
Error1 error LNK2019: unresolved external symbol _SYSTEM@8 referenced in function _MAIN__FConsole1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add USE IFPORT to the routine in which you call SYSTEM and it should work ok.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
![Smiley with tongue out [:-P]](/ISN/Community/en-US/emoticons/emotion-4.gif)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear all, and particularly Dear Steve Lionel,
I installed F90SQL from the ZIP-file made available by Steve Lionel some time ago. When I tried to run the ExcelReadLite example, I came through the compilation succesfully, but I could not link. I think some LIB-file is out-of-date. Do you have any suggestions? (I tried to contact Canaimasoft, but they seem to have vanished into thin air.)
Yours sincerely,
Niels H. Veldhuijzen
Arnhem, The Netherlands

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page