https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/SAS-Connect-and-SAS-Access-to-MIDAS/m-p/10686#M853 [cross posted to SAS-L]<BR /> <BR /> Anyone here using SAS/Connect and SAS/Access to ODBC to connect to MIDAS+ from a 64-bit Windows server?<BR /> <BR /> We're setting up a new SAS server and having a hard time getting the connection to work. If I get directly on the server via remote desktop, a libname statement works. If I rsubmit that same libname statement from my PC, it won't work for 5-15 minutes. I sit here and every 2-3 minutes resubmit the libname and eventually it goes through.<BR /> <BR /> We have install the 64-bit KB_SQL driver and created a system DSN for MIDAS. We're also in touch with tech support, but I thought I'd try here too.<BR /> <BR /> MIDAS is a Cache backend if anyone has thoughts on that... Tue, 27 Apr 2010 14:57:55 GMT JenHarper 2010-04-27T14:57:55Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/SAS-Connect-and-SAS-Access-to-MIDAS/m-p/10686#M853 [cross posted to SAS-L]<BR /> <BR /> Anyone here using SAS/Connect and SAS/Access to ODBC to connect to MIDAS+ from a 64-bit Windows server?<BR /> <BR /> We're setting up a new SAS server and having a hard time getting the connection to work. If I get directly on the server via remote desktop, a libname statement works. If I rsubmit that same libname statement from my PC, it won't work for 5-15 minutes. I sit here and every 2-3 minutes resubmit the libname and eventually it goes through.<BR /> <BR /> We have install the 64-bit KB_SQL driver and created a system DSN for MIDAS. We're also in touch with tech support, but I thought I'd try here too.<BR /> <BR /> MIDAS is a Cache backend if anyone has thoughts on that... Tue, 27 Apr 2010 14:57:55 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/SAS-Connect-and-SAS-Access-to-MIDAS/m-p/10686#M853 JenHarper 2010-04-27T14:57:55Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/SAS-Connect-and-SAS-Access-to-MIDAS/m-p/10687#M854 Hi Jen<BR /> <BR /> I'm afraid I can't help you with your question but I am interested in Cache. It sounds like Midas is an Intersystems Cache system. In fact you are the only reference I could find to Cache in the SAS database. I have used mainframe SAS for years and I find myself in a new job in a Cache shop with no one using it. My hope is to increase my knowledge of SAS and Cache and possibly introduce it, if it proves to be as useful as I think it could be. If you are willing to provide me with any help or advice in this area my email is ericwolff@wolffworks.com.<BR /> <BR /> In any case, thanks for reading this. <BR /> <BR /> eric Mon, 20 Sep 2010 02:38:58 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/SAS-Connect-and-SAS-Access-to-MIDAS/m-p/10687#M854 deleted_user 2010-09-20T02:38:58Z