I would do a simple recovery backup regularly because if your reports data change regularly the session data today is not the same the next day and I have not...

All I know is there are known issues using application developed in x86 and deploying to x64 RDBMS included, when it runs in x86 and there are issues in x64...

So, here we use the SQL Native Client (x86) version and build an OLEDB connection (or ODBC). We put in our instance name for the SQL Server we want to...

Gift, I have to agree with SQLDBA here. I see nothing that says a database hosted on a x64 server requires the client running on an x86 machine to know...

Your error is documented with many possible solutions so check below and see if you any of the issues are relevant to you.

http://msdn.microsoft.com/en-us/library/aa337324(SQL.90).aspx

Is it possible for use to build a simpler web UI that uses a Report Builder API under the covers but allows us the flexibility to not show a bunch...

The above is the reason for my statement and a client application...

Maybe I am just getting confused. But yes, an x64 OS installs both the x86 and x64 drivers so clients can connect via either. My point is, there is...

Actually it matters that is the reason the x64 boxes installs both x86 and x64 drivers so you can use the correct driver as needed. Office is not a...

Then you could just use the x64 ODBC driver to configure connection for the application, I am sure your vendor would not have issues with that. This could be...

In my experiences and in the Minneapolis market, it's been easier & cheaper to find a Crystal consultant than SSRS. Possibly because I've seen most with SSRS experience also having...

IDENTITY comes with gaps in the auto increment so you can use DBCC CHECKIDENT to reseed the IDENTITY property and use SCOPE_IDENTITY to return the last number, the reason is...

That is correct because as of SP2 even the Enterprise edition can use 64gig of ram but you may also need more processor, so RTM Enterprise cannot use 64gig of...

There are many differences when it comes to application because if it is a .NET application developed with .NET 1.1 is cannot run x64 RDBMS without some issues could be...

You are missing the fact that both ReportServerDB and ReportServerTempDb are required for upgrade to new version of SQL Server like 2000 to 2005 to 2008, to move ReportServer to...