Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

User ODBC DSN failing to connect

Posted on 2002-05-22
8
Medium Priority
?
1,120 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
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

580 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