Printable View
I'm in desperate need of a host with SQL2000 and php support, but I have no idea of any that support that and of the ones I've checked out so far, it's almost always *only* php+mysql. I need the php support because I'm not about to rewrite this entire site for my job....there's no way I can do that in the time limit I've got and I've only *just* been told today that I need to connect the site to an SQL2000 server. So if anyone knows of any good hosts, I'd be very greatful to know.
http://www.google.com/search?hl=en&q...+hosts&spell=1 ?
Titanhosting stands out
www.hostdepartment.com is good, I used to use them for my site. PHP/ASP.NET and SQL server.
I still don't understand why you "have" to connect to an SQL2000 server, unless the server is hosted by the company you're doing the work for. In that case, you just need a host that will hook you up with the mssql extension for PHP.
For the site I'm doing, I need to be able to connect to an SQL2000 db every night and update my server's database so that my database is up-to-date with theirs.
That sounds like bad management. You need to setup a DTS package on their server to do the update. I wouldn't bother doing that from PHP if I were you.
What I'm going to do is just have a nightly cron job run that'll update the database automatically. The database I'm connecting to is not on my server, and they don't want me just directly accessing their database all the time.
Right. So what I'm saying is, why not have them setup a DTS package that does the update work for you instead of you spending a bunch of time writing the update script in PHP. It would be an easy setup for them and save you time.
But then again, I don't know your situation with them or their staff and their capabilities, so maybe your route is the best.
I don't think that the people running the other database have the ability to run a DTS for us. From what I can tell, the guy I talked to about setting this up over at their company is only able to create new accounts and set access privileges.
There are many other people who connect to this database and from what they've told me, all they're allowing people to do is connect to the database and that's basically it.
Wow. That sucks. I thought I'd at least mention it in case it would save you some effort.