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

Oracle setting

I started to initiate a .net web application with Oracle at the back end. My first time to connect Oracle. I have the following setting in the web.config file -

    <add name="AppServ"
         connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\inetdb.mdf;User Instance=true"
         providerName="System.Data.SqlClient" />

    <add key="MyAppConn" value="User Id=inepuser; Password=inepPwd; Data Source=lt10gr2; Enlist=false"/>

Is it right setting?
  • 2
  • 2
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no, that connection string is for SQL Server.
to start with; System.Data.SqlClient  is not correct, you do have several choices.
either some generic OleDb client or the Oracle client, both needs specific code, you cannot use the same code for sql server and oracle (unless you use the generic OleDb code
minglelinchAuthor Commented:
Thank you for your comment. I was a SQL server person and now switch to Oracle. I use ODP.net. I tried to find the right setting in web.config for Oracle connection setting. I appreciate any one who can help me with issue.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
to build up good connection strings, check out this page (for Oracle):
minglelinchAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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