I have a Windows Service written in VB.net that will load a report and email it to a user. I am using CR XI, SQL 2005. This has worked previously but all of a sudden, no longer works.
On a Vista machine the windows service just stops with no errors. On an XP machine, I get "failed to open database connection, database vendor code: 17". It is running in a domain environment (nor sure if this matters) using SQL Windows Authentication.
Interstingly enough, the same code runs (and works) in a Windows Forms application.
here is a code snippet:
Dim rd As New ReportDocument
rd.Load(ReportName)
For x As Integer = 0 To rd.DataSourceConnections.Count - 1
If (rd.DataSourceConnections(x).DatabaseName = "AssetTracker") Then
rd.DataSourceConnections(x).SetConnection(gstrBackEnd, "AssetTracker", True)
End If
Next
Any help is appreciated!
Edited by Cheri Reed - 12 Mar 2009 at 10:58am
IP Logged