Connect to a remote database

Hi,
     I would like to connect to a remote database. How to i do it. I dont want to connect it thru a web service.Other than that is there any method?
One more question is why is crystal reports listed under database. Is crystal reports a database? This question has always been lingering on my mind
unnaAsked:
Who is Participating?
 
Krelek200Connect With a Mentor Commented:
In the datasource Administrator, you can specify the database DSN's in the System, File DSNs.  I usually you can use these to specify where the databases are.  It is a simple process.  Click on the System DSN.  Click on Add.  Then click on a reference to an Oracle ODBC datasource driver.  Click on finish.  Then type in the DSN Name, Server Name, User Names, and if available do a Test Connection.  This is as if you are logging onto the database.  If successful then you have set up the remote datasource.
0
 
unnaAuthor Commented:
Well i forgot to metion that there are four different databases located at 4 different places. I need to connect to these databses and produce a report combined these 4 databases.
0
 
Krelek200Commented:
Have you tried using the Datasource Administrator?  It is located under Control Panel ---> ODBC Datasource Admin (win 98/me) or Control Panel ----> Admin Tools ----> Datasource Administrator (Win XP/2000)

Now for connect 4 databases to one, you might have a problem.  Different databases can mean different datasource Drivers.  You might want to pull the information into Microsoft Access and build the report from that.  Crystal might give you some problems...

Ben
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
unnaAuthor Commented:
Well all the 4 databases are oracle DB .How can i use a odbc connection for a database located at 4 different places? I dont understand can u explain to me in detail
0
 
Krelek200Commented:
Do you know of the database's DSN names?
0
 
unnaAuthor Commented:
I know DSN. Do i give the username password of the system to login. Could u just explain in detail of what your trying to say
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.

All Courses

From novice to tech pro — start learning today.