Bartender Does Not Show The Oracle View Table I Need
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 22.214.171.124.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
What BarTender Edition, Version and Build is in use?
Have you tried using our embedded OLE DB provider for Oracle? Do you get the same result?
Alternatively, when using BT's database connection setup dialog, choose "General OLE DB provider" as the database platform and then make use of the "Microsoft OLE DB Provider for ODBC drivers" and then connect it with your System DSN.
Do you have a different application which could connect to this database using the same ODBC driver? If yes, do the views appear then and do they contain values?
Will this help?0