• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

Using SQL Server and Oracle Database in one project

Currently, we use the PL SQL to connect and query the Oracle database. Software is built on .NET platform (VB, ASP). We have a implementation project in which we need to host our data set in the SQL server database too. May be completely or partially for some specific modules. Some modules might have to use data from both Oracle and SQL Server Databases.

My Question is : Please suggest a memory and cost efficient process to be able to do this. My idea about it is that we just  need to declare respective connection strings in global.asax file and use them appropriately when needed. Right ? Or is there any catch to it ?
0
pratz09
Asked:
pratz09
1 Solution
 
jasonduanCommented:
1. Don't "declare respective connection strings in global.asax file". You should put connection string in web.config file
2. in your code, you'll need use "System.Data.OleDb" instead of "System.Data.SqlClient" client so that both Oracle and Sql Server are supported
0
 
pratz09Author Commented:
Doh ! I meant web.config .. My bad.
Thanks for your input. It was helpful.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now