Generic Connectivity using ODBC - Heterogeneous Connectivity

Plzzzz help,
Can anyone please help me to connect Oracle DB with Sql Server 2000
I am looking for a complete step to do so.
plzzzz help.
Regards
Rashid 

Take a look at Chap 2 of the following document.
http://otn.oracle.com/docs/products/gateways/doc_library/92/nt/tg4sql/a96552_01.pdf

Related

Oracle 8i and DB2 Connectivity

Hi,
I want to connect to DB2 from Oracle 8i. I have read some documentation about Oracle gateways but it is not clear of how exactly we can connect to DB2.
If any one has done this before please let me know th detail steps of how we can connect to DB2. 
hi,
u should see the documentation of administrator guide >> distributed databases for further details.
usually we use heterougeneous services to connect to non-oracle dbms.
regards
umar
Hi Muhammad,
Thanks for your reply. I want to know the detailed steps invovled in connecting DB2 from oracle.
I would appreciate if you could provide some more help in this regard.
Thanks,
Ajay

DB Link

Hi buddies,
Seasonal Greetings.
I would like to know if there is a way of using db link to connect to sql server to migrate the tables from sql server to oracle?
I heard my collegues (sql server guys) saying that it works.
Please advice.
Thanking in advance.
Cheers!
Nith 
Yes it is possible see
http://www.databasejournal.com/features/oracle/article.php/3442661/Making-a-Connection-from-Oracle-to-SQL-Server.htm
http://www.dba-oracle.com/t_connecting_sql_server_oracle.htm 
Also check:
Dblink with Sqlserver  & Driver ODBC to connect Sqlserver
Re: Regarding pulling data from sqlserver to ORacle
Regards
Rajesh 
Dear buddies,
I tried some guidance from these urls and one of them worked perfectly!
It is http://www.databasejournal.com/features/oracle/article.php/3442661/Making-a-Connection-from-Oracle-to-SQL-Server.htm
Thanks a lot to everyone.
Chinar,
Thanks for the link.
Regards,
Nith

Connection to a Access Database

Good evening! Can I Know what are the single step to connect my application Java to a Access Database? Please, I need a specific explanation of all this steps. I hope that you are fast, please.. Thank you Mimmo 
http://forum.java.sun.com/thread.jsp?forum=31&thread=413501

Oracle 9i database Installation

Hi,
I am installing Oracle 9i database."Oracle Database Cofiguration Assistant" Confirugation taking more time in the Configuration Tools wizard.It took around 2 hours and still it is running.Please let me know is it a known issue.
Please guide me with any solution.
Thanks in Advance,
Laxman 
Hi Laxman,
Please let me know which step are u in.ideally it shouldnt take 2 hours. please post more info. 
user640304 wrote:
Hi,
I am installing Oracle 9i database."Oracle Database Cofiguration Assistant" Confirugation taking more time in the Configuration Tools wizard.It took around 2 hours and still it is running.Please let me know is it a known issue.
Please guide me with any solution.
Thanks in Advance,
LaxmanWhat exactly do you want us to look at? Atleast provide the step that you are stuck in.
Alternately, you can check the installation log for any issues.
Regards,
Z.K.

Help -

Hi all,
Is there any Equivalent command for connect by prior & connect by level from oracle into DB2.
Can anyone help out.
Thanks in advance
Nirmal 
Hi,
I just want to know the Equivalent command in DB2.
Cheers 
Have you try to post on a DB2 forum ? Or by reading the DB2 doc ?
Nicolas. 
Hi ,
Can tell me the link for DB2 forum. & I went thru the DB2 materials but coudnt find the
equivalent command for it.
Thanks
Nirmal 
type "DB2 forum" into google.
duh!

Categories

Resources