asked on

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

unna

ASKER

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.

Krelek200

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

unna

ASKER

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

Krelek200

Do you know of the database's DSN names?

unna

ASKER

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

ASKER CERTIFIED SOLUTION

Krelek200

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial