How to connect to SQL database residing on different server
I'm not able to override the connection to CAWASERVER1. ODBC connection to SQL database on OMIDVM008 has been set up. How do I get connected to it please? Thanks. 10/5/2009 6:49:36 PM Messasge: Could not find file 'C:\Program Files\Groff Automation\Crystal Delivery\ProcessLog.txt'. Source: mscorlib Stack Trace: 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) at System.Windows.Forms.RichTextBox.LoadFile(String path, RichTextBoxStreamType fileType) at CrystalDelivery.frmLogViewer.frmLogViewer_Load(Object sender, EventArgs e) Target Site: Void WinIOError(Int32, System.String)
I'm not able to override the connection to CAWASERVER1. ODBC connection to SQL database on OMIDVM008 has been set up. How do I get connected to it please? Thanks. 10/5/2009 6:49:36 PM Messasge: Could not find file 'C:\Program Files\Groff Automation\Crystal Delivery\ProcessLog.txt'. Source: mscorlib Stack Trace: 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) at System.Windows.Forms.RichTextBox.LoadFile(String path, RichTextBoxStreamType fileType) at CrystalDelivery.frmLogViewer.frmLogViewer_Load(Object sender, EventArgs e) Target Site: Void WinIOError(Int32, System.String)