Is there and Addon/Addin for Visual FORTRAN that will allow embedding Sequel Server and/or Access Database Calls

[David_Caruthers]

I thought I saw a description onf a product a while back which would allow embedding Sequel Database commands in Visual FORTRAN.

Need this as it would be much more efficient and palatable to the higher ups for the current FORTRAN report program to directly access the database for calculation factors. Currently the needed data is exported to a datafile that is read by the report generator.

David

[Steven_L_Intel1]

There are several options. ForDBC is a commercial product. f90SQL-Lite is an old, unsupported library that some people use. There's also an ODBC module from user Arjen Markus.

[Arjen_Markus]

FYI, I am currently extending this module to support BLOBs. A complication I encounter with that is that BLOBs do not seem to be standard SQL and each DMBS has its own ideas on the corresponding data types and representation. ODBC will isolate you from most of the details, but not all.

Regards,

Arjen

[Arjen_Markus]

Oh, the module is at: http://flibs.sf.net (not .org)

Regards,

Arjen

[David_Caruthers]

Thanks,

I will use the information to convince my management to allow me to connect the reporting package to the database we have.

[David_Caruthers]

Thanks Arjen.

I will try to use your module with my project also.

Reagards,

David

[Arjen_Markus]

Let me know if you have any difficulties - I stumbled on one just recently (the C part on Windows all of a
sudden expected multibyte strings) and it took me some time to sort out what on earth was wrong.

Regards,

Arjen

[Steven_L_Intel1]

Quoting arjenmarkus

Oh, the module is at: http://flibs.sf.net (not .org)

I copied and pasted the URL from another thread. I have now corrected the link above.

[Arjen_Markus]

I have made that mistake myself more than once :).

Regards,

Arjen