Connection string problems

Report · Feb 20, 2009

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.

LAGooner10

Report · Feb 20, 2009

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

Report · Feb 20, 2009

Thanks Dooza, that helped but now I'm getting a different error:

Microsoft OLE DB Service Components error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/login.asp, line 13

I googled this and found an article that suggested adding the following to my connection string, but when I do that I get a different error again. Any thoughts?

Provider=SQLOLEDB;

Report · Feb 23, 2009

LAGooner10 wrote:
> Thanks Dooza, that helped but now I'm getting a different error:
>
> Microsoft OLE DB Service Components error '80040e21'
> Multiple-step OLE DB operation generated errors. Check each OLE DB status
> value, if available. No work was done.
> /login.asp, line 13
>
> I googled this and found an article that suggested adding the following to my
> connection string, but when I do that I get a different error again. Any
> thoughts?
>
> Provider=SQLOLEDB;

Get your connection string sorted here, its the best resource I know:
http://www.connectionstrings.com/

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