Click here to Skip to main content
15,896,505 members
Home / Discussions / C#
   

C#

 
GeneralRe: Windows media encoder and server Pin
Dave Kreskowiak18-May-04 2:29
mveDave Kreskowiak18-May-04 2:29 
GeneralPic in databse Pin
sreejith ss nair17-May-04 23:58
sreejith ss nair17-May-04 23:58 
GeneralRe: Pic in databse Pin
Heath Stewart18-May-04 4:21
protectorHeath Stewart18-May-04 4:21 
Generalthe global Hook doesnt work Pin
fu017-May-04 23:34
fu017-May-04 23:34 
GeneralRe: the global Hook doesnt work Pin
Dave Kreskowiak18-May-04 2:27
mveDave Kreskowiak18-May-04 2:27 
GeneralRe: the global Hook doesnt work Pin
fu019-May-04 23:28
fu019-May-04 23:28 
GeneralRe: the global Hook doesnt work Pin
Dave Kreskowiak20-May-04 0:54
mveDave Kreskowiak20-May-04 0:54 
GeneralStarting a Crystal Report on another databaseserver Pin
jvbragt17-May-04 22:33
jvbragt17-May-04 22:33 
All our (Crystal) reports are created using NT Authentication (integrated security). At run-time we want to switch to SQL Server Authentication.
We are using Crystal Reports for Visual Studio .NET 2003 and the database is always SQL Server.

I pasted our code below. This code works fine as long as the database is on the same (local) SQL Server. As soon as we specify another database server then the statement Table.TestConnectivity() always return false!
Can anyone help?

ConnectionInfo ConInfo = new ConnectionInfo();<br />
ConInfo.DatabaseName = "AA_DB40";<br />
ConInfo.ServerName = "MyDatabaseServer";<br />
ConInfo.UserID = "sa";<br />
ConInfo.Password = "secret";<br />
<br />
foreach (CrystalDecisions.CrystalReports.Engine.Table Table in ReportObject.Database.Tables)<br />
{<br />
   TableLogOnInfo LogonInfo = Table.LogOnInfo;<br />
   LogonInfo.ConnectionInfo=ConInfo;<br />
   Table.ApplyLogOnInfo(LogonInfo);<br />
   if (Table.TestConnectivity())<br />
   {<br />
     Table.Location = ConInfo.DatabaseName+".dbo."+Table.Name;<br />
   }<br />
}<br />
<br />
crystalReportViewer1.ReportSource = ReportObject;

GeneralRe: Starting a Crystal Report on another databaseserver Pin
Heath Stewart18-May-04 4:28
protectorHeath Stewart18-May-04 4:28 
Generaloops Pin
sreejith ss nair17-May-04 21:35
sreejith ss nair17-May-04 21:35 
GeneralRe: oops Pin
Daniel Turini18-May-04 0:42
Daniel Turini18-May-04 0:42 
GeneralRe: oops Pin
Aryadip18-May-04 0:57
Aryadip18-May-04 0:57 
GeneralViewing ascii in datagrid Pin
dabuskol17-May-04 21:32
dabuskol17-May-04 21:32 
GeneralRe: Viewing ascii in datagrid Pin
Heath Stewart18-May-04 4:31
protectorHeath Stewart18-May-04 4:31 
Generaloops Pin
sreejith ss nair17-May-04 21:31
sreejith ss nair17-May-04 21:31 
GeneralImage Rotation in C# Pin
mmxguy17-May-04 21:07
mmxguy17-May-04 21:07 
GeneralMessage Removed Pin
17-May-04 23:21
wibblewibblewibble17-May-04 23:21 
GeneralRe: Image Rotation in C# Pin
mmxguy18-May-04 0:00
mmxguy18-May-04 0:00 
GeneralRe: Image Rotation in C# Pin
Heath Stewart18-May-04 3:40
protectorHeath Stewart18-May-04 3:40 
GeneralWriting a bot in C# Pin
kashif Syed17-May-04 20:42
kashif Syed17-May-04 20:42 
GeneralRe: Writing a bot in C# Pin
Heath Stewart18-May-04 3:44
protectorHeath Stewart18-May-04 3:44 
GeneralImage Transparent for Web Pin
Anonymous17-May-04 19:32
Anonymous17-May-04 19:32 
GeneralRe: Image Transparent for Web Pin
Paul Watson17-May-04 23:39
sitebuilderPaul Watson17-May-04 23:39 
GeneralRe: Image Transparent for Web Pin
Dave Kreskowiak18-May-04 0:13
mveDave Kreskowiak18-May-04 0:13 
GeneralRe: Image Transparent for Web Pin
Heath Stewart18-May-04 3:45
protectorHeath Stewart18-May-04 3:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.