Bartender Does Not Show The Oracle View Table I Need Follow
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 220.127.116.11.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.
American Barcode and RFID
★ BarTender Hero ★
Please sign in to leave a comment.