Hi All, I’ve programmed some Source Code in Excel 97 to import Data from Navision. This Source Code works fine with all versions from Navision 2.00 up to 2.60 (all German). But now, in the new Attain (German) there are some problems. If I start a query in Excel, Excel will crash with the Information from “Dr. Watson”: ------------------------------------------------ EXCEL.exe access violation (0xc0000005), address 0x02085ce1 ------------------------------------------------ Is there a know bug in the new ODBC driver? I used the ODBC driver form Attain 3.01.A, and yesterday the new one from the 3.01.B. The problem still persists. I tried it on several other computers and Operating Systems, but it is always the same. I also tried Excel to create a query, by themself (with the query assistant). I’ve got the same Error message of access violation, all the time. Did anyone has worked, or still works with Attain’s ODBC driver? Any inforamtion or experiences are wellcome. Please!!! Thanks Temple
No problems found: Excel XP, Attain 3.01A, access via MSQuery. ODBC Driver parameters: object’s name translation sconfigured as “a-z,A-Z,0-9,_” Language: Auto Quenstions: - Office version? - access to data (ADO+Code/MSQuery)? Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia
Thanks for responding, Answer: I use Excel 97, but it won’t work with Excel 2000 as well. ========================================================================================== 'example Source Code, who brings the access violation as well 'use example Database (database.fdb) and Company Name: CRONUS AG 'start the Source Code more than once, to test the ODBC driver Sub ODBC_Test() With ActiveSheet.QueryTables.Add _ ( _ Connection:=Array _ ( _ Array(“ODBC;DSN=Sample C/ODBC 32 bit;IT=All Except DOT;”) _ ), _ Destination:=Range(“A1”) _ ) .Sql = Array("SELECT Nr_, Beschreibung " & Chr(13) & “” & Chr(10) _ & “FROM Artikel” & Chr(13) & “” & Chr(10)) .FieldNames = True .RefreshStyle = xlInsertDeleteCells .RowNumbers = False .FillAdjacentFormulas = False .RefreshOnFileOpen = False .HasAutoFormat = True .BackgroundQuery = True .TablesOnlyFromHTML = True .Refresh BackgroundQuery:=False .SavePassword = True .SaveData = True End With End Sub ========================================================================================== My ODBC Options: ================ Commit Cache: Yes DBMS Cache (KB): 1000 Enable BLOB Fields: Yes Identifiers: All Except DOT Language: Auto(Windows Language) Query Time-out: Yes Query Time-out (sec.): Read Only: No Tmp Path: Closing Date Support: I tried your Options, but they bring the same Error Message. Did you use the German Version of Attain? Temple
Try to use “Get External Data” wizard in Excel and record macro. If all is Ak then you can open macro in VB Editor and see how excel retrieves data. Make same code. May be problem in some parameters of “ActiveSheet.QueryTables.Add” Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia
I tryed it, but Excel crashed with the same Error Message of Access Violation, before i can take a look at the recorded macro. I reinstalled the ODBC driver but the Error is still there. Did you use the English Version of Attain? Temple
Yes I am using W1 version of Attain. Exactly, try to use english captions of fields or do not use “Auto” language. In Attain all normal (internal) captions are english. Only multi-lang. captions contains localized text. Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia
I altered the language in the ODBC driver and in WinNT to English (Great Britain and another time USA). I used captions in English. The error message is still there. I reinstalled the driver, always the same. The Attain Version I use is the multilingual (folder DEU and NEU exists) Version. I reinstalled the complete Attain, but nothing helps. The “Get External Data” wizard in Excel97 shows the following error message: “MSQRY32.EXE – Error in Application The Exception “unknown software exception” (0xc00000fd) has occurred at 0x77f7468f.” Would it be helpful to you, to give you the protocol, which is every time created by Dr. Watson (System Tool)? Temple Edited by - Caleb on 2002 Jan 22 15:45:38
Hmmm… But how about C/FRONT? Try to open sample Excel file from Navision C/FRONT. Also try to access data using “ADODB.Connection” and “ADODB.Recordset”. Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia