My goal is to be able to import data from an Access 2k database, about 400 records, 8 fields per record.

When a host offers MySQL and SQL Server database support, is the host always going to support remote ODBC connections, ie connect w/ MyODBC or upsizing from Access 2k w/ an ODBC connection to the SQL Server?

Also - What is the best combination out of php, asp, MySQL and SQL Server, and how would asp+SQL Server compare to its soeed
(assuming 2000 records w/ 12 fields)?

I haven't ventured beyond asp and php using access odbc, so if I'm missing something I should be considereing please let me know!

thanks

GTP,

It depends on whether the host offers the type of ODBC connections you want - without being more specific it's really hard to answer your question.

On the combinations question : PHP/MySQL are a match made in heaven - put them together and you have perfected web automation from a database. And it's all free and efficient too :)

ASP + SQL Server will usually be a fraction faster than ASP/Access at the very least due to the stored procedures on SQL Server, and work together quite well. However, usually SQL Server demands extra costs on both the host and client, since a SQL Server licence is about $700-1000 depending on where you live :)

Basically if you wanna do database stuff, stick with the following combos :

ASP/Access - limited to 10 or 30 simultaneous connections at a time (can't remember the exact no.)

ASP/SQL Server

PHP/MySQL

I want to put a small "Membership" database on the web, for committee members to access. I have experience of MS Access, and I run a web-site created using NetObjects Fusion v4.01. I recently tried using ASP's with NOF (locally) and it worked, but my present Web Hosting company has a Unix Server.

You mention using Access/ASP.
What do you mean by that? That some Web Hosting companies will allow me to upload an MS Access .mdb file so that I can use ASP's to query it?

If so, where can I find these companies?
The Advanced Search only mentions mSQL, MySQL etc etc. It doesn't have a tick box for MS Access.

Help!

Chris Eaton

Originally posted by BC:
GTP,

On the combinations question : PHP/MySQL are a match made in heaven - put them together and you have perfected web automation from a database. And it's all free and efficient too :)

Basically if you wanna do database stuff, stick with the following combos :

ASP/Access - limited to 10 or 30 simultaneous connections at a time (can't remember the exact no.)

ASP/SQL Server

PHP/MySQL

Hi Chris,

Nearly all NT hosting companies will allow you to upload Access MDBs into a separate directory (e.g. a cgi-bin directory) and then you can use ASP code to call rows from the Access DB.

Surprisingly enough I too just noted that there's no search for Access, but that might be because allowing DSN or ODBC access to Access MDBs are so common amongst NT companies.

What I suggest you do is make a list of NT hosting companies (basically any host offering ASP) and then e-mail them, explain your needs and see what you get. I've just signed up with WebExpose.net (http://www.webexpose.net), and they allow access to Access. So far, everything's working very well and support has ranged from consistent (at 4 a.m. US EST/7 p.m. Australian EST) to fantastic (US peak time).

Other reputable NT companies to consider include http://www.windowswebhost.com http://www.innerhost.com

Post a reply if you require further help. Cheers!

[This message has been edited by BC (edited 08-27-2000).]