linking with f90sql pro

[esatel]

Hi, Steve Lionel very graciously made f90sql lite available a number of years ago. His contribution included:

1. Altered source code for the fortran modules.

2. The f90sql *.mod files presumably generated from this source that include updated interfaces for Intel.

3. A dll representing f90sql lite implementations.

The Lite versions work well. The Pro versions seem to work OK to the extent that they are just more powerful versions of functions in the Lite API. Unfortunately, there are Pro-only routines that are not included in the Lite source. One example that is ubiquitous in f90sql examples is f90sqldriverconnect.

So, instead of asking for a fish...

Anyone with an f90sql pro license will have the pro interface sourceavailable for a recompile. Comparing the original Compaq pro code to the Steve Lionel lite version, it seems the only difference is a DEC attribute statment like this:

!DEC$ ATTRIBUTES STDCALL,REFERENCE,MIXED_STR_LEN_ARG,DECORATE,ALIAS:"F90SQLFUNCTIONEXISTS" :: f90SQLFunctionExists

...where f90SQLFunctionExists is routine-specific and the rest of it looks the same for every routine. Would it make sense to write a little script that goes through the pro source file and adds an analogous attribute line to each routine? Is that all I need to do -- I can just recompile? Has anyone tried this. Steve, are you out there and this is what you did?

Thanks much,

Eli

[Steven_L_Intel1]

Yes, that's exactly what I did. It might be easier to start with the Lite version I provided and add the missing routines to that.

[esatel]

Thanks. I found adiff tool that did most of the work adding the missing DEC ATTRIBUTEs to the pro code. All the examples now run fine for me, including pro and lite.

So, I'll try to wrap up the experience since the earlier threads on this subject are incomplete. For those who have the f90sql pro product installedand are trying to salvagef90sql pro functionalityfor legacy code,a decent approach that minimizes changes in your project setups is this:

1. Make sure you have the DFORRT.dll runtime library available on your dll search path (e.g. in c:windowssystem32).

2. Add the DEC ATTRIBUTE directives directly into your f90sql.f90 source file. Only this file requires changes.If this thread doesn't explainthe added directivesadequately, compareSteve Lionel'sf90sql.f90 in the zip file he distributed to theversion in your Canaimasoft install directory.

3. Launch the ReCompilef90SQL.bat provided by Canaimasoft. Once you have recompiled the mod files, yourf90sql pro installationshould be functional with new, Intel-friendly mod files.In theory, everything from the original distribution is just where you want it.

This approach doesn'tuseSteve's files, just his approach. Threadhas nothing to do with acquiring f90sql pro functionalityif you don't already have it.If you have no legacycommitment to this product you should consider yourself lucky.

Eli