I am not sure what they are as I dont set them up. But I found the file odbc.ini as attached, does this help? all the password is XXXXXX though   ... View more

what does <connection info> look like here? username followed by password? or some kind of strings? ... View more

which one is #2? ... View more

we pinged and it is communication could this be a signal that firewall is not blocking already? ... View more

thanks after press add button, what do i need? ... View more

yes definitely it is running fine and a lot of other people can use it ... View more

thanks KSharp. please could you elaborate more? where is the 'add user' button? As I am supporting my client and dont have enterprise guide interface myself I am not able to test. If it is possible, please could you solutions in great details. Thanks. ... View more

Hi my colleague just have sas enterprise guide installed but couldnt connect to metadata server. how to resolve? we tried ping and it can communicate. What could have gone wrong? please see attached pic.  ... View more

unfortunately I cannot run SAS myself, I will ask a colleague to and get back to you but may be a bit later as he is on vacation   ... View more

the database is db2 the domain, is just somewhere this text file from db2 is stored, I dont think it is hadoop as out system is at least 30 years behind It is like IT system create required files in databse then output as text to this domain where downstream system or  users subscribe for these files for later use     ... View more

 I checked all the way before sas 1. database   2. domain   3. interface   1. database - where the required table is stored 2. domain - where text file output from the required table in database is located  3. interface - this interface is between domain in 2 and sas  (this interface is something related to setting up odbc) all 1, 2,3 are showing 4d.p., so it is sas that is the problem   the IT guy who checked the interface confirmed it is showing 4d.p. and advised us to check setting in sas how to check?             ... View more

oh I just tried to use format best32.4 but it shows that the informat is 21.2 so somewhere the informat was already setup? I didnt know ODBS has preset schema for tables..   ... View more