Need to use data from mdb and sql dbs
Using C# MSVS 2k8. I need to connect with data from an mdb and Sql Server in one app, creating an environment which will allow the datasets to be queried together. Both are real-time dynamic data sources so they can't be imported or moved. I seem to remember someone doing this but now that i need the technology, I can't find it. My Access knowledge is good, my C# just ramping up. Am I overlooking something really simple?
Re: Need to use data from mdb and sql dbs
Quote:
Originally Posted by Solondo
Am I overlooking something really simple?
This is not easy to answer since you have not said what you have actuall done. You can use ADO.NET to query both Access and SQL Server databases. The only difference will be in the connection to each database. Everything else should be the same. Are you familiar with ADO.NET? There are many many samples on MSDN and elsewhere on the web.
