I just need to use ADO to connect to an Oracle database, on various client workstations other than my own dev machine. I'd like to do it with the minimum of hassle and the minimum of installation.
Do I absolutely have to install Oracle client at 175 MB just to do some simple ODBC? I've searched the web and tried various things and have been unsuccessful so far to find out if that's what I have to do.
I sure hope there's something simpler and smaller I can do. "Here's a 60k Excel file and by the way 175 MB of payload just to make it connect to the database."
I'm considering setting up a linked server to the Oracle database on one of our prod MSSQL boxes and using a SQL Server connection from ADO through that just so I don't have to install a ton of junk... but I'd still like to know how to do it.
Do I absolutely have to install Oracle client at 175 MB just to do some simple ODBC? I've searched the web and tried various things and have been unsuccessful so far to find out if that's what I have to do.
I sure hope there's something simpler and smaller I can do. "Here's a 60k Excel file and by the way 175 MB of payload just to make it connect to the database."
I'm considering setting up a linked server to the Oracle database on one of our prod MSSQL boxes and using a SQL Server connection from ADO through that just so I don't have to install a ton of junk... but I'd still like to know how to do it.
