Hi, I am hoping someone will kindly help me out. I am new to ASP and need to create a connection to an SQL server 2005 database.

I have failed misserably at web so far and is my worst subject on the course that i am doing. I understand that I must set the conection string and I am unable to utilise DSN due to the security of the servers and the need to transport the site and database between locations.

Therefore I need to write the connection string from scratch. However each time I try to connect to the DB I have errors. Could someone please provide a sample SQL server connection string please.

Thanks for reading Jon