Hello Every
I have a problem withASP.NET connect toDatabase Snapshot SQL Server 2005.
Step One: I create database snapshot.
Step Two: I want to use ASP.NET to Database Snapshot that create already. But I don't know connection string to database snapshot.
Please help me .....................
Thank You,
I also have the same problem as follows:
The first execute of SQL Server 2005 tasks to creates the snapshot as follows:
USE Master;
GO
IF EXITS (SELECT name FROM sys.database WHERE name = "N'source_system_snapshot_extract')
BEGIN
DROP DATABASE [source_system_snapshot_extract]
END
GO
CREATE DATABASE source_system_snapshot_extract ON
('C:\Test\source_system_snapshot_extract.ss)
AS SNAPSHOT OF source_system
GO
The second I want code in the ASP.NET to connect to the database snapshot replication above
Please post your example code if anyone can solve this problem.
|||In the ASP.NET from the code design , i write the code as follow:
Imports Microsoft.SqlServer.Dts.RuntimePublic Sub Main()
Dim Constr$=Dts.connections("Source_System").connectionstring
If not Constr.contain("Initial Catalog=Source_System") then
Dts.taskresult=dts.results.failure
return
Endif
Dts.connections("Source_System").connectionstring=Dts.connections("Source_System").connectionstring.replace("Initial Catalog=Source_System", ("Initial Catalog=Source_System_Snapshot_Extract")
Dts.taskresult=dts.results.Success
End sub
The code above does not response correctly to have the database snapshot connect to asp.net
However ,DTS does not show up in code.
Please held me to resolve this .
|||
With your above code, I have write the same code using the Visual Studion IDE, then I have added a reference as follows:
Microsoft.SqlServer.ManagedDTS.DLL
To add the reference above, it is in order to create using statement as discussed in the above code, but it is not possible to display the right statement. I think someone in Microsoft with SQL Server 2005 Specialist will help us to code this. The crucial help from Microsoft will be usefull the programmers over the world.
|||
Thanks alot that you try to help me.
but i still got a problem i can't connect to database snapshot with VB.NET.
Microsoft said that we can do database with database snapshot . but try to find any sample on the internet websit i can't found about that problem , How to connect to database snapshot with VB.NET.
i don't belive in that The Microsoft speak a lie all of customers that support his product, but i am not sure untill he solve this problem , to indicate
me to know or all of programmer in the world.
i hope that someone in Microsoft with SQL Server 2005 Specialist will help this.
|||I try helping to solve this problem, but i have still not yet find the solution. I think that there will be another specialist like moderator, contributor or commentator of this web site will help you to solve this problem. I have read some technical notes regarding to your needs I hope SQL Server Specialist from Microsoft will assist you to resolve your problem.
If Database Snapshot Replication has no connection with VB.NET, I believe that the SQL Server 2005 programmer within Microsoft was not hosted this project in SQL Server 2005 Project.
|||I understand your concepts related to the database snapshot to create just the read-only databases for viewing the reports. This is no need to use the original database with SQL Server 2005 install to come along with your backage, but I have some link to talk about database snapshot, but this web is not talking the database snapshot connecting with VB.NET (http://articles.techrepublic.com.com/5100-9592_11-6146916.html), (http://www.code-magazine.com/article.aspx?quickid=0311101&page=4), also see this link:http://sqljunkies.com/WebLog/marathonsqlguy/archive/2006/05.aspx. I think there is no way to code from VB.NET to connect the database snapshot out of the original database.
I probably am poor with this coding, I hope someone in this site will save you to code this and attached with nice example project.
|||?????????????????? ?????????????????????????????????????http://www.c-sharpcorner.com/UploadFile/paulyau/DBOpsInADOPA11302005071252AM/DBOpsInADOPA.aspx
|||
Please read this link:https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1149179&SiteID=1 , I think it is useful for you.
|||Also see this link:http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=63581&SiteID=17
|||
This is also useful link:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1458445&SiteID=1
|||
See this help you:http://msdn2.microsoft.com/zh-cn/library/microsoft.sqlserver.management.smo.database.isdatabasesnapshot.aspx
|||
Is this link help you:http://support.microsoft.com/kb/319649 orhttp://support.microsoft.com/kb/319648/
|||
This topic is still error. Please help me
