Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

User ODBC DSN failing to connect

Posted on 2002-05-22
8
Medium Priority
?
1,117 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 2

Expert Comment

by:prokni
ID: 7030089
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
ID: 7030377
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
ID: 7030427
What odbc driver are you using? Oracle odbc driver or microsoft odbc driver for oracle?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:ZANTAR
ID: 7030459
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
 
LVL 2

Expert Comment

by:prokni
ID: 7030485
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
ID: 7030538
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
ID: 7265810

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
ID: 7296532
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

610 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