I know that this is a simple question but it seems like have tried just about everything to connect to a SQL Server but i still cant. So, can someone please provide me with a connection string to a SQL Server??

Thanks

example:

Dim sConnStr, cn
sConnStr = "PROVIDER=SQLOLEDB; DATA SOURCE=YourSQLServer;" & _
           "INITIAL CATALOG=YourDB; USER ID=YourName;" & _
           "PASSWORD=YourPassword;"
Set cn = Server.CreateObject("ADODB.Connection")
Call cn.Open(sConnStr)

Regards,
Khoa Nguyen