This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


~Judy Dwoponevergon
Jul 7, 2015, 8:58 PM
5 Posts

List of columns from a "table"

  • Category: Connections Files Integration
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags: odbc,notessql
  • Replies: 1

In Excel 2013, I am connecting to a Lotus Notes database (.nsf) via an ODBC connection.  One of the "tables", I am trying to retrieve data from throws and error: [Lotus] [ODBC Lotus Notes] Too many columns or expression in the statement.  I can connect to the server via SQL Server Management Studio linked server.

I do not know what columns are available to choose.  Is there a way to query the table to show the list of columns?  Is there any way to see this column list using SQL? 

~Judy Dwoponevergon
Jul 10, 2015, 3:15 PM
5 Posts
DB Visualizer

I downloaded DbVisualizer and connected to the replica via ODBC and was able to see all of the columns in that particular table/form.

 

https://www.dbvis.com/


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal