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

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

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

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