My college is telling me to drop Dreamhost for some other hosting service. What he says is " I would like [a hosting service] that supports Microsoft’s databases for ODBC, PPTP and ASP. It would be really nice to store our databases on a secure system off site and connect through ODBC."
But I don’t know what else he needs as far as ODBC. I’ve shown him how to connect MS access tables to DH MySQL tables, and he was close to exporting a whole Access application via a CA design package (Erwin) to MySQL but had a few problems with a few of his item types. Is there more out there that he needs? Now that we’re also using MS SQL server for some applications?
Can we do PPTP with DH? Is it really that cool? Is a VPN that necessary if we can use ODBC to MySQL to keep our databases in sync. We’re a small natural resource management agency. We have small offices spread around Washington State. Some of use are on a T1 trunk and get good throughput 1 1.5 mbs, but some of us are on satellite disk data links so are limited to 100 to 500 kbs., and our hatcheries are on dialup. There are only 4 or 5 of us that are struggling with syncing versions of our tables, and it’s just stream temperature and fish scale aging data, not credit card numbers or financial details or secrets we’re keeping from NAS. So it seems like ODBC is good enough for us.
I have a preference for UNIX and open source so I might unfairly consider ASP as demon spawn, but I really know very little about it. But I know I can turn on support for FrontPage extensions for our domain. Is that all he needs? I develop pages with DreamWeaver 2004, and the new tools in DW work well to link page tables with ODBC to MySQL on DH.
What would you tell him? Is there other stuff out there that would be better for us? DH is only the second provider that I have ever used and I think it works great, but how would I know?