Hi, I'm using Dreamweaver MX/ASP.NET (VB) and a OLE DB provider for SQL SERVER.
(I'm new to ASP.NET)

I can define the database in the software, and this is the string added to the web.config file:

<add key="MM_CONNECTION_HANDLER_HagshamaDBO" value="sqlserver.htm" />
<add key="MM_CONNECTION_STRING_HagshamaDBO" value="Data Source=(theipaddress);uid=(userid);Password=(password);database=(name);" />
<add key="MM_CONNECTION_DATABASETYPE_HagshamaDBO" value="SQLServer" />
<add key="MM_CONNECTION_SCHEMA_HagshamaDBO" value="" />
<add key="MM_CONNECTION_CATALOG_HagshamaDBO" value="" />

The "test" button in the connection is responding OK, and also any dataset that i create.

But when surfing to the web site (www.wzo.org.il/aspnet/) I received this message:

System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()

I tried millions of ways to connecting, and they passed the dw test but no luck at the website...

Does someone knows what's wrong?

Thanks

Dany