connection string help please

I am using Dreamweaver 8 on Windows XP. I am trying to connect to SQL Server 2005. My connection string isn't right. I ran the OBDC test and it works so I know its the connection string. My webpages give me the error that the server does not exist or access denied. When I use anything else like SQLNCLI.1 for the provider it gives me the error that the provider is not found. What should the connection string consist of and what should I use for Provider?

MYCONN_Conn ="Provider= SQLOLEDB;Data Source=sql2005.loc.mss.edu;Integrated Security=SSPI;Initial Catalog=OPENAssessment;"

Thanks in advance.

instead of giving server namesql2005.loc.mss.edugive actual IP address of the server. This should fix

|||

Here's an example connection string taken from one of my live web apps:

<addname="ConnectionString"connectionString="Data Source=xxxxxxx;Initial Catalog=xxxxxxx;UID=xxxxxxx;PWD=xxxxxxx"providerName="System.Data.SqlClient" />

For the data source in test we use the machine name, in production, we use the IP address (xxx.xxx.xxx.xxx) of the production Sql Server.