Today, because yesterday I installed the avatar database using the above data derived from ORACLE data to SQL SERVER, the user name password hint user name password mistake, but
It is impossible to mistake, because I can connect PLSQL,
So using navicat connection, the results also hint user name password mistake, so I looked at the navicat environment setup (option), found that the inside of the oci. DLL is pointing to the avatar database directory oci. DLL (this is too old to connect the oracle 19 C 64 - bit version), so I should for my tns_admin (C: \ instantclient_19_6_64 \ oci DLL), can be connected,
So I think the.net framework data provider for oracle connection, certainly related to this, so I just uninstall the avatar database, hence can connect,
Now I want to ask is, if I install avatar database, then how can I put the. Net framework data provider for oracle driver is connected to the C: \ instantclient_19_6_64 \ oci DLL this
CodePudding user response:
Solved, as long as the C: \ instantclient_19_6_64 directory on avatar just in front of the database directory (system variables, PATH)