Tim Williams wrote:
With cnConnection
.Provider = "MSDAORA"

That is the Microsoft version of the OLE DB provider. When I was using
Oracle a couple of years ago, Oracle's own version was perferred. For
this, among many other connestion string samples, see:

http://www.able-consulting.com/MDAC/...leFromOrac le

Jamie.

--