View Complete Post
Hi all,
I have upgraded my Sql server 2005 to Sql server 2008 in window 2003 server (SP 2 standard edition) . After upgrading iam getting above mentioned MSDTC issue when try to make an distributed transaction with Sql server 2008 in my .Net application .
Note: No issues with SQL server 2005...
Please give me an solution
My MSI is running a custom action which uses SQL-DMO through an interop assembly (Interop.SQLDMO.dll). I am creating the MSI with Visual Studio 2010, and getting "[SQL-DMO] This server object is not connected" on some Windows Server 2008 x64 machines.
The previous version of my MSI was created with Visual Studio 2005 and is successfully installed on the servers which fail to run with the new MSI. Both MSI's use the exact same interop assembly.
I have tried to install SQL Server 2008 Feature Pack April 2007 - with no luck. It seems to me that the problem is related somehow to Visual Studio 2010, because the custom action does run with the older MSI.
i was normally using VS2005 and SQL server 2005...
i upgraded to SQL Server 2008... and then...
i could not build my project anymore... because of this error:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E) Source Error: sql server 2008 adventureworks database dear FriendsFor my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. And the query is -- MERGE Statement USE AdventureWorks2008 MERGE INTO Sales.SalesOrderDetailHistory AS SODH USING Sales.SalesOrderDetail AS SOD ON SODH.SalesOrderID = SOD.SalesOrderID AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID WHEN NOT MATCHED BY TARGET THEN INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty , ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount , rowguid, ModifiedDate, Cancelled) VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty , ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount , rowguid, ModifiedDate, DEFAULT) WHEN NOT MATCHED BY SOURCE THEN UPDATE SET SOHD.Cancelled = 'True' OUTPUT $action , inserted.* ; Please help me to overcome this issue and let me know where can I download that database too.Thanking youhappy Coding PostGreSQL to sql server 2008? Hi, I am new to POSTGREsql. I have a database built in POSTGresql and I have to migrate it to SQL SERVER 2008. How can I do that? Regards, ap. Word Automation Issue in Windows Server 2008 Hosting Hi,The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.Word Automation in sample ASP.NET(C#) application.I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data. When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine. But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.Data: System.Collections.ListDictionaryInternalMessage: Word has encountered a problem.Source: Microsoft WordThe code gets failed in the following line:ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this lineI cannot able to proceed further. Can anybody please help me in solving this issue?Thank you.With Regards,Ashok No ASPNET User in Windows Server 2008? I have been looking everywhere online regarding this, but have not found a clear answer. I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page. I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008. I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere. Did I set the server up wrong? or do I have to do something within ASP.Net to create this user and then give it rights? Not working on Windows Server 2008 Hi, I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work. We are using SharePoint 2007. Is there another work thru for 64bit environment. I notice windows server 2008 has a directory C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory??? Please help! Under the Table: Programming with FileStreams in SQL Server 2008 There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.Bob BeaucheminMSDN Magazine May 2009 Under The Table: Spatial Data Support In SQL Server 2008 New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.Bob BeaucheminMSDN Magazine February 2009 Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008 Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.Kent TegelsMSDN Magazine September 2008 Problem in Installation of SQL Server 2008 Dear All,I have Sqlserver2008 setup.It is work in wndows Xp.But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.Plz some buddy can help the same.regard,Rakesh gupta Problem opening dotnet 1.1 projet on 2008 web server We recently upgraded to a 2008 development web server and I installed all the stuff to get dot net 1.1 app working on the server. I can host them and they work. My problem is that when I try to open one in VS 2003 I get the following error. I set up the web server the same as my previous one, and I think a long time ago I got this error when we set up current one but do not remember how to resolve it. So I moved my project files from the old server to the new server and then I get these errors. The web Server reported the following error when attempting to create or open the Web Project located at the following url: Http://localhost:/MobTracker. 'Http/1.1 500 server error How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0 I have 64 bit machine and Windows server 2008 R2 has installed. i have successfully install WSS 3.0 , but when i tried to install office 2007 , one error has come "OS is not compatible " i thought it was asking for 64 bit office 2007 and i go through the google and R&d find no 64 bit office is available , i have used excel .dll in my custom code so my problem is that how can install office 2007 on 64 bot OS 2008 r2 machine . if anyone can help me , please let me know . thanks in advance VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it. But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow. I repaired .NET Framework 3.5sp1 installed tried this 1. I tried again, in C Prompt: Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini" it says initiation file cannot be found 2 i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini" it says reloaded from the system restored i am still getting the same error. When i manually go to my C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that.. I dont know what is happening i am trying it from 2 days and still no solution. any ideas would be real great help for me. My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729. .Net Framework 3.5 sp1 and WSP builder the one from Codeplex for 64 bit machines
dear Friends
For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008.
And the query is
-- MERGE Statement USE AdventureWorks2008 MERGE INTO Sales.SalesOrderDetailHistory AS SODH USING Sales.SalesOrderDetail AS SOD ON SODH.SalesOrderID = SOD.SalesOrderID AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID WHEN NOT MATCHED BY TARGET THEN INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty , ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount , rowguid, ModifiedDate, Cancelled) VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty , ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount , rowguid, ModifiedDate, DEFAULT) WHEN NOT MATCHED BY SOURCE THEN UPDATE SET SOHD.Cancelled = 'True' OUTPUT $action , inserted.* ;
Please help me to overcome this issue and let me know where can I download that database too.
Thanking you
happy Coding
Hi,
I am new to POSTGREsql.
I have a database built in POSTGresql and I have to migrate it to SQL SERVER 2008.
How can I do that?
Regards,
ap.
The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.
Word Automation in sample ASP.NET(C#) application.
I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.
When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.
But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.
Data: System.Collections.ListDictionaryInternalMessage: Word has encountered a problem.Source: Microsoft Word
The code gets failed in the following line:
ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line
I cannot able to proceed further. Can anybody please help me in solving this issue?
Thank you.
With Regards,
Ashok
I have been looking everywhere online regarding this, but have not found a clear answer.
I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.
I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.
I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.
Did I set the server up wrong? or do I have to do something within ASP.Net to create this user and then give it rights?
I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.
We are using SharePoint 2007.
Is there another work thru for 64bit environment.
I notice windows server 2008 has a directory C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???
Please help!
There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.
Bob Beauchemin
MSDN Magazine May 2009
New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.
MSDN Magazine February 2009
Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.
Kent Tegels
MSDN Magazine September 2008
Dear All,
I have Sqlserver2008 setup.
It is work in wndows Xp.
But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.
Plz some buddy can help the same.
regard,
Rakesh gupta
We recently upgraded to a 2008 development web server and I installed all the stuff to get dot net 1.1 app working on the server. I can host them and they work. My problem is that when I try to open one in VS 2003 I get the following error. I set up the web server the same as my previous one, and I think a long time ago I got this error when we set up current one but do not remember how to resolve it. So I moved my project files from the old server to the new server and then I get these errors.
The web Server reported the following error when attempting to create or open the Web Project located at the following url: Http://localhost:/MobTracker. 'Http/1.1 500 server error
I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.
But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.
I repaired .NET Framework 3.5sp1 installed
tried this
1. I tried again, in C Prompt: Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini" it says initiation file cannot be found
2 i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"
it says reloaded from the system restored
i am still getting the same error.
When i manually go to my C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..
I dont know what is happening i am trying it from 2 days and still no solution.
any ideas would be real great help for me.
My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.
.Net Framework 3.5 sp1
and WSP builder the one from Codeplex for 64 bit machines
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend