07-19-2012 12:04 PM
I have established ODBC connection to Access db thru EG. However not able to query the tables (live)? I tried making copy of the tables (day old ) but still not able to query that table
07-19-2012 12:42 PM
If someone else has the table locked for update (e.g. exclusive access), SAS won't be able to read it.
BTW, if you have SAS/Access for PC Files licenses, you will get better performance by just specifying the Access database in a libname statement.
07-19-2012 01:29 PM
thank you Duke,. we do have SAS/Access for PC files license. The libname statement does not work since the server is running on AIX box. right now I export the table as Excel file and work with it.
07-19-2012 03:43 PM
One other possibility just came to mind. If you click Open --> data and then select ODBC, you are connecting to the data directly from EGuide and NOT using AIX. If you are using a LIBNAME statement with the ODBC engine, then you are connecting through AIX. The two different approaches use different ODBC drivers and have different performance characteristics. If you are using the first approach, you could open the data directly (using the PC Files engine) rather than ODBC.
07-19-2012 03:55 PM
Yes, I am able to open the data in EG using the first approach. I can not query the data, while users are entering the data into the table. I get error msg " cannot access SAS Code". I have to ask users to log off the access db to run reports.is there any other work around to run reports using that table?
Appreciate your help.
07-19-2012 03:59 PM
Is your MS access or Excel ODBC database defined in Data Sources (ODBC)? Define user DSN in Start --> all Programs --> Administrative Tools --. Data Sources (ODBC).
The path and file name has to match exactly. It is a pain to update paths for production jobs placed in monthly directories.