Hi Friends,

Our (Visual Basic) appds developer is using OLEDB/ODBC to connect
to our Oracle 8i database which resides on RS6000 AIX . He uses the
Win2K server as the middle tier for his MTS. On the middle tier server
we have also a 10g DB and 10g client installed on different home.
Thay have their respective net manager and tnsnames.ora.
My question is how can i direct hist VB programs ODBC to use the
connect id of the tnsnames.ora of the 10gDB and not the tnsnames.ora
10g client.

Thanks a lot