[U2] ODBC - Not finding the MV fields.

We're running UniVerse 11.x and we've had ODBC setup for a while but recently started to use it more. The single-value fields work just fine, but on some of the Multi-Value fields (only certain tables) we can get the ODCB to work in excel by manually entering the SQL command but they don't show in Microsoft Query.

So the issue is that we don't see it in the Microsoft Query window, or even in Access (for certain tables). Is there anyway to "debug" why the MV on some tables
work, but others don't? Is there a way to list the tables that ODBC recognizes?

I tried using Dr. DeeBee and it wasn't much help since I didn't get a log after running it.

Any help is appreciated, thanks.

Chris



 		 	   		  
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users