@Dbcolumn - ODBC

HCL Domino Domino Forum
1

I have a dialog list field on a form whose choices I am trying to populate with @Dbcolumn. I have, to the best of my knowledge, set up the ODBC data source but Notes is returning “Memory allocation/deallocation error” followed by a dialog entitled “Select Keywords” with the value B1:8D.

What does this mean/what am I doing wrong?

Specifically, I have called my ODBC connection Notes400, and am trying to extract a column entitled “EMNO” from a table called “EMAP”.

My formula is @Dbcolumn(“ODBC”:”ReCache”;”Notes400"; “UserID”; “UserPassword”; “EMAP”; “EMNO”)

2

Subject: @Dbcolumn - ODBC

You should declare the table including the shemafor example “dbo.EMAP”

I had such a connection with MS-SQL Server but it didn´t work since i have updated to 6.53. Perhaps it is a new bug. Aren´t we acustomed to that?

3

Subject: Check the tnsnames.ora file

in the Oracle/Network/Admin file and ensure it contains your connection information.