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

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 =3D "Driver=3D{Microsoft ODBC for
Oracle};Server=3Dmyserver;Uid=3Dsystem;Pwd=3Dmypwd;";


using (OdbcConnection odbcCon =3D new OdbcConnection(strConString))
{
odbcCon.Open();
strOrclCmd =3D " select * from customers";
OdbcDataAdapter odbcDA =3D new
OdbcDataAdapter(strOrclCmd, odbcCon);
DataSet ds =3D 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(DbCo=
=AD
nnection
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,
accessing site
throws the above error. Can anyone figure out which/where is going
wrong?


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


Also posted in programming & development forum

Why repeat the entire message here and in doing so start a new thread ?

Why repeat the entire message here and in doing so start a new thread ?

Just adding the text ("> Also posted in programming & development
forum") isn't a reason for having a second thread here.

All you needed to do was (if you felt it was necessary) was to post that
quoted text as a reply to my comment *in the orignal thread* here.

Mike Walsh

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

ions
DbCo=AD

Thanks for your info, next time onwards i do follow it