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?