If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

File > Get External Data > Link Tables > then when the window opens us - select the "ODBC databases" as the file type > at the next window select the ODBC you setup from the Machine Data Source > you will be prompted for the userid/password.

Are there any reasons why some people choose to connect through ODBC? I am asking because I don't know the reason why. All the client site that I have worked at don't connect through ODBC. Can you tell or explain to me the reason why some people choose ODBC? What's the significance

I guess it depends on the application connecting. I am not a developer, but I think it is easier, since the developers do not have to write any code to connect to oracle - the functionality is already provided by Microsoft/ Oracle and other vendors.

If you have metalink, check out this writeup:
[url]http://metalink.oracle.com/metalink/plsql/ml2_gui.startup[/url]