MSDAORA connection from Excel macro

Sorry if this is a lame question, I am not a developer but more of a network
admin.

I have inherited an Excel macro that users the MSDAORA provider to establish
a connection to an Oracle database.

Looking on the Internet I have found that this users the "Microsoft OLE DB
connection for Oracle". My question is does the OLE DB still use the ODBC
drivers at a lower level? The reason I ask is that ODBC is apparently not
that secure in it sends username/passwords in clear text, and to secure the
connection by tunnelling it through SSH is the best option.

Is this still the case when using OLE DB for Oracle? Or does it in fact use
the oracle client installed on the computer for the connections to the
database, and if you use oracle's advanced security on the oracle client to
encrypt the database connection, will accessing the database via OLE DB
provide an encrypted connection to the database via the oracle client?

Thanks for you help.

Mat.
.

Relevant Pages

  • Re: Word 2003 Closes upon update of sort order of table using Acce
    ... data connection file created to the database folder and created a dummy user ... connection is much faster and seems far more stable. ... > incorporate OLE DB, they probably found themselves with a lot more> problems ... start the process of connecting to a data source ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2003 Closes upon update of sort order of table using Acce
    ... data connection file created to the database folder and created a dummy user ... connection is much faster and seems far more stable. ... incorporate OLE DB, they probably found themselves with a lot more problems ... embed a table or query name. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2003 Closes upon update of sort order of table using Acce
    ... DB connection and it doesn't see the table in Access at all, ... You can solve and 2by using OLE DB to connect. ... And if they are parameter queries, ... The database table has over 19,000 records with 78 field names, so ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2003 Closes upon update of sort order of table using Access D
    ... Using the Find in Field function from the Mailmerge toolbar fails, certainly with this type of data source and connection type. ... You can solve and 2by using OLE DB to connect. ... And if they are parameter queries, how do you get Word to ask for the paramters? ... The database table has over 19,000 records with 78 field names, so ...
    (microsoft.public.word.mailmerge.fields)
  • Re: ERROR IN ORACLE CONNECTION
    ... The Oracle client can not find the database because ... 2/ if point 1 is ok check the connection in the odbc tool. ...
    (microsoft.public.dotnet.framework.adonet)