I have an access (mdb) database within a linked table connected to a table from Navision Financials 2.01 database server using a 32-bit ODBC driver. I develop a Web Service to publish data from that table. When I publish this Web Service in a Windows 2003
Server x64 (IIS) and try the Web Service an error is produced:
System.Data.OleDb.OleDbException: ODBC--connection to 'ProyectoCongelados' failed.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at WSProyectoCongelados.NavisionDSTableAdapters.Lín__ventaTableAdapter.Fill(Lín__ventaDataTable dataTable, DateTime Fecha_registro) in C:\Documents and Settings\daparicio\Mis documentos\Visual Studio 2008\Projects\WSProyectoCongelados\WSProyectoCongelados\NavisionDS.Designer.cs:line
1020
at WSProyectoCongelados.Navision.DameLineasPedidosHoy() in C:\Documents and Settings\daparicio\Mis documentos\Visual Studio 2008\Projects\WSProyectoCongelados\WSProyectoCongelados\WSNavision.asmx.cs:line 26
The error is not produced when the table is imported to acces database, so I think OLEDB driver cannot acces 32 bit ODBC driver linked to a access database....
qnito
2 Posts
Access 32-bits ODBC driver from 64-bit Web Service
Apr 15, 2008 06:35 PM|LINK
I have an access (mdb) database within a linked table connected to a table from Navision Financials 2.01 database server using a 32-bit ODBC driver. I develop a Web Service to publish data from that table. When I publish this Web Service in a Windows 2003 Server x64 (IIS) and try the Web Service an error is produced:
System.Data.OleDb.OleDbException: ODBC--connection to 'ProyectoCongelados' failed.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at WSProyectoCongelados.NavisionDSTableAdapters.Lín__ventaTableAdapter.Fill(Lín__ventaDataTable dataTable, DateTime Fecha_registro) in C:\Documents and Settings\daparicio\Mis documentos\Visual Studio 2008\Projects\WSProyectoCongelados\WSProyectoCongelados\NavisionDS.Designer.cs:line 1020
at WSProyectoCongelados.Navision.DameLineasPedidosHoy() in C:\Documents and Settings\daparicio\Mis documentos\Visual Studio 2008\Projects\WSProyectoCongelados\WSProyectoCongelados\WSNavision.asmx.cs:line 26
The error is not produced when the table is imported to acces database, so I think OLEDB driver cannot acces 32 bit ODBC driver linked to a access database....
anybody can help me?
ODBC 32 bits 64 bits IIS error
thomad
552 Posts
Re: Access 32-bits ODBC driver from 64-bit Web Service
Apr 16, 2008 09:33 PM|LINK
Can you search for Enable32BitAppOnWin64. That is the property you want to set to run IIS 6.0 worker processes in 32-Bit mode.
Hope this helps
Group Program Manager
Internet Information Services
Microsoft Corp.
qnito
2 Posts
Re: Access 32-bits ODBC driver from 64-bit Web Service
Apr 17, 2008 06:53 AM|LINK
Thanks for the answer, but this property is enabled.