Hi everybody, I developed report in excel with ODBC, when transfering data from navision to excel I got warning “[Navision Software a/s][Navision Financial ODBC Driver] Unknown Error”, is there anybody can tell me what’s the meaning of it. Thank’s…
A few pointers : - Are you using the same version of the ODBC driver than the version of Navision (ie : NF 2.60, Attain 3.10) ? - Have you double checked your ODBC setup ? (User ID, Company to open, etc,etc…) - Does the C/ODBC user in Navision has got the relevant read/write permission for the tables you’re accessing ??? - Can you get the C/ODBC Samples demonstration to work (this is available on the Navision CD) At which stage do you exactly get this error ? ###### tarek_demiati@ureach.com
Thanks for your attention, I did it, But my problem is When I transfered the Net Change, Balance At Date and Balance field from G/L Account table, there is error “[ Navision software a/s] [ Navision Financial ODBC driver] Unknown Error”. And If I transfer to other field and If I try with use Cronus it’s success. Net Change, Balance At Date and Balance Fieldclass is FlowField. So What is wrong about them.
Please ensure that you have C/ODBC granule in your personal license. I’m assuming you’re using a personal license and not a demo license.
there’s no problem with my license, It’s already included. Cause it’s not all field I transfer using ODBC end up Error, but only Balance At Date, Net change and Balance field. Have you ever had a problem like this ?? I hope your help. thanks, mardiana sibarani
I’ve tried with C/ODBC 3.10 with my Attain MY 3.10. There’s no problem. What country localization are you using? I’m using Malaysia localization. What version of Attain & C/ODBC.
How many fields are you trying to export using the odbc into excel. Don’t forget that you can only transfer 256 fields at a time using the ODBC as this is the amount of columns you have available in Excel.