[development-axapta] Axapta 3.0 Installation - ODBC (To use or not to use)
Can anybody please explain the advantages/disadvantages of using an Axapta ODBC data source when installing Axapta 3.0 (both 2-tier client AOS server). I know that a data source is no longer required in version 3 but are there any good reasons for still using it. I've read quite a few forums and nobody seems to have a definitive view on this. Kind Regards, Pieter Smith Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] Axapta 3.0 Installation - ODBC (To use or not to use)
I can only speak for MSSQL: If you don't establish a system dns, Axapta will do for you, so it just does some work for you, but it's the same if you use the datasource-field in your axconfig or not. There's no performance advantage. For oracle, there are big differences, but I don't know them for sure. HTH Herbert | -Ursprüngliche Nachricht- | Von: sflyz [mailto:[EMAIL PROTECTED] | Gesendet: Dienstag, 08. März 2005 11:01 | An: development-axapta@yahoogroups.com | Betreff: [development-axapta] Axapta 3.0 Installation - ODBC | (To use or not to use) | | | | | Can anybody please explain the advantages/disadvantages of | using an Axapta ODBC data source when installing Axapta 3.0 | (both 2-tier client AOS server). I know that a data source | is no longer required in version 3 but are there any good | reasons for still using it. | | I've read quite a few forums and nobody seems to have a | definitive view on this. | | Kind Regards, | | Pieter Smith | | | | | | | | | | Yahoo! Groups Links | | | | | | | Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Axapta 3.0 Installation - ODBC (To use or not to use)
The difference for Oracle is that it doesn't use ODBC at all, but speaks directly to the OCI (Oracle call interface) thus saving a few communication layers. The hope is that future releases will communicate through ADO for SQLServer which is also much closer to the kernel than ODBC Pieter _ From: Leberbauer, Herbert - News [mailto:[EMAIL PROTECTED] Sent: 8. mars 2005 11:36 To: development-axapta@yahoogroups.com Subject: AW: [development-axapta] Axapta 3.0 Installation - ODBC (To use or not to use) I can only speak for MSSQL: If you don't establish a system dns, Axapta will do for you, so it just does some work for you, but it's the same if you use the datasource-field in your axconfig or not. There's no performance advantage. For oracle, there are big differences, but I don't know them for sure. HTH Herbert | -Ursprüngliche Nachricht- | Von: sflyz [mailto:[EMAIL PROTECTED] | Gesendet: Dienstag, 08. März 2005 11:01 | An: development-axapta@yahoogroups.com | Betreff: [development-axapta] Axapta 3.0 Installation - ODBC | (To use or not to use) | | | | | Can anybody please explain the advantages/disadvantages of | using an Axapta ODBC data source when installing Axapta 3.0 | (both 2-tier client AOS server). I know that a data source | is no longer required in version 3 but are there any good | reasons for still using it. | | I've read quite a few forums and nobody seems to have a | definitive view on this. | | Kind Regards, | | Pieter Smith | | | | | | | | | | Yahoo! Groups Links | | | | | | | Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129qgua99/M=298184.6018725.7038619.3001176/D=groups/S=1705006764:HM/EXP=1110365881/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075 http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=101203208 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Problem with Axapta 2.5 SP4 on Oracle
Hello, I am quiet curious what kind of reporting tool your company is using ? We have also Axapta but we have each year about 10 mio records in the ledger trans table. We are still looking for the right solution. Kind regards, Willem --- Rudi Hansen [EMAIL PROTECTED] wrote: I have a problem with an Axapta Application, which I have to get running against an Oracle database. I have one Axapta 2.5 SP4 running against my Linux Oracle 9.2 server, without problems. So I have imported a customer's data into a new user and created my application. Now when I start Axapta nothing happens, Axapta starts, runs a few seconds and disappears. The only error I can find is this in the event viewer Faulting application ax32.exe, version 0.0.0.0, faulting module sqora32.dll, version 9.2.0.0, fault address 0x000459c0. Any one has any ideas? __ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/ Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [development-axapta] Delete enum
I would use TreeNode.AOTdelete(). Check in the dev help for more info on TreeNode class. Regards, Steeve... -Message d'origine- De : Daniel Redelinghuys [mailto:[EMAIL PROTECTED] Envoyé : 8 mars 2005 08:02 À : development-axapta@yahoogroups.com Objet : [development-axapta] Delete enum Hi All, Can anyone please help with code to delete a enum value (the hole enum) from the AOT (hole environment). I need to do this in a job after all instances of that value has been move from the tables. Thank you, -- Daniel J. Redelinghuys Axapta Developer UTi-Sun Couriers Division Tel: +27 12 673 2324 Fax: +27 12 673 2344 - [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Printing Sales invoice
Hi Multiprinting of Sales invoice is sorting by SalesId. How can I modify this sorting so all Invoices will come out sortied by another field in SalesTable instead? Thanks Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Printing Sales invoice
I think its in the Form' sort (AR/Setup) -Original Message- From: anettemalmberg [mailto:[EMAIL PROTECTED] Sent: 07 March 2005 23:00 To: development-axapta@yahoogroups.com Subject: [development-axapta] Printing Sales invoice Hi Multiprinting of Sales invoice is sorting by SalesId. How can I modify this sorting so all Invoices will come out sortied by another field in SalesTable instead? Thanks Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129h7hrs1/M=298184.6018725.7038619.3001176/D=gr oups/S=1705006764:HM/EXP=1110383476/A=2593423/R=0/SIG=11el9gslf/*http://www. netflix.com/Default?mqso=60190075 click here http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S= :HM/A=2593423/rand=711762574 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] direct sql problem again
Hello,
I am developing a report which should be written by using direct sql
statements. I recognized a problem about direct sql if anybody helps
me i will be very pleased. The problem is i could not write while
loops one within the other.For example;
Connection Con = new Connection();
Statement Stmt = Con.createStatement();
ResultSet R,R1;
sql ='SELECT ACCOUNTNUM,ACCOUNTNAME,ACCOUNTPLTYPE,RECID FROM
LEDGERTABLE WHERE ACCOUNTNUM = \'699\'ORDER BY ACCOUNTNUM';
R=Stmt.executeQuery(sql);
while (R.next())
{
acno1=R.getString(1);
i = R.getInt(3);
k= R.getString(4);
if(strlen(acno1)==3)
{
if(i==LedgerAccountType::sum)
{
sql = 'SELECT FROMACCOUNT,TOACCOUNT FROM
LEDGERTABLEINTERVAL WHERE ACCOUNTTABLEID ='+_tableId+' AND
ACCOUNTRECID = '+k+'';
R1 = Stmt.executeQuery(sql);
while(R1.next())
{
print R1.getString(1),' ',R1.getString(2),' ',k;
pause;
}
}
else
{
//bl.
}
}acno1
} ledgertable2
it just takes the first value from the second resultset and then go
out of the loop.
best wishes...
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [development-axapta] Printing Sales invoice
I don't really know but you could start your research in SalesFormLetter_Invoice.newJournalList(). From what I see in the call to formLetterSorting, it looks like the sorting is defined in the table FormLetterSortingParameters. But I don't know where you can modify this table from the GUI. Steeve... -Message d'origine- De : anettemalmberg [mailto:[EMAIL PROTECTED] Envoyé : 7 mars 2005 09:00 À : development-axapta@yahoogroups.com Objet : [development-axapta] Printing Sales invoice Hi Multiprinting of Sales invoice is sorting by SalesId. How can I modify this sorting so all Invoices will come out sortied by another field in SalesTable instead? Thanks Yahoo! Groups Links Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: Axapta 3.0 Installation - ODBC (To use or not to use)
Thank you very much for the replies so far. I forgot to mention in the original message that we are running MS SQL 2000 with sp3a Axapta 3.0 SP2. Just one more thing: If I do not set up a manual ODBC Data Source, will connection pooling still take place. >From the pervious responses I assume that Axapta 3.0 will still use the ODBC SQL Server Driver and build the connection string based on the other supplied configuration setting (Server, Database, UserID etc.) and hence connection pooling will still occur - kind of like building a dynamic data source. But you know what they say about assumptions. Kind Regards, Pieter Smith Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Printing Sales invoice
Hi Are u sure the invoices are being sorted by sales id? The invoices are printed in the same order that they are processed. What u could perhaps do is to send the invoices to print archive, get a list of all the processed invoices, sort them by another field and then print them to printer Regards harry _ From: anettemalmberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 March 2005 3:00 a.m. To: development-axapta@yahoogroups.com Subject: [development-axapta] Printing Sales invoice Hi Multiprinting of Sales invoice is sorting by SalesId. How can I modify this sorting so all Invoices will come out sortied by another field in SalesTable instead? Thanks Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129h7hrs1/M=298184.6018725.7038619.3001176/ D=groups/S=1705006764:HM/EXP=1110383476/A=2593423/R=0/SIG=11el9gslf/*htt p:/www.netflix.com/Default?mqso=60190075 http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group s/S=:HM/A=2593423/rand=711762574 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions Ph +64 29 289 9031 Fax +64 9 358 1018 CGNZ Limited and its predecessor organisations (Cap Gemini Ernst Young, and Ernst Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects. CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the world's leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices. Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies. The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business Solutions. Find out more about what we do at http://www.cgnz.com/middlemarketsolutions CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachments. CGNZ does not accept any liability for any changes made to this email or attachments after sending by CGNZ. You must scan this email and attachments for viruses. The opinions expressed are not necessarily those of CGNZ. CGNZ accepts no liability for any loss, damage or consequence, whether caused by our own negligence or not, resulting directly or indirectly from the use of this email and attachments. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
