User ODBC DSN failing to connect

I have a WindowsNT sp 6a computer and have created a System ODBC DSN as a domain administrator account using the Microsoft ODBC driver for Oracle.

While logged in as the domain administrator account, I can use the DSN to connect to the Oracle database no problem.

When I connect as a domain user account and use that DSN, it fails to connect to the Oracle database. Also, the Microsoft OLEDB driver for Oracle fails under the domain user account as well.

Things I have tried:
- Installed MDAC 2.5 SP2
- Dropping all DSNs and creating the only one under the domain user account as a system / user (tried both) DSN.
- Created a DSN using the Oracle ODBC driver which works under the domain user account (but I need to use the Microsoft one).

Here is the error in the trace file (only part is shown) from when I created a System DSN under the user account and it failed to connect:

WencoDB         114-fc     ENTER SQLSetConnectAttrW
          SQLHDBC             01971580
          SQLINTEGER                 103 <SQL_ATTR_LOGIN_TIMEOUT>
          SQLPOINTER          0x0000000F
          SQLINTEGER                  -6

WencoDB         114-fc     EXIT  SQLSetConnectAttrW  with return code 0 (SQL_SUCCESS)
          SQLHDBC             01971580
          SQLINTEGER                 103 <SQL_ATTR_LOGIN_TIMEOUT>
          SQLPOINTER          0x0000000F (BADMEM)
          SQLINTEGER                  -6

WencoDB         114-fc     ENTER SQLDriverConnectW
          HDBC                01971580
          HWND                00000000
          WCHAR *             0x1F7D8B70 [      -3] "******\ 0"
          SWORD                       -3
          WCHAR *             0x1F7D8B70
          SWORD                        8
          SWORD *             0x00000000
          UWORD                        0 <SQL_DRIVER_NOPROMPT>

WencoDB         114-fc     EXIT  SQLDriverConnectW  with return code -1 (SQL_ERROR)
          HDBC                01971580
          HWND                00000000
          WCHAR *             0x1F7D8B70 [      -3] "******\ 0"
          SWORD                       -3
          WCHAR *             0x1F7D8B70
          SWORD                        8
          SWORD *             0x00000000
          UWORD                        0 <SQL_DRIVER_NOPROMPT>

          DIAG [NA000] [Microsoft][ODBC driver for Oracle][Oracle] (0)

          DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

WencoDB         114-fc     ENTER SQLGetDiagRecW
          SQLSMALLINT                  2
          SQLHANDLE           01971580
          SQLSMALLINT                  1
          SQLWCHAR *          0x0012E8DC (NYI)
           SQLINTEGER *        0x0012E904
          SQLWCHAR *          0x0012E4DC (NYI)
           SQLSMALLINT                512
          SQLSMALLINT *       0x0012E900

WencoDB         114-fc     EXIT  SQLGetDiagRecW  with return code 0 (SQL_SUCCESS)
          SQLSMALLINT                  2
          SQLHANDLE           01971580
          SQLSMALLINT                  1
          SQLWCHAR *          0x0012E8DC (NYI)
           SQLINTEGER *        0x0012E904 (0)
          SQLWCHAR *          0x0012E4DC (NYI)
           SQLSMALLINT                512
          SQLSMALLINT *       0x0012E900 (43)


LVL 1
ZANTARAsked:
Who is Participating?
 
NetminderConnect With a Mentor Commented:
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0
 
prokniCommented:
What do you mean by login exactly? Are you login in to ODBC test tools? How are u trying to connect to oracle?
0
 
ZANTARAuthor Commented:
The user can log into the Windows NT machine. However, if they try to use any application which connects to the Oracle database VIA an ODBC DSN, it will not connect and give an ODBC error.

For testing, I have tried creating a System DSN using the Microsoft ODBC driver for Oracle. Then I start up Microsoft Access and try to make a linked table via that ODBC driver. MS Access does not connect to the database and the driver fails with the errors above... as seen in the ODBC trace file that I made.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
prokniCommented:
What odbc driver are you using? Oracle odbc driver or microsoft odbc driver for oracle?
0
 
ZANTARAuthor Commented:
I was able to get the Oracle ODBC driver to work successfully under both the domain admin Windows NT user account and the domain user Windows NT user account. However, the Microsoft ODBC driver for Oracle and Microsoft OLEDB driver for Oracle only work if the domain admin Windows NT user account is logged in.

On a side note, this is only happening on 4 new computers. There are 12 other Windows NT machines which the user can log on as a Domain user and connect to the database no problem with the Microsoft drivers.
0
 
prokniCommented:
I have the same problem with Microsft ODBC for oracle, I remember as soon as I upgrade my MDAC, it stopped working and I had to redo one of my server and make all version exactly same as the other one was working.
The problem with Oracle ODBC driver is, if you want to deal BLOB field. it some times cause a problem. Microsoft driver is the best if it works.
Let me clear your quetsion again.
You want to get your ODBCX work with Microsoft odbc driver for oracle unser user domain. Correct?
If Oracle ODBC works what is the point for that?
0
 
ZANTARAuthor Commented:
Half of our software uses ODBC to connect to the Oracle database (which could use the Oracle driver, correct). However, the other half uses the Microsoft OLEDB driver for Oracle which doesn't work as well when logged in as the Domain user account.

I assume the problem with the Microsoft ODBC driver and Microsoft OLEDB driver for Oracle is related.
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.