I am trying to connect to oracle 11g database via instant client 11.2 odbc driver on windows xp.
When I test the connection in the odbc data source administrator, I get the "connection successful" message.
When I try connect via Crystal Developer or via other software that utilize odbc, I get error 126. Teradata SQL assistant gave me an error 127.
I have reviewed prior articles/threads on this subject and have tried copying the drivers mentioned in the older posts.
I believe I have the path and tns_admin environment variables set properly.