Help with accessing database

Hello,

I just switched to a host that allows database connections so that I can now upload my database to their server.

When I test my site on my personal PC it works great. I upload everything to the server and nothing. I know that I need to load the database to the server. I have Microsoft SQL Server 2005 Express and can make the connection but how do i load my database from my personal PC to the host computer?

I would be greatful if someone was able to walk me thou the steps on how to transfer the database. I am really very new with the database thing and ASP.

Thank You

Chris

this Embedded database feature is only available in SQL SErver express. In all other edition of the sql server 2005 , this featuer will not work. If you need to transfer the database from you r pc to host , if its not Express then you need to either use Backup/restore method or Dettach/attach method to transfer the database. And also you need to change the connection string since its totally differ.

You can refer BOL for Backup /Restore database with Move option and also Sp_Attach_db and sp_detach_db

Madhu