Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Creating a DSN in Widows XP for an Oracle Database

Posted on 2005-03-25
5
Medium Priority
?
777 Views
Last Modified: 2008-01-09
I have a:
Username
Password
IP Address
SID

For a database I would like to reverse engineer in Visio.  It seems as though I have to set up a DSN for this first in the Control Panel.   How do I do this?

What do I fill in for:
Data Source Name
Description
User Name=this I know
Server???


Please let me know!
0
Comment
Question by:superfly18
  • 2
  • 2
5 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 13632146
in general:
Data Source Name:  This can be anything.
Description:  Can be anything.
Server:  The DB alias set up in your tnsnames.ora file.
0
 
LVL 1

Author Comment

by:superfly18
ID: 13632226
Is the alian the first line of each entry?  The thing before the = sign?
0
 
LVL 1

Author Comment

by:superfly18
ID: 13632264
When connecting via visio, I get an ORA-12154:  TNS: could not resolve service name
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 750 total points
ID: 13632357
There is a problem with the Oracle client setup.

from a command prompt try and post results:
tnsping <dbalias>

where <dbalias> is the alias name used for Server in the DSN entry.
0
 

Expert Comment

by:jayaprakashbindi
ID: 13642855
for visio one can use odbc or microsodt driver for oracle for connection to the database .

I recommend u to use third party tools like erwin for doing reverse engg .,

I think once u create DSN , do test connection and check all the credentials for connection making .

or we thing u can do is generate oracle object script and do changes to script as of to visio.



 
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question