| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dblink versus odbc
They may be a bit more comparable than that.
a dblink can utilise ODBC (via HS ODBC) to connect to non-Oracle databases (or to Oracle databases if you really wanted to).
ODBC can be used by client but also by server via HSODBC. ODBC can also be used by a non Oracle server (eg SQL Server) to connect back to an Oracle database.
So ask your manager for more information on why they want to compare the two.
HTH,
Bruce Reardon
NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed.
-----Original Message-----
Sent: Wednesday, 3 December 2003 3:04 AM
To: Multiple recipients of list ORACLE-L
Sure it is but ... As the manager asked and even if I did say that there
would be no Oracle Paper on this ...
Thanks a lot.
Regards
PG
-----Mensagem original-----
De: Igor Neyman [mailto:ineyman_at_perceptron.com]
Enviada: terça-feira, 2 de Dezembro de 2003 15:55
Para: Multiple recipients of list ORACLE-L
Assunto: RE: Dblink versus odbc
Can't compare "apples" and "oranges".
ODBC is for client-database connections, dblink is for database-database
connections.
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-----Original Message-----
Paulo Gomes
Sent: Tuesday, December 02, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
Hi guys
Have a request here. My management wants to know the advantage of using
dblink instead of odbc.
Does anyone have any ideas on this?
Regards
PG
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paulo Gomes
INET: PGomes_at_Datinfor.pt
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
INET: ineyman_at_perceptron.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 02 2003 - 15:44:42 CST
 |
 |