{"id":1550,"date":"2018-01-19T19:22:58","date_gmt":"2018-01-19T19:22:58","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/odbc-socket-server-page-2\/"},"modified":"2018-01-19T19:24:52","modified_gmt":"2018-01-19T19:24:52","slug":"odbc-socket-server-page-2","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/odbc-socket-server-page-2\/","title":{"rendered":"ODBC Socket Server Page 2"},"content":{"rendered":"<div class=\"phpbuilder-content\">\n<div class=\"phpbuilder-meta\">\n<div class=\"\">By Tim Uckun<\/div>\n<div class=\"\">on December 6, 2000<\/div>\n<\/p><\/div>\n<div id=\"overflow-content\">\n<div class=\"articleHeader\">\nStep 1: Gathering up the materials.<\/div>\n<div class=\"articlePara\">\nYou will need the following items.<\/div>\n<div class=\"articleList\">\n<ul>\n<li>One machine running any 32 bit version of Windows. Although ODBC socketserver runs on all the<br \/>\nflavors of Windows, you should probably stick to NT. I have successfully tested<br \/>\nthis on NT4sp6 and Windows 2000 pro. Since the socket server uses ADO, it tends to be bit of a memory hog.<br \/>\n(As with all Windows applications, the more memory you throw at it, the<br \/>\nbetter and faster it will run).<\/li>\n<li>The latest MDAC drivers from Microsoft. This will contain all the ODBC and ADO<br \/>\ndrivers you need.<\/li>\n<li>Microsoft Access.<\/li>\n<li>ODBCSocketServer server from <a href=\"http:\/\/odbc.linuxave.net\/\" target=\"_blank\">http:\/\/odbc.linuxave.net\/<\/a><\/li>\n<li>One machine running any OS of your choice and PHP. <\/li>\n<\/ul>\n<\/div>\n<div class=\"articleHeader\">\nStep 2: Setting up the server:<\/div>\n<div class=\"articleList\">\n<ul>\n<li> Download and install the socketserver. The web site contains very clear, easy to follow and<br \/>\nclear. Basically, all you do is.<\/li>\n<ul>\n<li>Unzip the archive in a directory of your choosing.<\/li>\n<li>If you have NT run c:path-to-socket-serverODBCSocketServer.exe \/Service<\/li>\n<li>If you don&#8217;t have NT create a shortcut to ODBCSocketServer.exe in your start menu.<\/li>\n<li>Double click on the Registry.reg file to set registry entries.<\/li>\n<li>If you are using NT open up the services panel and set startup options for the odbcsocketserver service.<br \/>\n\t\tYou might have to run the service as a privledged user if your MDB file contains linked tables on network drives.<\/li>\n<li>VERY IMPORTANT: It is very important to note that the php object I have attached is able to<br \/>\n\t\tsuccessfully parse only the Microsoft ADO XML format. You must set the &#8220;UseMSDTD&#8221; registry<br \/>\n\t\tentry to 1 in order to be able to use it properly. See the ODBCSocketserver documentation for more information.<\/li>\n<\/ul>\n<li>Download and install the latest MDAC (ODBC drivers) from Microsoft and install them. This will require a reboot.<\/li>\n<li>Create a ODBC DSN for the database you wish to use.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p><\/p>\n<div style=\"float: left; padding:15px; color:#17AAF3\">\n<div style=\"float:left; padding:2px;\"><a class=\"paginationPageLink\" href=\"timuckun20001207.html\">\u00ab Previous Page<\/a><\/div>\n<div style=\"float:left; padding:2px 4px 2px 4px;\"><a class=\"pageNumber\" href=\"timuckun20001207.html\">1<\/a> <\/div>\n<div style=\"float:left; font-size:16px; color:#FF7A22; padding:2px 2px 2px 2px; \">| <\/div>\n<div style=\"background-color:#B6E5FC; font-size:16px; margin-top:1px; padding:1px 4px 1px 4px; color:#000; font-style:bold; float:left;\">2<\/div>\n<div style=\"float:left; font-size:16px; color:#FF7A22; padding:2px 2px 2px 2px; \">| <\/div>\n<div style=\"float:left; padding:2px 4px 2px 4px;\"><a class=\"pageNumber\" href=\"timuckun200012079ba9.html?page=3\">3<\/a> <\/div>\n<div style=\"float:left; font-size:16px; color:#FF7A22; padding:2px 2px 2px 2px; \">| <\/div>\n<div style=\"float:left; padding:2px 4px 2px 4px;\"><a class=\"pageNumber\" href=\"timuckun20001207fdb0.html?page=4\">4<\/a> <\/div>\n<div style=\"float:left; padding:2px;\"><a class=\"paginationPageLink\" href=\"timuckun200012079ba9.html?page=3\">Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>System Administration: It&#8217;s a dirty job, but someone said I had to do<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1550","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1550"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1550\/revisions"}],"predecessor-version":[{"id":3379,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1550\/revisions\/3379"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}