Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  ODBC call failed (to SQLBase)

Author  Topic  Edrovi Starting Member 2 Posts Posted - 2011-06-24 : 16:53:19 Hi guys! I'm having problems with a query, tried to find help on the net, but wasn't lucky. I'm trying to develop an application to analyse information on a SQLBase application. I created my ODBC using Unify SQLBase 11.6 (SQLBASEODBC.DLL, 23/03/2011), and attached some files to my Access 2003 DB, running on Windows XP SP2 (client has this configuration). I was able to connect to the tables and I can get the information from them. I even created some Forms that use one of those tables joined to a local Access table successfully. The problem comes when I try to create a query using (at least) two of those tables, I keep getting a message: [Unify][ODBC Driver][SQLBase]01401 DLU ICN Invalid column name ID (#1401) ("ID" is one of the field names I'm joining the tables from) Here's a simple query I'm trying to run without success: SELECT PUBLIC_CUSTOMER2.ID, PUBLIC_RECEIVABLE2.INVOICE_ID FROM PUBLIC_RECEIVABLE2 INNER JOIN PUBLIC_CUSTOMER2 ON PUBLIC_RECEIVABLE2.CUSTOMER_ID = PUBLIC_CUSTOMER2.ID; I have a feeling it has something to do with the way it references the fields, as the ODBC connection string for PUBLIC_CUSTOMER2 goes: ODBC;DSN=Unify SQLBase; DB=vmfgs; SRVR=server1; IsoLevel=RL; TABLE=PUBLIC.CUSTOMER ..."Table" is separated by a dot, not an underscore... so I think it has something to do on the way it "converts" the field names... I may be wrong, though. Hope someone can help me out on this so I can complete my project... and get paid! Ed Rosales