All Questions
Tagged with connection-string oracle
134
questions
296
votes
8
answers
800k
views
How to connect to Oracle using Service Name instead of SID
I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this:
jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:...
- 15.1k
53
votes
5
answers
106k
views
Default Schema in Oracle Connection URL
I'd like to set default database schema in Oracle Connection URL
jdbc:oracle:thin:@<server>:<port1521>:<sid>
My sample SQL statement:
select monkey_name from animals.monkey
I ...
- 2,914
14
votes
2
answers
77k
views
Oracle connection string without tnsnames.ora file
I am using the .NET framework with the System.Data.OracleClient namespace. I have the oracle 11 client installed on my computer. I do not want to use the tnsnames.ora file to store connection ...
- 3,190
13
votes
3
answers
73k
views
What is a TNS:listener in the Context of Oracle?
Borderline ServerFault question, but figured I'd try here first since I've had luck with Oracle questions in the past.
I'm trying to connect to an oracle database from PHP, and I'm getting the ...
- 165k
12
votes
3
answers
74k
views
Sql developer custom connection string
How to use custom connection string in Oracle sql developer to connect?
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=147.22.109.218)(port=1521))(ADDRESS=(PROTOCOL=TCP)
(...
- 203
11
votes
3
answers
34k
views
OracleConnection.Open is throwing ORA-12541 TNS no listener
So I am connecting to an external server through C#. I just installed Oracle 11g client on my machine from here: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html (255MB ...
- 6,148
11
votes
4
answers
2k
views
How to connect with System.Data.OracleClient to oracle db with windows authentication?
With Oracle SQL Developer I can put / -character to Username and leave password empty and I get connected. I have OP$MYWINDOWSUSERNAME user created in database.
EDIT: SQL Developer does not work if I ...
- 8,114
10
votes
4
answers
53k
views
How to connect to Oracle DB from .NET?
When I open SQL Command Line, I write CONNECT username/password@[//]host[:port][/service_name] and it connects me to the database just fine. However, I'm unable to connect from a .NET project using a ...
- 103
10
votes
3
answers
95k
views
How to get SID, Service Name and Port for Oracle database?
I have oracle database running on address xx.xx.xx.xx
I know login, password and initial catalog
I am trying to set up new connection in Oracle SQL Developer so I can access this database to take a ...
- 5,138
9
votes
0
answers
8k
views
A null was returned after calling the 'get_ProviderFactory' method on a store provider instance of type 'Oracle.DataAccess.Client.OracleConnection
I am using Entity Framework 4.4 code first(Factory Pattern) to get data from existing Oracle view. Here is my entity class:
class Data
{
[Required]
[StringLength(50)]
public String ...
- 91
7
votes
4
answers
30k
views
How to include sid and port into an oracle connection string?
I would like to specify the port and sid in the connection string. After the following code runs
public static string ConnectionString
{
get
{
string host = Config.CsHost;
...
- 2,156
7
votes
2
answers
7k
views
How to change the schema via connection string when connecting to Oracle using Entity Framework?
When I generated the EDMX file it set the Schema for each EntitySet
<EntitySet
Name="TableName"
EntityType="Model.Store.TableName"
store:Type="Tables"
Schema="MySchema" />
The ...
- 89.8k
7
votes
1
answer
3k
views
Entity Framework - Use Dynamic connection string with Oracle Provider
I need help ! I'm not sure the title is significant enought so i will try to explain better.
I work on an angular web site that uses http requests to a ASP.NET web api site.
My database is an Oracle ...
- 454
6
votes
1
answer
16k
views
ODP.NET Integrated Security Invalid Connection String Argument
What am I missing?
<add name="test"
connectionString="Data Source=TEST_ORACLE;Integrated Security=Yes;" />
[ArgumentException: 'Integrated Security' is an invalid connection string ...
- 11.4k
6
votes
1
answer
3k
views
Is there an Oracle equivalent to SQL Server's Application Name Connection String Parameters?
When connecting to a Sql Server you can include either "App" or "Application Name" in the connection string. This makes is very easy to trace apps that share a username/password.
One good use for ...
- 5,785
5
votes
5
answers
14k
views
Oracle connection string with at sign @ in pasword
I have a code that connect to oracle using connection string:
conn = cx_Oracle.connect('username/password@server:port/services')
But the problem is my password contain @ character so it may become
...
- 13.9k
5
votes
2
answers
7k
views
LINQPad - Connection String to my Oracle DB
I just started using LINQPad and all works great when connecting to my SQL Server DB, but now I'm trying to set up a second connection to my Oracle DB and I'm getting stuck as to how to do it.
I ...
- 19.3k
5
votes
3
answers
11k
views
To close or not to close an Oracle Connection?
My application have performance issues, so i started to investigate this from the root: "The connection with the database".
The best practices says: "Open a connection, use it and close is as soon as ...
- 4,303
5
votes
3
answers
16k
views
Oracle: what is the "instantclient" connection string format?
and how does it differ from the regular connection string?
- 302k
4
votes
7
answers
8k
views
cannot connect to oracle server from C#.net application
I'm trying to connect to remote Oracle server. My connection string -
OdbcConnection con = new OdbcConnection();
con.ConnectionString = @"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= xxxx)(...
- 1,496
4
votes
1
answer
4k
views
Python Connect to Oracle DB
I currently use PYODBC to connect to MS SQL Server and MYSQL, but now need to access an Oracle database as well.
I have Oracle SQL Developer installed on my work comp (but there doesn't seem to be ...
- 2,150
4
votes
1
answer
3k
views
How to set Initial Catalog in connection string for Oracle?
I'm trying to setup IdentityServer3 to work with Oracle database. I've got working MSSQL solution and I need Oracle variation too.
During initialization I get following error. It looks like provider ...
- 1,329
4
votes
2
answers
10k
views
Oracle Connection String With Windows Authentication
We have a requirement to make our products work on Oracle as well as SQL Server (around which they were originally built). Unfortunately we don't have any in house Oracle development experience to ...
- 2,023
4
votes
0
answers
4k
views
How to use encrypted connection string on app.config with Dataset.xsd generated by Wizard on Windows Form
I'm developing an MDI application with Visual Studio 2013 (.NET 4.5) and Oracle Developer Tools latest release. I need to create a main form that then will be the container for many different forms, ...
- 1,961
3
votes
1
answer
7k
views
How do you Configure the Connection String for ODP.NET Connection String with FailOver?
Converting to ODB.NET from System.Data.OracleClient and need help converting my connection string. Here is what I use with System.Data.OracleClient.
SERVER=(DESCRIPTION_LIST=(LOAD_BALANCE=yes)(...
- 2,985
3
votes
5
answers
10k
views
How can I connect to an Oracle database as SYS using an ADO connection string?
I am trying this:
Provider=MSDASQL.1;Persist Security Info=False;User ID=sys;Password=pwd;Initial Catalog=DATABASE;Data Source=OdbcDataSource;DBA Privilege=SYSDBA
But I get the error:
[Microsoft][...
- 58.1k
3
votes
2
answers
12k
views
Storing Password in SSIS Package
I have an SSIS Package which is used to connect Oracle. I used the Oracle Provider for OLEDB connection manager in SSIS. I have specified my server name, user name and password, selected the check ...
- 3,420
3
votes
4
answers
21k
views
The value's length for key 'data source' exceeds it's limit of '128'
I know that a very similar question has been asked here, but the answer didn't help me.
I am using Entity Framework 6 with the Oracle.ManagerDataAccess.Client.
If I define the connection string in ...
- 3,737
3
votes
1
answer
15k
views
Oracle ODBC TNS-less connection string (for 64-bit Excel)
Is there a 64-bit Oracle ODBC driver that supports TNS-less connection (or EZ-Connect) convention? I used to use "Microsoft ODBC for Oracle" which allowed a TNS-less connection string, but that has ...
- 45
3
votes
1
answer
12k
views
Connection String - Oracle
I need to connect an Oracle server with C#.
Here is the parameters for the string.
server : dbs.cs.hacettepe.edu.tr
port : 1521
sid : ORAVT
What is the connection string for these?I tried many ways ...
- 606
3
votes
2
answers
9k
views
How to make SQL*Net connect string from tnsnames.ora entry?
I am creating a data source on a reporting tool of IBM (Cognos). That asks SQL*Net connect string.
Following is my tnsnames.ora entry. I am able to connect with SQLPLUS and TNSPING from the client.
...
- 3,474
3
votes
3
answers
3k
views
How to work with multiple users accessing own database in Oracle with .NET?
My and 2 of my friends finished working on a .NET and Oracle based application for university but there's a little problem. We only noticed about it now and it's not really relevant that we fix it but ...
- 16.8k
2
votes
1
answer
7k
views
Oracle connections in Spring
I am using Oracle 9 JDBC Thin Driver - the connection string I have used for standard JDBC was:
jdbcConn.connect("jdbc:oracle:thin:myDevDb/myDevDb@fooServer:1521:MYSIDNAME");
...just trying to get ...
- 6,633
2
votes
1
answer
10k
views
'Unicode' is an invalid connection string attribute Asp.net
My code have error ---- 'Unicode' is an invalid connection string attribute
Web Config :
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=XE;Persist Security ...
- 302
2
votes
2
answers
12k
views
Provider cannot be found on Windows 7 64 bit
I am trying to run our very old application on Windows 7 64 bit. In this application we use our do template in which there are a Visual Basic scripts. I have a problem with database provider. This is ...
- 387
2
votes
2
answers
40k
views
Connection string to Oracle 10g DB using VB.net
Hey all i am VERY new to a Oracle DB and i am trying to connect to it via VB.net 2010. I have been trying the following:
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
Dim dr As ...
- 10.3k
2
votes
3
answers
1k
views
Point ADO.Net DataSet to different databases at runtime?
I have a large ADO.Net dataset and two database schemas (Oracle) with different constraints. The dataset will work with either schema, but I want to be able to tell the dataset which schema to use (...
- 4,400
2
votes
3
answers
12k
views
Connection string for Oracle using Entity Framework and LDAP
I have an ASP.NET 4.0 application that is using Entity Framework 4.3 to connect to Oracle database. Connection on a development environment is not a problem because we use the standard method. ...
- 4,697
2
votes
1
answer
3k
views
Can Oracle encoding be set in connection-string?
My test-database has a AL32UTF8 encoding, however the production database has a WE8ISO8859P1 encoding. My application is writen in .NET and I use the default System.Data.OracleClient.OracleConnection ...
- 3,180
2
votes
1
answer
583
views
TNS oracle connection failed from MVC3 site using ASP.NET Membership provider
We have an MVC3 site that uses the ASP.NET Membership Provider with Forms Authentication to let users onto the site. We have an Oracle database behind it.
It all works in house on development ...
- 569
2
votes
1
answer
9k
views
Oracle Ole DB drivers won't work: ADODB.Connection error '800a0e7a'
I've installed three of the client packages on Windows Server 2008 Standard but still cannot open a connection because of the error "Provider not found". All of these packages are for 64bit.
...
- 6,309
2
votes
1
answer
7k
views
oracle connection string with SID in c#
Hi I have to connect to an Oracle Database( about which I know a little) using a windows application.
The windows application will not necessarily be in the same system.
I just needed the connection ...
- 453
2
votes
0
answers
2k
views
connect to oracle DB using TnsNames Alias
In my TnsNamesOra I have
TEST11.12.13.14 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.12.13.14)(PORT = 1234))
)
(CONNECT_DATA =
(SERVICE_NAME = ...
- 4,470
2
votes
0
answers
628
views
Visual studio C# oracle database
I have a problem with only one possible solution. We have created a
school oracle database on the school's VPN. In my SQL Oracle Developer
I currently have this configuration:
I found ...
- 1,428
2
votes
3
answers
173
views
How to dynamically choose and connect to Oracle through C# (Dev Vs Test Vs Production Server)
Our company is looking to change from a legacy system to rebuilding everything in C#. Over the years we changed from our original database to having an Oracle backend. And now we have a 3 layers ...
- 31
2
votes
1
answer
3k
views
How do I setup OLEDB to connect to a remote database?
I am locally running an Oracle 11g database. I have a small program connecting to it in code via OLEDB in VC++ (It only runs some database tests, I'm making sure I have all the basics down before I go ...
- 787
1
vote
3
answers
5k
views
Remote ORACLE server connection string
Ive got a winxp remote Oracle Server and a Windows 7 machine with IIS.
I will be hosting a site on the win7 machine, getting information from an Oracle DB on my winxp machine.
However, when i load ...
- 45
1
vote
1
answer
385
views
How to use Oracle Managed DataAcess provider to access a local Oracle XE 11.2 instance?
I downloaded and installed Oracle XE 11.2 on my developer machine. I managed to access it with SQL Plus using the SYSTEM username and the given password.
Now for testing purposes I need to access ...
- 12.6k
1
vote
1
answer
2k
views
Oracle database connection string PLSQL compatibility
I'm using an application called Logi info. it requires a connection string to my oracle database. the connection works fine but in order to configure the connection to recive ref cursors from the ...
- 21.8k
1
vote
1
answer
9k
views
Oracle VBA connection string
How does one properly establish a connection string for integrating a macro-enabled PowerPoint to be able to query an Oracle database? I have seen many old youtube videos and online tutorials ...
- 303