Solved

User ODBC DSN failing to connect

Posted on 2002-05-22
8
1,049 Views
Last Modified: 2007-11-27
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)


0
Comment
Question by:ZANTAR
8 Comments
 
LVL 2

Expert Comment

by:prokni
Comment Utility
What do you mean by login exactly? Are you login in to ODBC test tools? How are u trying to connect to oracle?
0
 
LVL 1

Author Comment

by:ZANTAR
Comment Utility
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
 
LVL 2

Expert Comment

by:prokni
Comment Utility
What odbc driver are you using? Oracle odbc driver or microsoft odbc driver for oracle?
0
 
LVL 1

Author Comment

by:ZANTAR
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 2

Expert Comment

by:prokni
Comment Utility
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
 
LVL 1

Author Comment

by:ZANTAR
Comment Utility
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
 
LVL 54

Expert Comment

by:nico5038
Comment Utility

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
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
Comment Utility
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now