Oracle-GridView Databind fails with error OCIEnvNlsCreate failed

[sreejith.ram]

I did google & search in this group , but couldnt find any thing
related to this.

This is my first attempt to connect GridView to a Oracle database via
SqlDataSource. I am receving error message "OCIEnvNlsCreat e failed
with return code -1 but error message text was not available"

Any one seen this or anything similar? Thank you in advance for all
tips,suggestion s,advices & helps

Stack Trace Below
*************** *************** *************** ***********
System.Exceptio n was unhandled by user code
Message="OCIEnv NlsCreate failed with return code -1 but error message
text was not available."
Source="System. Data.OracleClie nt"
StackTrace:
at System.Data.Ora cleClient.OciHa ndle..ctor(OciH andle
parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
at System.Data.Ora cleClient.OciNl sEnvironmentHan dle..ctor(MODE
environmentMode )
at System.Data.Ora cleClient.OCI.D etermineClientV ersion()
at
System.Data.Ora cleClient.Oracl eInternalConnec tion.OpenOnLoca lTransaction(St ring
userName, String password, String serverName, Boolean
integratedSecur ity, Boolean unicode, Boolean omitOracleConne ctionName)
at
System.Data.Ora cleClient.Oracl eInternalConnec tion..ctor(Orac leConnectionStr ing
connectionOptio ns)
at
System.Data.Ora cleClient.Oracl eConnectionFact ory.CreateConne ction(DbConnect ionOptions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool,
DbConnection owningObject)
at
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options)
at
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)
at System.Data.Ora cleClient.Oracl eConnection.Ope n()
at System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet
dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String
srcTable)
at
System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteSelect(Da taSourceSelectA rguments
arguments)
at System.Web.UI.D ataSourceView.S elect(DataSourc eSelectArgument s
arguments, DataSourceViewS electCallback callback)
at System.Web.UI.W ebControls.Data BoundControl.Pe rformSelect()
at System.Web.UI.W ebControls.Base DataBoundContro l.DataBind()
at System.Web.UI.W ebControls.Grid View.DataBind()
at ReportsEMEA_Rep airReport.btnGe tReport_Click(O bject sender,
EventArgs e) in
c:\Inetpub\wwwr oot\WEB\Reports \RepairReport.a spx.cs:line 55
at System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)
at System.Web.UI.W ebControls.Butt on.RaisePostBac kEvent(String
eventArgument)
at
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument)
at System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
at System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection
postData)
at System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
* The connection & query works fine via SqlPlus
* ASP.NET , IWAM_ & IUSER_ accounts have FULL (for testing) permission
to Oracle\bin folder
* I did restart webserver , reboot machine(!!!) .. but it didnt help.

Thanks again for the helps

Sreejith