How Do You Deliver A WinForm App With SSEE
May 28, 2008
I have asked this question before (but the question was geared for something else). Let me briefly lay out my question.
I currently have a WinForm app I distribute that interfaces with Access. When I distribute it, I have in the application startup path a folder called "Database" which has the Access .mdf. With me so far?
Now.
I have tools that automate and semi-automate the embedding of important information into my database during the course of a project. However, because more people are starting to use my tools, we have a concurrency issue. I was looking at SSEE as a replacement for Access to solve this problem and avoid the concurrency problem. Hence it is not for the customer I am moving to SSEE but for my internal team who use my tools.
I am having a difficult time delivering the finished product because I don't quite know how to deliver SSEE. I am very proficient with setups, and know that as a prequisite they have SSEE as a selectable item, but how to I attach my database to SSEE in the setup? Do I need to detach my database from my server and reattach it during the setup for the customer?
I have found no articles describing this (except ClickOnce which is not what I want). If everyone raves about SSEE over Access, I would think this would be a widely available question.
This is probably a question for a MVP or someone who has dealt with this personally, so I would welcome your expertise in this matter.
Thanks
View 7 Replies
ADVERTISEMENT
Nov 28, 2006
Is there a way to make the data selecatable. For example, a user runs a report and wants to copy the applicationId onto their clipboard so they can use it to search in another application. Currently they have to remember or write down a 9 digit number. Not very user friendly...
I am currently using a data table as the container for the data in my rdl file. Then I use reportviewer for winforms to embed it in our user application.
Thanks
View 3 Replies
View Related
Sep 22, 2004
Edited by SomeNewKid. Please post code between <code> and </code> tags.
Hello, I have given up after 3 hours of trying to get a DBNull.Value to be inserted into SQL 2000 DB. Below is the code that exists in an object that I use both from a VB.NET Windows application and from an ASP.NET application. (same exact compiled object dll). Has ran fine with windows application for almost a year - still does. Use the same object in my new ASP.NET application and I get a SQL Overflow error that says date must be between 1753 12 am etc etc... when trying to insert null using the code below.
This one has me stumped. The lines below where I set the date are basically this (what the logic equates to):oDR.Item("CT_CustomDate1") = DBNull.Value
oDR.Item("CT_CustomDate2") = DBNull.Value
Error gets thrown when this line is executed:oDA.Update(oDT)
Also, the CT_CustomDate1 & 2 fields in the SQL Server 2000 DB are of type SmallDateTime and the variables in object used in code function below are Date. I've tried every combination of Date, DateTime, SmallDateTime, etc. etc. to no avail.
Thanks for you help!
Public Function AddNew(ByVal sGUID As String) As Boolean
'Saves all new contact information to database
Dim sSQL As String
sSQL = "SELECT * FROM Contact WHERE 1=2"
Dim oConn As New SqlConnection(sConnectionString)
Dim oDT As New DataTable
Dim oDA As New SqlDataAdapter(sSQL, oConn)
Dim oDR As DataRow
Dim bSuccess As Boolean
Try
oDA.Fill(oDT)
Dim dataCommandBuilder As New SqlCommandBuilder(oDA)
oDA.InsertCommand = dataCommandBuilder.GetInsertCommand
oDA.DeleteCommand = dataCommandBuilder.GetDeleteCommand
oDA.UpdateCommand = dataCommandBuilder.GetUpdateCommand
oDR = oDT.NewRow
oDR.Item("CT_GUID") = sGUID
oDR.Item("CT_CompanyGUID") = CTCompanyGUID
oDR.Item("CT_Prefix") = CTPrefix
oDR.Item("CT_FirstName") = CTFirstName
oDR.Item("CT_MiddleName") = CTMiddleName
oDR.Item("CT_LastName") = CTLastName
oDR.Item("CT_Suffix") = CTSuffix
oDR.Item("CT_Title") = CTTitle
oDR.Item("CT_ContactAddress") = CTContactAddress
oDR.Item("CT_Address1") = CTAddress1
oDR.Item("CT_Address2") = CTAddress2
oDR.Item("CT_City") = CTCity
oDR.Item("CT_State") = CTState
oDR.Item("CT_Zip") = CTZip
oDR.Item("CT_Country") = CTCountry
oDR.Item("CT_InternationalPhone") = CTInternationalPhone
oDR.Item("CT_Phone") = CTPhone
oDR.Item("CT_Fax") = CTFax
oDR.Item("CT_Cell") = CTCell
oDR.Item("CT_AltPhone") = CTAltPhone
oDR.Item("CT_Assistant") = CTAssistant
oDR.Item("CT_AssistantPhone") = CTAssistantPhone
oDR.Item("CT_NoEmail") = CTNoEmail
oDR.Item("CT_EmailAddress") = CTEmailAddress
oDR.Item("CT_Confidential") = CTConfidential
oDR.Item("CT_TypeGUID") = CTTypeGUID
oDR.Item("CT_Designation") = ""
oDR.Item("CT_LastUpdate") = CTLastUpdate
oDR.Item("CT_UpdatedByWho") = CTUpdatedByWho
oDR.Item("CT_Location") = CTLocation
oDR.Item("CT_CustomBit1") = CTCustomBit1
oDR.Item("CT_CustomBit2") = CTCustomBit2
oDR.Item("CT_CustomBit3") = CTCustomBit3
oDR.Item("CT_CustomBit4") = CTCustomBit4
oDR.Item("CT_CustomBit5") = CTCustomBit5
oDR.Item("CT_CustomBit6") = CTCustomBit6
oDR.Item("CT_CustomBit7") = CTCustomBit7
oDR.Item("CT_CustomStr1") = CTCustomStr1
oDR.Item("CT_CustomStr2") = CTCustomStr2
oDR.Item("CT_CustomStr3") = CTCustomStr3
oDR.Item("CT_CustomStr4") = CTCustomStr4
oDR.Item("CT_CustomStr5") = CTCustomStr5
oDR.Item("CT_CustomStr6") = CTCustomStr6
oDR.Item("CT_CustomStr7") = CTCustomStr7
oDR.Item("CT_CustomStr8") = CTCustomStr8
oDR.Item("CT_CustomStr9") = CTCustomStr9
oDR.Item("CT_CustomStr10") = CTCustomStr10
oDR.Item("CT_CustomStr11") = CTCustomStr11
oDR.Item("CT_CustomStr12") = CTCustomStr12
oDR.Item("CT_CustomStr13") = CTCustomStr13
oDR.Item("CT_CustomPhone1") = CTCustomPhone1
oDR.Item("CT_CustomPhone2") = CTCustomPhone2
oDR.Item("CT_CustomPhone3") = CTCustomPhone3
oDR.Item("CT_CustomPhone4") = CTCustomPhone4
oDR.Item("CT_CustomDate1") = IIf(CTCustomDate1 = #12:00:00 AM#, DBNull.Value, CTCustomDate1)
oDR.Item("CT_CustomDate2") = IIf(CTCustomDate2 = #12:00:00 AM#, DBNull.Value, CTCustomDate2)
'oDR.Item("CT_CustomDate1") = CDate(#1/1/1753#)
'oDR.Item("CT_CustomDate2") = CDate(#1/1/1753#)
oDR.Item("CT_CustomAmount1") = CTCustomAmount1
oDR.Item("CT_CustomAmount2") = CTCustomAmount2
oDR.Item("CT_CustomType1GUID") = CTCustomType1GUID
oDR.Item("CT_CustomType2GUID") = CTCustomType2GUID
oDR.Item("CT_CustomCompany1GUID") = IIf(CTCustomCompany1GUID = "00", DBNull.Value, CTCustomCompany1GUID)
oDR.Item("CT_CustomCompany2GUID") = IIf(CTCustomCompany2GUID = "00", DBNull.Value, CTCustomCompany2GUID)
oDR.Item("CT_CustomContact1GUID") = IIf(CTCustomContact1GUID = "00", DBNull.Value, CTCustomContact1GUID)
oDT.Rows.Add(oDR)
oDA.Update(oDT)
CTGUID = sGUID
bSuccess = True
Catch err As Exception
MsgBox("Error saving new contact..." & vbCrLf & vbCrLf & err.Message, MsgBoxStyle.Critical + MsgBoxStyle.OKOnly, "Database Error")
bSuccess = False
End Try
AddNew = bSuccess
End Function
View 1 Replies
View Related
Nov 14, 2005
Hi All,
I have a winform app built using vb.net that utilize SQL 2005. How do i include the database that i have within the application itself and how does that affect the connection string? This lead to the 2nd question, Will the database have multi user capability if i set the connection string to (local)? Does anybody have a step by step way to do this? Please elaborate the way to do it or share with us the link to do it.
Thanks in advance!
hwdevelop
View 2 Replies
View Related
Aug 1, 2007
Hi,
Am having an SQL Server 2005 Embedded Edition (MICROSOFT##SSEE) as database server.(Windows2003 + WSS3)
Some database log files i.e.; LDF files , increasing by their size very quickly , attached
Could you please help me to fix this issue.
Thanks in Advance
Ratheesh.K.Nair
View 1 Replies
View Related
May 16, 2007
I have several instances of SQL express edition that WSUS says need SP2 - there is SQLEXPRESS, MSSQLSERVER and Microsoft##SSEE
The sqlexpress and mssqlserver were updated to SP2 - however, the ##SSEE won't upgrade complaining that its not a valid instance name for this SKU of SQL server?
Any idea?
View 1 Replies
View Related
Mar 24, 2007
I have created Reports using SQL Server 2005 Reporting Service.
Now I want to print them in button click on Windows Form without displaying or previewing it.
More over I want to print 2 copys at a time?
I want to print without preview.
Nilesh
View 1 Replies
View Related
Mar 25, 2008
I'm using SSEE as part of SharePoint 2003. The transaction logs are growing rapidly but don't appear to clear down.
As its SSEE I've been so far unable to connect using Management Studio or Enterprise Manager, so using DBCC Shrinkfile isn't an option.
Can someone please help? I'm surprised that when installing SP I didn't get the option to choose a db type or location.
View 2 Replies
View Related
May 27, 2008
I was thinking of replacing my desktop programs I do in Microsoft Access to SSEE. I am getting up to speed by some books and tutorials.
How would I distribute a program that has a SSEE database? I currently have in my application startup path a folder called "Database" that contains the .mdb, could I do the same thing with SQL Server. If so, what does that do to the connection string.
Thanks for any suggestions beforehand.
View 12 Replies
View Related
May 21, 2008
I have windows xp 64 bit and would like to install SSEE. However I received a message saying it was not possible. the trouble is, I am sure when I installed SSEE Management Studio It also installed SSEE. Somehow it got corrupted ( reveived message about Master Table being messed up when I treid to start the servcie).
View 1 Replies
View Related
Nov 8, 2007
hello guys,
i am using MS SSEE installed by WSUS3.
Due to a server reinstallation and new synchronisation of WSUS i have to approve/reject nearly 1200 Updates for Windows XP/Vista/Server 2003 and different Office Versions.
The new MMC lost some features to do this easyly (Filters)
Because of these missing functions i intend to install "Microsoft SQL Server Management Studio Express" to get connection to the SSEE and then create an Access-Frontend to add the functions i am missing.
Could you please tell me if this might work?
Somwhere in this forum i read, that the SSEE was intend to be not accessable.
Thanks Marcus
View 1 Replies
View Related
Mar 22, 2008
Im trying to figure out if there is a way to embed an ssis package into a c# winform?
I know that I can pass variables to a package and write the entire package out programatically, but im curious if there is a way to add the dtsx as an assembly or something. OR is there any tool that would take the ssis package and spit out its equivalent in code?
thanks
View 6 Replies
View Related
Sep 27, 2007
I saw a video on how its possible to create a local database so that when the application is being deployed, the mdf file will be deployed with it and will contain the enter data. The instructor(Beth Messi) showed that all I need to do is to add the .mdf file using the "Rightclick Project name in solution explorer > select add > add new item > then in the dialog that opens, select SQL database and click ok. I did this but the Visual Studio kept saying: "An error occored while extablishing a connection with the server. When connecting SQL Server 2005, this failure may have been caused by the fact that under the default settings of SQL Server does not allow remote connections. (Provider: Shared memory provider, error: 40 - could not open a connection to SQL Server)"
Honestly, I don't know how to go futher with this. The SQL server am using is the professional edition and I have been able to use it through Visual Studio to create Databases. It connects alright in that senario. Please I really need help here.
View 1 Replies
View Related
Jul 18, 2007
SSEE is up an working. Reporting Services is installed and now somewhat operational.
When I go to localhost/reports all I get is the following:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
When I go to localhost/reportserver I get:
test2k/ReportServer - /
Monday, July 16, 2007 7:03 AM <dir> Data Sources
Monday, July 16, 2007 7:02 AM <dir> Report Project2
Monday, July 16, 2007 9:13 AM <dir> Reports
Microsoft SQL Server Reporting Services Version 9.00.3042.00
I've tried many different settings in configuration but never get Report Manager.
I'm running W2K pro (a clean install with all sp's).
I can view those reports at localhost/reportserver but this is not the interface I want.
Any help pointing me in the right direction would be greatly appreciated.
View 9 Replies
View Related
Nov 7, 2006
In order to provide runtime, realtime, graphical feedback to ETL operators, I am planning to open a new winform when my packages start, and update the form via polling of events.
It is my understanding that this means I need to create a new thread for the winform from within the script task. Anyone done this via script task yet? Any reason why this couldn't work or shouldn't be done from the script task?
Would I be better off writing the winform app completely seperately and simply call it from an "execute process" task?
Thanks,
Ken
View 3 Replies
View Related
Feb 27, 2004
Hi
We are repeatedly having the trouble of our publisher database becoming unresponsive during network problems.
We have publisher in carribean, distribution agent in canada and subscribers all over. The problem comes when publisher cant deliver to distributor due to network outages.
We are planning on moving the distributor to the carribean ultimately but that will take a while, and our application repeatedly needs to be restarted due to these freezes.
Does anyone know of this problem & possible ways to fix it in the short term (short of changing our replication topology).
is this a bug in replication?
ps.database is merge & transactional pubs. (some tables merge/some trans)
help much apprec,
des
View 6 Replies
View Related
Aug 26, 2005
with datediff all I can get it to return is months or a total of thedays...so if the difference in dates is 12 months 4 days how do I adjust theSQL to accommodate both?
View 3 Replies
View Related
Feb 19, 2007
I have created a publisher with row filtering using merge replication .I configured 5-6 subscribers for it.It was working fine for 2 months.But now for two subscribers its showing an error Process could not deliver update (s) at the publisher
Ive checked the job history..its showing
Merge process encountered an unexpected network error. The connection to tublisher 'Publishername' is no longer available
can any one help me?
thanks and regards
Dhanya
View 3 Replies
View Related
Jul 17, 2007
Hi all,
how can standard subscription or data driven subscription be used to deliver reports to specific email address.
the standard subscription or data driven subscription can be used to delever reports using Windows file share ,but how to make it work for delivering to emails..
can anyone help me out???
View 1 Replies
View Related
Jul 9, 2007
Hi Sql Gurus.
Please help me i'm in troublle now.
I have Two databases,that same schemas and same tables. that both servers are different location. but data must be update and input from both sites.that data must be same both.
so i've planed to replication data both servers,then i must chose merge replication right?
so i'm set
server1 (assumed server1 as main) are Distributor/Publisher
and
server2 just Subscriber only
that i can configuration successfully.
then i'm chose push replication from server1 but it's not work.
this is error message that show
The process could not deliver the snapshot to the Subscriber.
please advise me what's wrong and how to fix problem?
Thank you.
View 5 Replies
View Related
Feb 21, 2008
Hi.
I'm using data-driven subscription to deliver reports to users via email.
However every few days or so, some of the reports will fail to get delivered to some of the subscribers. The rpts and subscribers affected are usually not the same.
The log showed the below messages....would really appreciate if anybody can shed light on this! TIA!
ReportingServicesService!library!16!02/21/2008-09:03:09:: i INFO: Call to RenderFirst( '/Daily Movement Reports/FDDlyTopRevoAgt' )
ReportingServicesService!cache!16!02/21/2008-09:03:09:: i INFO: From cache live: /Daily Movement Reports/FDDlyTopRevoAgt
ReportingServicesService!library!16!02/21/2008-09:03:09:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!dbpolling!4!02/21/2008-09:03:09:: i INFO: NotificationPolling processing item 336709ba-97ce-4e6f-b9d3-09ae26e9f6fb
ReportingServicesService!library!4!02/21/2008-09:03:09:: i INFO: Call to RenderFirst( '/Daily Movement Reports/FDDlyTopRevoAgt' )
ReportingServicesService!library!4!02/21/2008-09:03:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.IO.IOException: The process cannot access the file 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesRSTempFilesRSFile_bbc8b100-f99e-438f-88bc-bd796b88bc1c' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at Microsoft.ReportingServices.Library.PartitionFileStream..ctor(String path, PartitionManager manager, Boolean deleteOnClose)
at Microsoft.ReportingServices.Library.PartitionManager.GetFileFromPartition(String path)
at Microsoft.ReportingServices.Library.MemoryThenFileStream..ctor(String filename, Int32 threshold, PartitionManager partitionManager)
at Microsoft.ReportingServices.Library.CachedData.GetNewStream()
at Microsoft.ReportingServices.Library.CachedRenderingResult.GetRenderingResult()
at Microsoft.ReportingServices.Library.RSService.RenderAsSnapshot(CatalogItemContext reportContext, Guid reportId, DateTime executionDate, DateTime expirationDate, ClientRequest session, ReportSnapshot snapshotData, String description, Boolean foundInCache, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
View 1 Replies
View Related
Jul 18, 2007
Hi All,
I am working on a report which displays profit and loss discrepancy between two systems. So if there is discrepancy, in other words, the dataset returns value, then I want reporting serive to deliever the report to intended users. I am currently using standard edition with no data-driven subscription support.
I do not know what is the workaround for this implementation. Tks for advise in advance.
Alex
View 7 Replies
View Related
Jan 29, 2007
I am Having trouble trying to set up SQL Server Replication Utilising Web Synchronisation Where the
IIS(Web Server) is on a separate machine to the SQL Server(Publisher). I am using MSDE as the SQL Server Box, however even when I used SQLServer2000, or SQLServer2005 I have had no joy with the 2 separate Servers setup.
If I have the one server then I have no problems (i.e. One Server Setup)
Server A: Windows 2000,
with MSDE installed
enabled for Merge replication,
and has a Publication set up.
IIS Web Page Setup for Synchronisation
My SQL Server 2005 Mobile device syncs via the web page on ServerA Fine, no problems at all.
The Trouble is when I am trying to utilise SQL Server Replication as follows. (i.e. 2 Server Setup)
Basically I am using the Same ServerA as in the one Server setup I had above. All I have done is I am now using a Separate IIS Server for the Web Synchronisation ServerB
I have run the "Configure Web Synchronisation Wizard"(ConnWiz30.exe) on my web page on ServerB. And I am using Anonymous Access Authentication With Windows NT Authentication on my Web Server(ServerB),
the Anonymous User is a Domain user, and is the Same Domain User I used in the One Server setup which I had working (so this IIS Anonymous Domain user should have all permissions required on the ServerA (SQL Publisher) both Windows permissions and SQL Server Permissions.
Server A: Windows 2000,
with MSDE installed
enabled for Merge replication,
and has a Publication set up.
Server B: Windows XP, IIS Web Server(Web page enabled for Web Synchronisation)
I have a Mobile device as a subscriber, which is using Web Synchronisation on ServerB(Web Server), to sync with the ServerA (MSDE Box).
The error I am receiving is "A Call to SQL Server Reconciler has Failed" Try to resynchronise, "The Process Could Not deliver the Snapshot to the Subscriber"
A little extra info:
-I can remotely connect from my Web server(ServerB) to the SQL Box ServerA via a TCP/IP ODBC connection so remote connections does not seem to be an issue.
-If on My Mobile device if I try to Add a Subscription & Synchronise the replication using the
AddSubscription(AddOption.ExistingDatabase), it works fine. (Obviously the subscription database does exist before the synchronisation)
If I try to Add a Subscription & Synchronise the replication using the
AddSubscription(AddOption.CreateDatabase), I get the error as mentioned.
Is there something I have missed? Any help you can provide is much appreciated.
Thanks.
View 4 Replies
View Related
Apr 29, 2008
SQL server 20005 SP2 is install in my WIN XP machine. I implement a SSRS report and try to deliver the report to a share folder in window 2000 server.
I create and set permissions on a shared folder as per the information in http://msdn2.microsoft.com/en-us/library/ms345228.aspx. The account that I use in subscription is local admin account in the target machine.
I have try path \<servername>c$XXX and \<servername>XXX. Both is not ok.
I find following error message in the log file of reporting service.
ReportingServicesService!library!d!04/29/2008-00:03:40:: e ERROR: Throwing Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid., A logon error occurred when attempting to access the file share. The user account or password is not valid.;
Info: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
--- End of inner exception stack trace ---
If I try to deliver same report to a share folder in WIN XP in the same way. It is ok.
View 7 Replies
View Related
Jun 10, 2007
Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?
I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.
For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.
Any insights?
View 1 Replies
View Related
