You are here:

MS SQL Server/Connecting to oracle database from SQL application


Dear David,

Greetings !

We have a sql database and oracle database we are connecting from SQL (using .net application) to the oracle database ,
This is working fine however when we create a new oracle database
in a separate server , the same SQL connection is not getting connected to the new oracle database , it is giving an error
invalid user name password..

following is the connection string used for connection

<add name="IntegrationERPDBConnectionString" connectionString="Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = Majana-ERP)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = ORCL))(HS=OK));User Id=majan_test;Password=log;" providerName="Oracle.DataAccess.Client"

Best Regards

I'm afraid I don't know what this means:

we are connecting from SQL (using .net application)

Please provide more information.  

Also, I know almost nothing about Oracle, so I might be of much help here. Have you looked at the logs available in Oracle to see if it is, indeed, an invalid ID/password combination?

MS SQL Server

All Answers

Answers by Expert:

Ask Experts


David Vaughn


Performance tuning; T-SQL syntax;


Over 25 years of IT experience, the last 15 as a SQL Server developer/DBA.

Truman State University

©2017 All rights reserved.