Hi Guys.
I'm trying to write a connection string and store it in a file called connection.asp.
I have included the file using
<!-- #INCLUDE FILE="Connection.asp" --> But I am having problems with string. Could someone please give me an example of using a connection string on a my Database.

It is a SQL Server DATABASE on a machine called "SQLSAMPLE" which is a different machine to the one that I am storing my ASP's on. The Username is "User"and the password is "password". I want to use ADO to connect. Could someone please let me know how to do this.

Thanks
JK