Hi,

I just installed the Adagio ODBC 9 Connector. When I connect through Excel, the Invoice Module Tables aren't showing up. My AR, AP and GL tables are there. When I run Data Dictionary I am not seeing the Invoice Module either. I have checked and double checked the path, the connection, etc., everything seems fine.

Thanks in advance for any help.

Ryan

Hi Ryan,

Adagio Invoices data files and ODBC table names start with the letters QI, rather than IN, for legacy reasons.

If your configuration of the ODBC connection to your data is selecting particular data rather than All, make sure you are using QI* instead of IN*.

What is your version of Adagio Invoices and other programs?

Hi.

The invoice module is 9.0B. I'm doing the upgrade tomorrow. I tried entering QI* and Q* into the ODBC connector and got a message that the query could not find tables.Payables is 8.1D, Receivables is 9.0C, Ledger is 9.0D, and Inventory is 8.1D. All those tables are coming up.

Ryan

Make sure you have launched Invoices itself before trying to connect with ODBC.

I'm still getting the source has no visible tables in the query. I opened the invoices module.

Use "AI9*" in the DSN (that's "Alpha" "India" "Nine" "Star"). It's working for me.

Hi, tried AI9* and no luck. I'm going to apply the upgrade and see what happens.

Okay, I have upgraded my Invoices module to 9.1A, redone my ODBC connection, tried AI9* in the DSN and Q* in the DSN.Still getting source has no visible tables and Invoices is still not showing up in the Data Dictionary. I need to get this working to do my reports. Any other suggestions?

The currently shipping Invoices is 9.2A. What version of ODBC are you running?

I'm running ODBC 9.1A.