BookmarkSubscribeRSS Feed
avatar
Fluorite | Level 6

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

any suggestions?

Thanks

7 REPLIES 7
Doc_Duke
Rhodochrosite | Level 12

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.

Doc Muhlbaier

Duke

avatar
Fluorite | Level 6

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.

Doc_Duke
Rhodochrosite | Level 12

It is also possible that the ODBC connectivity on AIX is not configured properly. Are you able to read the data with some other tool on AIX?

avatar
Fluorite | Level 6

I am working with EG4.1 on Windows XP. I have to check with Server Administrator regarding possibilities.

Doc_Duke
Rhodochrosite | Level 12

Avatar,

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.

Doc

avatar
Fluorite | Level 6

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.

Dorota_Jarosz
Obsidian | Level 7

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1026 views
  • 0 likes
  • 3 in conversation