Issues connecting to Progress database via ODBC in published Web Application RRS feed

  • Question

  • I am having issue trying to get my Web Application published and running correctly on our IIS server.

    When I test from within Visual Studio 2015 with the same ODBC driver setups, everything works fine.  It is only once I try to publish the Web Application and access it off the IIS webserver in a browser that I am getting an issues.

    I am using Visual Studio 2015 v14.0.25431.01 Update 3

    The IIS server is a 64-bit Windows 2016 server

    The ODBC driver is a Progress OpenEdge 11.6 driver - 32 Bit

    The ODBC connection is setup using the 32-b it ODBC Manager found in c:\windows\sysWOW64\odbcad32

    I came across many forums that say to make sure that the ODBC driver is setup correctly, and using the correct ODBC manager, which it is.

    I also came across some posts that reference compiling the Web Application and specifying in the Configuration manager to use x86 instead of Any CPU.  x86 is not an option when I go into the configuration manager.

    I am at a loss as to how to resolve this error so that I can access the new Web Applications from the IIS server.

    The error I get is...

    Server Error in '/' Application.

    ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

    Exception Details: System.Data.Odbc.OdbcException: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

    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 [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application]
    System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +1358681
    System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) +73
    System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +78
    System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) +57
    System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +1160
    System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +314
    System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +26
    System.Data.Odbc.OdbcConnection.Open() +52
    System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +173
    System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +453
    System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +141
    djst1.FPSTableAdapters.FpwVSTHdr_ProgIdTableAdapter.GetData(String ProgId) +243
    djst1.DataLayer.LoadTemplates(String TemplateName) +71
    djst1.LogicLayer.InitalizePage() +70
    djst1.CST.Page_Load(Object sender, EventArgs e) +469
    System.Web.UI.Control.OnLoad(EventArgs e) +103
    System.Web.UI.Control.LoadRecursive() +68
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3811

    Any suggestions, advice, recommendations?
    • Moved by 宝宝徐 Monday, September 18, 2017 2:38 AM
    Wednesday, September 13, 2017 7:57 PM

All replies

  • Hi shadderk,

    Thank you for posting in MSDN forum.

    This forum is discussing about .Net Framework setup and servicing, as your question is much related to publishing application on IIS, I suggest you post in https://forums.iis.net/1041.aspx/1?General for a much professional help.

    Thank you for your understanding.

    Best Regards,

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, September 14, 2017 4:14 AM