Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Error-ODBC connection between ASP.NET 1.1 and DBISAM 3.24 |
Sun, Jul 30 2006 7:52 AM | Permanent Link |
Suman Sundar | Hi,
Is anyone there to solve the issue mentioned below? I am unable to establish a connection between ASP.NET 1.1 (IIS) and DBISAM 3.24. I installed DBISAM ODBC 3.24 driver and provided a DSN name. I could establish a connection through Windows Form Application without any error, but I received ‘ODBC Driver Manager’ exception in Web Application. The exception from web application is mentioned below. Web Pages (aspx) are in IIS 6.0 and table files are in different server. The DSN was created in my local system. Whether I have to provide access permission to IIS and DBISAM Server to communicate with DSN? Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified] System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35 System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131 System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.Odbc.OdbcConnection.Open() +37 UI.MyIncident.Page_Load(Object sender, EventArgs e) in \\dxbafpww16\sentinelcs\dev1\UI\Forms\MyIncident.aspx.vb:28 System.EventHandler.Invoke(Object sender, EventArgs e) +0 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 ________________________________________ Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 Suman Sundar |
Sun, Jul 30 2006 1:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Suman,
<< I am unable to establish a connection between ASP.NET 1.1 (IIS) and DBISAM 3.24. I installed DBISAM ODBC 3.24 driver and provided a DSN name. I could establish a connection through Windows Form Application without any error, but I received 'ODBC Driver Manager' exception in Web Application. The exception from web application is mentioned below. Web Pages (aspx) are in IIS 6.0 and table files are in different server. The DSN was created in my local system. Whether I have to provide access permission to IIS and DBISAM Server to communicate with DSN? Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified >> Make sure that the DSN that you've defined is accessible from the user account that the ASP application is running under with IIS. If you define the DSN as a system DSN, it should be accessible and visible to the IIS ASP applications. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Jul 31 2006 1:42 AM | Permanent Link |
suman sundar | Hi Tim,
My ASP.NET files reside in a remote server and tables in DBISAM also resides in different server. I created DSN in my local system. I can establish the connection through WINForm which is created in my local system. Since ASP.NET resides in a remote server, I created a FILEDSN in my local system which has connection string of DBISAM. I mentioned the IP address of FILEDSN in the connection string. But I received an error. Please kindly solve this issue. Execution Error ERROR [HY000] [Microsoft][ODBC Driver Manager] General error: Unable to create file buffer 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 UI.MyIncident.Page_Load(Object sender, EventArgs e) in \\dxbafpww16\sentinelcs\dev1\UI\Forms\MyIncident.aspx.vb:line 28 at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 0.631368791284926 0.630267 "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: suman sundar -------------------------------------- Suman, << I am unable to establish a connection between ASP.NET 1.1 (IIS) and DBISAM 3.24. I installed DBISAM ODBC 3.24 driver and provided a DSN name. I could establish a connection through Windows Form Application without any error, but I received 'ODBC Driver Manager' exception in Web Application. The exception from web application is mentioned below. Web Pages (aspx) are in IIS 6.0 and table files are in different server. The DSN was created in my local system. Whether I have to provide access permission to IIS and DBISAM Server to communicate with DSN? Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified >> Make sure that the DSN that you've defined is accessible from the user account that the ASP application is running under with IIS. If you define the DSN as a system DSN, it should be accessible and visible to the IIS ASP applications. -- Tim Young Elevate Software www.elevatesoft.com Suman Sundar <sundararajan.suman@emirates.com> wrote: Hi, Is anyone there to solve the issue mentioned below? I am unable to establish a connection between ASP.NET 1.1 (IIS) and DBISAM 3.24. I installed DBISAM ODBC 3.24 driver and provided a DSN name. I could establish a connection through Windows Form Application without any error, but I received ‘ODBC Driver Manager’ exception in Web Application. The exception from web application is mentioned below. Web Pages (aspx) are in IIS 6.0 and table files are in different server. The DSN was created in my local system. Whether I have to provide access permission to IIS and DBISAM Server to communicate with DSN? Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified] System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35 System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131 System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.Odbc.OdbcConnection.Open() +37 UI.MyIncident.Page_Load(Object sender, EventArgs e) in \\dxbafpww16\sentinelcs\dev1\UI\Forms\MyIncident.aspx.vb:28 System.EventHandler.Invoke(Object sender, EventArgs e) +0 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 ________________________________________ Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 Suman Sundar |
Mon, Jul 31 2006 9:08 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Suman,
<< My ASP.NET files reside in a remote server and tables in DBISAM also resides in different server. I created DSN in my local system. I can establish the connection through WINForm which is created in my local system. Since ASP.NET resides in a remote server, I created a FILEDSN in my local system which has connection string of DBISAM. I mentioned the IP address of FILEDSN in the connection string. But I received an error. Please kindly solve this issue. >> You need to re-examine what you're trying to do. If you're running the ASP on a remote server, then the ODBC driver, and subsequently the DSN definition (either in the registry or in a file DSN) must be present on that remote server. There's no way around this. If you're trying to do it any other way, it simply will not work. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |