<div>
<div class="content wysiwyg-content">
Using SQL 2005<br />
<br />
When using access.mbd with an asp website I usually create a database within the web site directory and then create a connection so that the pages can use the database.<br />
I am wanting to use sql 2005 and I am not sure where the database should be placed or how and whether a connection is created.<br />
<br />
Can anyone please offer some advice on this, I am finding it difficult to get this from the books I have.<br />
<br />
Thanks<br />
John
</div>
</div>


Using SQL 2005

When using access.mbd with an asp website I usually create a database within the web site directory and then create a connection so that the pages can use the database.
I am wanting to use sql 2005 and I am not sure where the database should be placed or how and whether a connection is created.

Can anyone please offer some advice on this, I am finding it difficult to get this from the books I have.

Thanks
John

Using SQL 2005 database with asp

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.