Our current software system uses a MySQL database. I wrote an application in Visual Basic 2008 to run a query against the database and then send some emails. In order to make it work I had to download a MySQL data connector and then put "Includes MySql.data.mysqlclient" at the top of my program.
We are moving to a new software system that uses Openedge 10.1 as the database, and I want to be able to rewrite my program to work with the new database.
What is the equivalent data connector to allow me to connect my visual studio project to the openedge 10.1 database?
All OpenEdge runtime clients also have an odbc driver installed. Either use this driver (you can find this in the amdinistrative tools in windows) or download a driver here: www.progress.com/progress/esd/myproducts.jsp
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.
Part 1 of this series discussed basic error handling code using VBA.