MAS 90 version = 4.30.0.23
ProvideX driver version = 4.21.1000
I am attempting to query MAS 90 data using the ProvideX ODCB driver. My queries are running, but no data is returned.
1) MAS 90 has been set up with a role that gives me read access to all tables I'm querying.
2) I created a 32 bit system DSN called MAS90, identical to the default user DSN SOTAMAS90.
3) My connection string for the driver:
DSN=MAS90; Directory=\\ccmapp02\M90w\MAS90; Prefix=\\ccmapp02\M90w\MAS90\SY\, \\ccmapp02\M90w\MAS90\==\; ViewDLL=\\ccmapp02\M90w\MAS90\Home\; LogFile=\PVXODBC.LOG; CacheSize=4; DirtyReads=1; BurstMode=1; StripTrailingSpaces=1; SERVER=NotTheServer
4) My connection string logon:
DSN=MAS90;Company=CCM;UID=sdobbins;PWD=xxxxx
successfully connects to the database.
5) Through the LabVIEW application program I have written, I can successfully query a list of tables in MAS 90, as well as the field names in any given table.
6) When I run a simple query, I get no error message, just zero rows returned (no data). Seems there is a setting of some sort that I failed to configure, either in my application or in the DSN or in the MAS 90 permissions. I can completely remove the WHERE clause from the query, and still no data is returned. I know there are thousands of records in the table.
7) This is the query:
SELECT AddressLine1, AddressLine2, City, State, ZipCode
FROM AR_Customer
WHERE State = 'MN'
ORDER BY ZipCode
Does anyone know why my query would run, not error out, yet return no data? Thanks all.