PC Review


Reply
Thread Tools Rate Thread

The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

 
 
sudhaoncyberworld@gmail.com
Guest
Posts: n/a
 
      16th Jul 2007
Dear Techies,

I do have small issue on connecting oracle server [odbc connection]
from .net [MOSS 2007 webpart]

This is the code snippet


public string strConString = "Driver={Microsoft ODBC for
Oracle};Server=myserver;Uid=system;Pwd=mypwd;";


using (OdbcConnection odbcCon = new OdbcConnection(strConString))
{
odbcCon.Open();
strOrclCmd = " select * from customers";
OdbcDataAdapter odbcDA = new
OdbcDataAdapter(strOrclCmd, odbcCon);
DataSet ds = new DataSet();
odbcDA.Fill(ds);
return ds;
}

The above which is perfectly working fine with a console application.

The same code I have used in
System.Web.UI.WebControls.WebParts.WebPart which throws the below
exception....

System.Data.Odbc.OdbcException: ERROR [NA000] [Microsoft][ODBC driver
for Oracle][Oracle]ORA-12638: Credential retrieval failed
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't
support the version of ODBC behavior that the application requested
(see SQLSetEnvAttr).
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection, OdbcConnectionString constr, OdbcEnvironmentHandle
environmentHandle)
at
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at DMPDBLayer.Customer.GetCustomers()

When I deploy the wep part in the sharepoint site through GAC, it
throws the above error. Can anyone figure out which is going wrong?

Working Environment
Windows server 2003
VS 2005
Framework 3.0 & 2.0
MOSS 2007

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where to get stand alone Dot Net Framework version 1.1, version 2.0,version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? pg Windows XP General 11 9th Feb 2008 02:55 AM
Where to get stand alone Dot Net Framework version 1.1, version 2.0,version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? pg Microsoft Dot NET 11 9th Feb 2008 02:55 AM
Re: Where to get stand alone Dot Net Framework version 1.1, version 2.0, version 3.0, version 3.5, version 2.0 SP1, version 3.0 SP1 ? V Green Windows XP Help 0 5th Feb 2008 03:45 AM
The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). sudhaoncyberworld@gmail.com Microsoft Dot NET 0 16th Jul 2007 12:32 PM
The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). sudhaoncyberworld@gmail.com Microsoft Dot NET 0 16th Jul 2007 12:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:24 AM.