Steve, thanks so very much for your reply. You make some very good points that should prove helpful. BTW, we started with the latest SamPHPweb pages for the MS SQL project that were downloaded "fresh" from SpacialAudio's website. The webpages for the local server which uses MySQL has been running for more than two years.
The MS SQL is running on the same remote server that the SAM4 is running on, but the webpages for SamPHPweb are on a separate machine, so we will make certain that the outgoing and incoming connections will be open. It would be helpful if the examples on the forums were updated so that we would be looking at something more recent than SAM2 examples. Of course, having heard how many thousands of dollars for each website the company intends to charge to set-up the SamPHPweb pages I'm fairly certain that too much help would only drive down income potential if the forum proved to be too helpful. Kind of like Louis explained, "tossing a fish" rather than expecting the customers to "learn to fish" or buy their fish at the fish market. if they expected to eat every day. <smile> Thanks, again, for the help, Steve. Your willingness to share pearls of wisdom brings back memories of the sharing days when SAM2 was the current product, and the BurningRealms we used to attend. Merry Christmas and Happy New Year! Loran ----- Original Message ----- From: "Steve Kunitzer" <[email protected]> To: <[email protected]> Sent: Tuesday, December 23, 2008 1:36 PM Subject: Re: [General-discussion] Code > Aloha Loran; I generally lurk on the discussion list primarily focusing > my wit, wisdom, and experience to the forums. > > Looks like you've changed the base samPHPweb pages quite a bit; if you > haven't ripped out any of the guts or used specific SQL syntax then > switching databases shouldn't be a problem as the samPHPweb has a database > abstraction layer and can switch between MySQL, MS SQL, and Firebird > (probably some others, too).. > Open dbconfig.xml.php, change the driver to MYSQL and the rest of the > settings to the database details. > > You'll also need to make sure the webserver has outgoing connections to > the database and the database allows incoming connections (as appropriate > and as needed; if the webserver and db are on the same machine this is not > a problem but if they are on separate machine with the Internet or some > network between them the communication channels need to be open). > > Louis/Bryan/Jay: If you have some time please see my SAM5 Bone post in > the forums backstage. Thanks. > > Steve Kunitzer > http://www.festerhead.com > > > > Loran Partigianoni wrote: >> Hello, Steve: >> >> I haven't seen you writing responses for far too long a time. I'm >> delighted to see you back onboard. We need your experience. >> >> Quick question, if you don't mind. I have SamPHP wehpages working on my >> local server (which uses MySQL). But, I've also got a remote server >> using MS SQL ... and I would like to have similar SamPHP page showing the >> remote server's playlist. What changes would I need to make in the code, >> as well as, on the SAM4 being used on the remote server? I know that the >> Help pages recommend using a local server, but is there a way to create >> the webpages? >> >> If you have the time to look at my current webpage: >> >> http;//www.acappellaradio.net >> >> Thanks! >> >> Merry Christmas & Happy New Year >> >> Loran Partigianoni > _______________________________________________ > General-discussion mailing list > [email protected] > http://mailman.spacialaudio.com/mailman/listinfo/general-discussion > > TO unsubscribe to this list, simply send a blank email to > [email protected] > > with the subject 'unsubscribe' >
