?
Solved

User ODBC DSN failing to connect

Posted on 2002-05-22
8
Medium Priority
?
1,108 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

752 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