Hello all,

I have searched the forums and documentation as well as speaking with tech support while I was onsite at a customer's location and no solution could be found. 

They have a fairly simple label that we need to connect to an Oracle DB(table).  They got the Oracle Client/Drivers installed on the PC and we can now get into the process of Connecting to the DB. 

Oracle Server version is 11.2.0.2.0

Driver version is OraClient11g_home1

In BarTender Add Database Connection Wizard, I choose ODBC, and then System Data Source and I get the list of tables from the DB.  I see a bunch, but I do not see the two View tables I am looking for. I do see other View tables though.

In troubleshooting I can connect via Access and see all of the expected tables including the two I need.  They show with a name of FB.V_BART_RECEIPT_LINE and FB.V_BART_RECEIPT_MULTI_LOTS.  I can see the fields as well.

Looking through the entire list of tables in the BarTender Add Database Connection Wizard, I noticed that it does show two tables named V_BART_RECEIPT_LINE and V_BART_RECEIPT_MULTI_LOTS.

I was able to add one of these tables, but then cannot see anything in the table and (if I remember when this happened correctly) get a BarTender error #3238.  It also lists other errors in the body: "0x80040E37 ORA-00942: table or view does not exist" and "0x80040E37 Table does not exist."

My thought is that the FB tables are a different type of View table that BarTender cannot access, but I don't use Oracle and am no expert at how they do things.

Any help would be greatly appreciated.

Shawn Christopherson
American Barcode and RFID