Tag Archives: .net

Get Visual Basic 2010 Express to query an Oracle database

So one of the limitations of Visual Basic 2010 Express is that you can only add data sources to link or query Microsoft databases such as an Access database or MsSQL. So if you need to query an Oracle or mySQL database, for example, it seems that you’re out of luck unless you upgrade to the paid version of the software. Thankfully if you have Microsoft Access on your computer there’s a workaround.

All you need to do is set up a linked database in Microsoft Access (look up ODBC drivers if you’re having trouble) and you can query that database as a middleman from your Visual Basic program.