Highlighted
Absent Member.
Absent Member.
97 views

Data Wizard problems


Hi
I would like to use the data wizard's Microsoft query to modify my UserInfo.dat file. Currently it throws a ORA12154 error.
I first go through creating a data source.
I chose Microsoft ODBC driver since the DB i have is oracle.
Here is the connection string I use under the "Server" text field.
DSN=Satish1;UID=es_eeg;PWD=xxx;SERVER=10.252.219.238

This throws a ORA-12154 error.
Below is my sqlnet.ora file:

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)


Below is my tnsnames.ora file:

10.252.219.238 =
(Description =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.252.219.238)(PORT = 1521))
)
(CONNECT_DATA =
(SID = udbnav)
)
)



0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

Any one, any idea?
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.