Highlighted
Absent Member.
Absent Member.
1034 views

AcuODBC Copied updated xfd and data file to server - not showing up in Excel

[Migrated content. Thread originally posted on 09 February 2011]

Not sure fi this is the right place fo rthis.
We are running AcuODBC 7.1 on a LINUX platform and accessing the data from a Windows machine. We made a change to our data structure. We rebuilt the data file and rebuilt the XFD file. Loaded both of these onto our LINUX server in the proper place (copied old versions aside). Restarted acuodbcs. Went into Windows using Excel to access the data but the updated file no longer appears in the dialog box. It was there before we made the changes. No errors show up in the logs. Anyone on the forum seen this happen before?
0 Likes
2 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

RE: AcuODBC Copied updated xfd and data file to server - not showing up in Excel

When you said "rebuilt" do you mean you used vutil -rebuild or did the fd of the file get changed? I will guess the later, which is why you "rebuilt" the xfd. So are you using a new spreadsheet in Excel or your old one, as the old one was laid out by the previous xfd. Are you able to make a new "blank" spreadsheet and import?
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: AcuODBC Copied updated xfd and data file to server - not showing up in Excel

John,

I'll be looking into it but first need to reinstall AcuCobol-Gt V7.x and AcuODBC etc. will probably get this tomorrow morning done.
Will then test and hopefully suggest a possible reason/solution, I remember having had similar things happen sometimes.

If possible use for example Access and try if you can see the file if you open the DSN, if that works then the problem is Excel. Create a new test spreadsheet and open the DSN and see if the file now is visible.

Best regards,

Piet
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.