Oracle/XE on Windows 7-64 bits cannot be accessed with VB 6 ADODB app
The scenario is:
Oracle/XE 10.2, Windows 7 64 bits, an VB6 application using ADODB 2.8, and ORAOledb 10...
Connection string for the adodb.connection is: "Provider=OraOLEDB.Oracle;Data Source=theXEcomputername;User ID=myuser;Password=mypwd"
Problem is:
When running the application on another network computer, the connection with the XE based computer is ok and app runs nice and easy.
Nevertheless, if I start the VB6 app on the Win7/64 machine (which has XE installed), a TNS-12154 error occurs and the connection fails.
Also, tryng to access another XE database machine, using the Win7/64 as a client, did not succeed.
Is there a problem on using Win/64 computers to connect XE database?
I'll appreciate if you can suggest a solution.
Thanks in advance.
jdn