Question regarding accessing SQL Server and Oracle from VB via ADO.
Do I have to hardwire the connection string (.open = "provider=oracle/sqlserver blah blah) based on the database I am connecting to?
Is there any GOOD ODBC Driver that talks both to SQL server and Oracle?

Reason is, I may not know which database I am talking to.
How do I go about doing it via ADO?

Thanks much.