Webhost with SQL2000 and PHP support....

This is a discussion on Webhost with SQL2000 and PHP support.... within the A Brief History of Cprogramming.com forums, part of the Community Boards category; I'm in desperate need of a host with SQL2000 and php support, but I have no idea of any that ...

  1. #1
    Software Developer jverkoey's Avatar
    Join Date
    Feb 2003
    Location
    University of Waterloo
    Posts
    1,903

    Webhost with SQL2000 and PHP support....

    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.

  2. #2
    mov.w #$1337,D0 Jeremy G's Avatar
    Join Date
    Nov 2001
    Posts
    704
    c++->visualc++->directx->opengl->c++;
    (it should be realized my posts are all in a light hearted manner. And should not be taken offense to.)

  3. #3
    Banned nickname_changed's Avatar
    Join Date
    Feb 2003
    Location
    Australia
    Posts
    986
    www.hostdepartment.com is good, I used to use them for my site. PHP/ASP.NET and SQL server.

  4. #4
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    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.

  5. #5
    Software Developer jverkoey's Avatar
    Join Date
    Feb 2003
    Location
    University of Waterloo
    Posts
    1,903
    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.

  6. #6
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    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.

  7. #7
    Software Developer jverkoey's Avatar
    Join Date
    Feb 2003
    Location
    University of Waterloo
    Posts
    1,903
    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.

  8. #8
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    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.

  9. #9
    Software Developer jverkoey's Avatar
    Join Date
    Feb 2003
    Location
    University of Waterloo
    Posts
    1,903
    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.

  10. #10
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    Wow. That sucks. I thought I'd at least mention it in case it would save you some effort.

Popular pages Recent additions subscribe to a feed

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21