Hi,
I am currently trying to link a ODBC database from a server into my MS Visual Studio 2010 asp.net web application. I have the ODBC connection set up on my workstation and all data on the SQL Server. My problem is this: Whenever I access the page it comes up fine, but when I enter a search into the text box and click "submit" I get this error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Here is the stack trace:
[OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
System.Data.Odb c.OdbcConnectio n.HandleError(O dbcHandle hrHandle, RetCode retcode) +40
System.Data.Odb c.OdbcConnectio nHandle..ctor(O dbcConnection connection, OdbcConnectionS tring constr, OdbcEnvironment Handle environmentHand le) +169
System.Data.Odb c.OdbcConnectio nFactory.Create Connection(DbCo nnectionOptions options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection owningObject) +127
System.Data.Pro viderBase.DbCon nectionFactory. CreateNonPooled Connection(DbCo nnection owningConnectio n, DbConnectionPoo lGroup poolGroup) +43
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection owningConnectio n) +6296143
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection outerConnection , DbConnectionFac tory connectionFacto ry) +6296606
System.Data.Odb c.OdbcConnectio n.Open() +48
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +292
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +420
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable) +312
System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteSelect(Da taSourceSelectA rguments arguments) +3369511
System.Web.UI.W ebControls.Data Grid.CreateCont rolHierarchy(Bo olean useDataSource) +174
System.Web.UI.W ebControls.Base DataList.OnData Binding(EventAr gs e) +178
System.Web.UI.W ebControls.Base DataList.Ensure DataBound() +90
System.Web.UI.C ontrol.EnsureCh ildControls() +182
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +60
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +222
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +222
System.Web.UI.P age.ProcessRequ estMain(Boolean includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +4185
Any thoughts or suggestions would be most appreciated.
Thank you
I am currently trying to link a ODBC database from a server into my MS Visual Studio 2010 asp.net web application. I have the ODBC connection set up on my workstation and all data on the SQL Server. My problem is this: Whenever I access the page it comes up fine, but when I enter a search into the text box and click "submit" I get this error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Here is the stack trace:
[OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
System.Data.Odb c.OdbcConnectio n.HandleError(O dbcHandle hrHandle, RetCode retcode) +40
System.Data.Odb c.OdbcConnectio nHandle..ctor(O dbcConnection connection, OdbcConnectionS tring constr, OdbcEnvironment Handle environmentHand le) +169
System.Data.Odb c.OdbcConnectio nFactory.Create Connection(DbCo nnectionOptions options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection owningObject) +127
System.Data.Pro viderBase.DbCon nectionFactory. CreateNonPooled Connection(DbCo nnection owningConnectio n, DbConnectionPoo lGroup poolGroup) +43
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection owningConnectio n) +6296143
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection outerConnection , DbConnectionFac tory connectionFacto ry) +6296606
System.Data.Odb c.OdbcConnectio n.Open() +48
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +292
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +420
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable) +312
System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteSelect(Da taSourceSelectA rguments arguments) +3369511
System.Web.UI.W ebControls.Data Grid.CreateCont rolHierarchy(Bo olean useDataSource) +174
System.Web.UI.W ebControls.Base DataList.OnData Binding(EventAr gs e) +178
System.Web.UI.W ebControls.Base DataList.Ensure DataBound() +90
System.Web.UI.C ontrol.EnsureCh ildControls() +182
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +60
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +222
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +222
System.Web.UI.P age.ProcessRequ estMain(Boolean includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +4185
Any thoughts or suggestions would be most appreciated.
Thank you