how to connect from visual studio to a ms sql 2005 database on a server

Hello,

I have visual studio 2005 installed on my PC. I want to create a new website and I want the site to be connected to a MS SQL 2005 database that resides on my hosting account. I am thinking this can be done but I have watched videos, spent time looking for a site to help and I have hit a brick wall.

I have no idea how to do this.

Can anyone please help me with some instructions or a webpage that shows you how to do this.

Thank You

Joe

Hello,

I have found the solution and would like to share it with anyone that needs this info.

I have found you can connect to a ms sql 2005 database that resides on your hosting account either by
using the Visual Web Developer Express Edition which is free or Microsoft Visual Studio.

The first thing you need is asp 2.0 hosting account and a ms sql 2005 database activated on your hosting account.

The below will work for both versions of software mentioned above.

1. OPen your desired software program and Create a New Website

2. In the database explorer right mouse click on Data Connections and add a new connection.

Datasource = Microsoft SQL Server (SQL Client)

Server Name = This should of been supplied by your hosting provider eg sql26565.aspprovider.net

Select - Use SQL Authorisation

User Name = your username for your database (this should be provider by your provider)

Password = your password for the database (this should be provider by your provider)

Select the database from within the connect to database tab

Click ok and the database should be connected and appears under the Data Connections Folder.

If you need to know how to add grids etc there are lots of very handy videos which with what you learn will work on both versions of teh software programs mentioned here.

I Hope this helps anyone that had faced the same issue that I have. So many learning videos out there but an important step that has been missed due to the focus on the express editions.

Thanks

Joe

|||If you need to know how to add grids etc pls visit which applies to both versions of the
software mentioned. --> http://msdn.microsoft.com/vstudio/express/vwd/learning/default.aspx