Connection string problems

LAGooner10 wrote:
> Hi, my hosting company decided to 'upgrade' me to SQL Server 2008. Using IIS7
> Manager I created a DSN connection string and now I'm trying to establish that
> connection in DWCS3. The connection string created is
>
> Server=99.99.99.999;Database=someDatabase;Integrated Security=true
>
> and my DW connection string reads
>
> <%
> // FileName="Connection_ado_conn_string.htm"
> // Type="ADO"
> // DesigntimeType="ADO"
> // HTTP="true"
> // Catalog=""
> // Schema=""
> var MM_connEwhse2_STRING =
> "Server=99.99.99.999;Database=someDatabase;Integrated Security=true"
> %>
>
> When I test an ASP page in the browser I get the following error:
>
> Microsoft JScript runtime error '800a1391'
> 'MM_connEwhse_STRING' is undefined
> /login.asp, line 13
>
> So it's obviously having a problem with DW code for some reason. Any help
> would be appreciated as this 'upgrade' is being forced upon me.

Your connection is using MM_connEwhse2_STRING, so change any reference
in your recordset code from MM_connEwhse_STRING to MM_connEwhse2_STRING
and you will be good to go

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html