Skip to main content

[archive] XDBC VISION: Columns not found, record not found

  • November 29, 2010
  • 1 reply
  • 1 view

[Migrated content. Thread originally posted on 29 November 2010]

Good day,

I install an XBDC driver on a windows 2003 server. I put my GENESIS_HOME variable, create the syscat, put my xfd files in it and finally set my ODBC dns.

When i go to excel to get external data, all works well for many tables, but in some of them i get this error in the final step to get the data:

VISION: Columns not found, record not found

?Any tips?

Thanks afterwards

1 reply

[Migrated content. Thread originally posted on 29 November 2010]

Good day,

I install an XBDC driver on a windows 2003 server. I put my GENESIS_HOME variable, create the syscat, put my xfd files in it and finally set my ODBC dns.

When i go to excel to get external data, all works well for many tables, but in some of them i get this error in the final step to get the data:

VISION: Columns not found, record not found

?Any tips?

Thanks afterwards
Good day,

Problem solved. Was a problem with too much XFD introduced in my syscat. Like 347 xfd, but I reduce to 50 xfd and no more messages showed.

Thanks anyway :P