Ok this was resolved by updating to the latest SQLServer Driver V10.2
IFS is hosting our SaaS environment.They had to white list the IP of my computer for it to be able to establish a connection.
I was able to determined the the lokup_value_id was the item_id in the item table.If I recall correctly you are right and the lookup_table_id was 143.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.