How do I set up SQL Server database on a host for web access?

[AlbertAguirre]

I have set up Ms Access databases with much success and read/updated/deleted data with my PHP app but I dont know how to set up an Sql Server database?

Please help. New to SQL server but love it!

 

[codestorm]

Generally as long as you have a login on SQL Server that can do what you want, just whack the login details into the connection string.
(I'm not familiar with PHP but I'd assume the only different would be the driver)

&quot;driver=<put PHP driver here>; server=<SQL Server machine name/ip>; database=<database name>; uid=<SQL Server login>; pwd=<password for SQL Server login>;&quot; <insert witticism here>
codestorm

 

[AlbertAguirre]

Actually, I am familiar with connectivity with PHP, but my question is, do I ftp the SQL database file to the host and just let the host support people know so they can create a DSN entry?
Thats how its done with Access, is it the same with SQL Server? That easy? Not sure...

 

[Guest_imported]

Get your host to create a SQL database on their server. You can add that server to your &quot;Enterprise manager&quot; on your local mahcine. You can then manage all database objects from your local machine (send them up using - Data Transformation Services).

 

[AlbertAguirre]

Ahhhh.. Thats what I was looking for.

OK. Will leanrn &quot;Data Transformation Services&quot;

Thank you...

 

[codestorm]

A word of warning using SQLEM remotely - it can be horribly slow - especially if the remote SQL Server is hosting a hundred or so databases (as in free hosters).
(not to mention the number of times I've seen DTS bring down the computer). <insert witticism here>
codestorm