Warning: Table '.\dcgforum\cache_page' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://forums.dataphor.org/index.php?q=node/31' in C:\Sites\DCGForum\includes\database.mysql.inc on line 172
SAS device | Dataphor Forums

SAS device

Has anyone successfully used SAS as a device? I'd like to see a sample SAS register script.

Nate - could you possibly supply another hint (or two) about your secret project?:)

Thanks,
steve
www.beyondsql.blogspot.com

SAS Device

Hi Steve,

Apologies for the delays, we're really busy buying gold :).

I have successfully used a SAS device, and even got an application working that used a SAS device and an Oracle device together. However, that was several years ago, and I'm not sure that the current SAS device would still work with the latest version of SAS. Also, I haven't looked at SAS lately, but at that time, it was almost impossible to get a development copy of SAS, so we had a very hard time getting a test environment put together.

All that being said, you're welcome to try to get one working, the source for the SAS device is available with the rest of the Dataphor project (thankfully, the Dataphor repository is still functional).

Here is a sample SAS device:

create device SAS
reconciliation { mode = { command }, master = device }
class "SASDevice"
attributes
{
"Location" = "SASLocation",
"ServerID" = "SASServer"
};

CreateDeviceUser("System", "SAS", "SYSTEM", "SASPassword");
CreateDeviceUser("Admin", "SAS", "SYSTEM", "SASPassword");

Regards,
Bryn Rhodes
Database Consulting Group LLC


Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: LOCK TABLES cache_page WRITE</em> in <em>C:\\Sites\\DCGForum\\includes\\database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://forums.dataphor.org/index.php?q=node/31', '', '54.196.190.32', 1542385715) in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: UPDATE cache_page SET data = &amp;#039;\\0\\0\\0\\0\\0\\0Xr6nQ&amp;amp;%eS;=؝NHHB\\r \\0ZVC&amp;gt;Nd%n7ɯͅ ;}~_{ݗg,$9&amp;lt;a8|u}vL]&amp;amp;lh\\\\y$岿\\&amp;#039;ob4 z[O\\\\M&amp;gt;yA7*xgaD/HkG&amp;gt;ZN:%&amp;amp;/.X&amp;amp;e*? w\\\\hþҦ( kj\\\\8Hx,Uz‰ŗRD,\\roȉ2G,]pcWn?X2)Y\\\\1#81 ҈-d&amp;amp;ɜk19H|.8PWκ\\n@jmrI&amp;gt;R2/!EI:ѧG3̮ye ++|\\nf3RcX1X| V4LOgӧRJ# w~~ in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Incorrect string value: &amp;#039;\\x8B\\x08\\0\\0...&amp;#039; for column &amp;#039;session&amp;#039; at row 1\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;vhhfqcun4tkk19bnh9p2h3nn03&amp;#039;, 0, 0, &amp;#039;54.196.190.32&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:2:{i:0;s:195:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is marked as crashed and should be repaired\\nquery: LOCK TABLES cache_page WRITE in C:\\\\Sites\\\\DCGForum\\\\includes\\\\database.mysql.inc on line 172.\\&amp;quot;;i:1;s:2823:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is mark in C:\Sites\DCGForum\includes\database.mysql.inc on line 172