- Forum
- General C++ Programming
- interfacing with sql
interfacing with sql
Hi people, I am a c# developer and very new to c++. At our company we have some legacy devices and currently require some changes to be made to them. The only issue is the machines interfacing to these devices won't run .NET so it seems as if the simplest solution would be to write some code for it that is able to interface with one of our sql databases. My issue is that I don't know how to do this in c++. Can someone please provide me some references that I can lookup.
Generally speaking you can use OleDB, ODBC or ADO, however for a beginner at c++ I would most likely recommend ODBC as it seems simpler for me personally than the other two. But even using ODBC effectively on a production line machine would require a descent understanding of it before you can really proceed safely.
I would therefore rather recommend using a layer/module from one of the frameworks out there that may make your life a whole lot simpler. Two such frameworks that come to mind is Rogue Waves SourcePro DB module https://www.roguewave.com/products-services/sourcepro/sourcepro-db and the Kahless_9 utility called TblTrooper http://www.shankodev.com/docs/Tools/items/TblTrooper/TblTrooper_Page_00.htm.
If you need to work across various dbs like oracle or PostGreSQL then Rogue Wave's SourcePro DB is your best option as it allows interfacing with all these databases seemlessly. If however you only need to work against MSSQL or MS Access then I would recoomend using Kahless_9's TblTrooper since it provides one of the simplest mechanisms I've seen so far for interfacing with your sql databases from c++ by merely requiring you to point the utility to the database and then with clicks have code generated by it (TblTrooper) for interfacing with the different tables of the db. This utility also generate stored procedure code for you together with a c++ dll that can be used for such access. You can view this video of it here: https://www.youtube.com/watch?v=-dn5YSE0vzA
I would therefore rather recommend using a layer/module from one of the frameworks out there that may make your life a whole lot simpler. Two such frameworks that come to mind is Rogue Waves SourcePro DB module https://www.roguewave.com/products-services/sourcepro/sourcepro-db and the Kahless_9 utility called TblTrooper http://www.shankodev.com/docs/Tools/items/TblTrooper/TblTrooper_Page_00.htm.
If you need to work across various dbs like oracle or PostGreSQL then Rogue Wave's SourcePro DB is your best option as it allows interfacing with all these databases seemlessly. If however you only need to work against MSSQL or MS Access then I would recoomend using Kahless_9's TblTrooper since it provides one of the simplest mechanisms I've seen so far for interfacing with your sql databases from c++ by merely requiring you to point the utility to the database and then with clicks have code generated by it (TblTrooper) for interfacing with the different tables of the db. This utility also generate stored procedure code for you together with a c++ dll that can be used for such access. You can view this video of it here: https://www.youtube.com/watch?v=-dn5YSE0vzA
Topic archived. No new replies allowed.