Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
KimBeck Contributor.
Contributor.
443 views

Maximum Record Length for AcuODBC ver 6

Jump to solution

Does anyone know the maximum record length for AcuODBC version 6?

0 Likes
1 Solution

Accepted Solutions
Micro Focus Contributor
Micro Focus Contributor

Re: Maximum Record Length for AcuODBC ver 6

Jump to solution

Looking in the (very old) source, it looks like the maximum record size is stored in a short, which would make the maximum size 32767 bytes.

View solution in original post

5 Replies
Micro Focus Expert
Micro Focus Expert

Re: Maximum Record Length for AcuODBC ver 6

Jump to solution

The maximum record size allowed in Vision 5 files is 67,108,864 bytes. The maximum record size allowed in
Vision 2, 3, and 4 files is 32,767 bytes

0 Likes
TonyLeBlanc Super Contributor.
Super Contributor.

Re: Maximum Record Length for AcuODBC ver 6

Jump to solution

Hi, Stephen, thanks.

The issue we're having is we have one file with a record length of 100,010 bytes.  The XFD we create works fine with Alfred, so we feel confident the XFD itself it okay.

However, when we try to access this file from Excel or another application using AcuODBC (version 6, on Windows), the application (Excel or other) acts as if the file does not exist (ie we get the same error message that we get when we try to access a Vision file that actually doesn't exist).  A previous post Kim left about this generated a reply about the ODBC log file, but we frankly don't understand what we're looking at in the log file.

The curious thing is that for all other files, where we generate the XFD from the same root program, work just fine with AcuODBC 6 and Excel.  It seems to be just this one file, and the only thing we can determine that is significantly different is the record length. 

We know AcuODBC is an obsolete product, but we were hoping to be able to give this one customer an answer about accessing this file.

Thanks for any suggestions

Tony

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Maximum Record Length for AcuODBC ver 6

Jump to solution

Go ahead and attach the ODBC logs or send them to me @ stephen.hjerpe@microfocus.com

Have you tried using vutil to rebuild and or unloading the file to a temp file, then reloading the file back into the Vision file.

 

 

0 Likes
KimBeck Contributor.
Contributor.

Re: Maximum Record Length for AcuODBC ver 6

Jump to solution

Please find the log files attached.

0 Likes
Micro Focus Contributor
Micro Focus Contributor

Re: Maximum Record Length for AcuODBC ver 6

Jump to solution

Looking in the (very old) source, it looks like the maximum record size is stored in a short, which would make the maximum size 32767 bytes.

View solution in original post

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.