I have both an 8 and 9i client installed on my machine. 8.0.5 client fails to connect to our new instances, and the 9i client connects perfectly fine. So I use the 9i client to connect.

Problem is, I am writing a client/server application using ADO to connect client to Oracle. The connection keeps failing with the same error message I get from the 8 client attemps. Which leads me to believe that the native and odbc connections are using the 8 client instead of 9i. I have my oracle home set to the 9i version. But that doesn't make a difference. What else do I have to change to cause the ADO connection to use the 9i client version????