Re: [Axapta-Knowledge-Village] SQL transaction Log backup file

2008-08-26 Thread David Casas
Hi, Posibly you have a transaction in the end of the transaction log file, for this reason the full backup with transactional not reduce the used space. Do the following: backup log namebbdd with no_log With this, all the transactions finished was deleted (you have in the backup file), and pu

Re: [Axapta-Knowledge-Village] Urgent!!!Can we upgrade from AX 3.0 SP3 to AX 4.0 SP1?

2008-08-26 Thread David Casas
Hi, In the Implementation guide: Version support Upgrade to Microsoft Dynamics AX 4.0 must be from Microsoft Axapta 3.0 with or without one of the service packs. Because data dictionary changes, and as a consequence DEL_ prefixed tables and fields, are typical from one version to the next, you

Re: [Axapta-Knowledge-Village] Converting Axapta Oracle DB to MSSQL 2005 using MSSQL Migration Assistant?

2006-03-30 Thread David Casas
Hi Helmut, I doing some test with the SSMA. Today I talk with Microsoft people, and they tell me that this software only migrate more or less the 85% of the data correctly!!! :| With this tables I think the solution was export with the axapta tool to a dat / def files. I have one question... h

Re: [Axapta-Knowledge-Village] SQL Server timeout

2006-01-31 Thread David Casas
It´s a resolution name problem. Try with the ip, and if you can modify de hosts file adding the local name with the ip. Regards. David - Original Message - From: jetjockey.geo To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, January 31, 2006 10:27 AM Subject: [Axa

Re: [Axapta-Knowledge-Village] AOS Connection Problem.

2006-01-19 Thread David Casas
Hi, Try the following: 1. Ping to the name server, or the ip. 2. Try the 2-tier connection. 3. Test with ODBC and if it can connect to the machine. 4. Validate that AOS server is running 5. Disable the XP firewall. Regards. David Casas - Original Message - From: shanmug P

Re: [Axapta-Knowledge-Village] COM+ Test error

2005-11-18 Thread David Casas
Hi,   I think the problem is in the Axapta COM Conector, not works very fine.   Try the following:   -  Enter in Component Services and search the Navision COM Connector. -  Delete it -  Enter in Axapta and create a new user called com with administrative roles (the same as admin), and put

Re: [Axapta-Knowledge-Village] Help need on OLAP set up

2005-11-17 Thread David Casas
Hi,   I think the problem is other, is the Active X of MsOffice. To open pivot table, do you have installed office in the machine that you tried to see the olap cube.   Minimum requeriments:   -  Microsoft Excel 2000 -  Microsoft Query -  Microsoft Office Web Components   If you have this i

Re: [Axapta-Knowledge-Village] Migration from Oracle to SQL Server

2005-07-24 Thread David Casas
Hi,   I think that it´s the only way  It´s posible, if you export de tables with the export tool of oracle, you have the posibility of import with the dts tool of SQLServer, but I don´t know if this idea works...  it´s only an idea.   Regards.   David - Original Message -

Re: [Axapta-Knowledge-Village] Missing tables in SQL

2005-07-08 Thread David Casas
.   Regards.   David Casas - Original Message - From: axchi04 To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, July 07, 2005 2:55 PM Subject: [Axapta-Knowledge-Village] Missing tables in SQL Hi,SQL 2005 (made the conversion to 2000 for the database) has been

Re: [Axapta-Knowledge-Village] SQL7 to SQL2000 upgrade

2005-06-30 Thread David Casas
 Hi   I tested the upgrade of SQLServer 7.0 to SQLServer2000 and works well.   If I am in your situation, I do the following:   -  Install in the new machine SQLServer 7.0. -  Restore de database -  Upgrade to SQLServer 2000.   Another idea is with DTS of the tables, pass all of the datab

Re: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB

2005-04-26 Thread David Casas
Hi,   This problem it must be about the defragmentation of the tables.   The tables in SQLServer has the following structure:   Table Rows Reserved KB  Data Space KB   Index Space KB  Unused Space KB   

Re: [Axapta-Knowledge-Village] Retail functionality

2005-03-08 Thread David Casas
Hi,   I know a company that had developed a retail solution too:   Watermark   If anybody is interesed...  http://www.watermark-europe.com They have offices in a lot of countries.   Regards.   - Original Message - From: Edgard Vermeersch To: Axapta-Knowledge-Village@yahoo

Re: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-02-24 Thread David Casas
Hi Raul,   To see the next RECID to be used with the following sentence in the SQLAnalyzer:   select * from systemsequences where id = -2The field NextVal is the value for the next transaction ID Regards!!   David - Original Message - From: Raul Llorente Peña/OPENSOLUTI