ORACLE Connectivity Problem via ADO

Hi All

I have a client who utilises Oracle TNS name's as a connector to their
Oracle databases.  ODBC has been setup connecting to the TNS server names.
And ODBC DSN might look like this if I were to use a reporting tool:
DSN="ODBC;DSN=DSNNAME;UID=UIDNAME;PWD=PWDText"

The problem is ADO doesn't utilise this connection string, it uses an ODBC
Provider, which doesn't seem to recognise the ODBC setting.

Regards
James