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

Need to decipher a line of code VBA/Oracle

I have a connection string using VBA connecting to an Oracle database as see below. Can someone help me decipher this code. Thanks in advance.

.ConnectionString = "Data Source=(DESCRIPTION=(CID=SHSOXP02)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=uctvp614)(PORT=25888)))(CONNECT_DATA=(SID=SHSOXP02)(SERVER=DEDICATED)));User Id=CIM_E2E;Password=temp1234;"
0
tesla764
Asked:
tesla764
1 Solution
 
slightwv (䄆 Netminder) Commented:
That is referred to as the EZCONNECT syntax for Oracle.

The docs talk about it:
http://docs.oracle.com/cd/E11882_01/network.112/e41945/naming.htm#NETAG008

Basically it is a way to connect to Oracle without a tnsnames.ora entry (also talked about in the docs).  It provides everything Oracle needs to know to find the server/database it connects with.

If this doesn't answer all your questions, please ask what specific pieces of the connect information you need clarified.
0
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

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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