Error Deploying An unexpected error occurred while compiling expressions. Native compiler re

When attempting to deploy a series of reports I am receiving the error:

An unexpected error occurred while compiling expressions. Native compiler return value: ‘128’.

The datasources deploy fine, but each report results in the same error. I can build the project and preview each report without issue, it is only on the deploy that the error occurs.

Any help would be appreciated

Jason

just wanted to share the "solution" to the issue.

I attempted to login to the reporting services manager so I could try and upload the reports that way rather than deploying through visual studio and I received an error: Could not find file 'C:\WINDOWS\TEMP\xw1mue_7.dll' The dll changed each time, but I found a post in google groups that suggested restarting the app pool to resolve this issue. Seems to have solved both problems.

I would still like to know why the app pool needed to be restarted....

|||Restart IIS to solve that problem.

Error connecting from classic ASP

I'm haveing some problems with using SQL Server in a classic ASP app.

When trying to connect with the db I get the error:

Microsoft SQL Native Client error '80004005'

TCP Provider: No connection could be made because the target machine actively refused it.

The Windows 2003 server runs both the SQL server 2005 express and IIS.

Connectionstring: "Provider=SQLNCLI;Server=KSP;Database=KSB;UID=sa;PWD=;"

I don't have a good answer for this one; it seems a bit like a permissions issue, you might want to check what user context your ASP app is running in and make sure that user has permission to the database file or server.

You should also consider asking this question in the .NET Data Access forum or in the ASP.NET fourms. The folks that hang out there have probably had more experience with ASP than I have.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Sql server express is a named instance, so you need to specify <servername>\sqlexpress in you connection string.

Check this out.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

|||

Thank both of you for your advice. It was the <servername>\sqlexpress which was the problem.