User Profile

Collapse

Profile Sidebar

Collapse
dfarney
dfarney
Last Activity: Jun 4 '08, 01:14 PM
Joined: Nov 21 '07
Location: Texas!
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • dfarney
    replied to C#-App: Cannot connect to SQL Server
    in .NET
    I basically did that...I put a function at the beginning of the application that tested like 10 different connection string that work for me, and every one returned the same error message as above. I dont think that its a time out issue because I was talking to her over then phone when she ran it and the application started up in about the same amount of time, but Ill give it a try anyways. I did something like this:
    Code:
    string connString =
    ...
    See more | Go to post

    Leave a comment:


  • dfarney
    replied to C#-App: Cannot connect to SQL Server
    in .NET
    Its really hard to tell what is different on the machine being that they are in Utah and I'm in Texas. From what I understand she is not on a network, talked to the ISP and they said it wasn't anything they were blocking on their end. As far as having a version of SQL Server on the machine, I highly doubt it...

    I guess my question is what else could be blocking her access to our data servers/our servers blocking her? My connection...
    See more | Go to post

    Leave a comment:


  • dfarney
    replied to Open frmDataGrid from Form # 1
    in .NET
    In C#:

    create your frmDataGrid class like so...
    Code:
    public partial class frmDataGrid : Form
    {
        [B]private string date;[/B]
    
        public frmDataGrid()
        {
            InitializeComponent();
        }
    
        [B]public frmDataGrid(string _date)
        {
            InitializeComponent();
            date = _date;
        }[/B]
    }
    Call it like so...
    Code:
    if (txtDate.MaskCompleted)
    ...
    See more | Go to post

    Leave a comment:


  • dfarney
    started a topic C#-App: Cannot connect to SQL Server
    in .NET

    C#-App: Cannot connect to SQL Server

    So I've created a Windows based application in C# that uses data from our databases on a service provider (crystaltech). The application has been deployed and has been working great on all our computers and all our clients computers, except for one... When every they try to login/communicate with the database it returns the following error:

    Code:
    System.Data.SqlClient.SqlException: An error has occurred while establishing a connection
    ...
    See more | Go to post

  • Sorry I havn't gotten back on here in a while....

    Frinavale is right; we're getting blocked somewhere it's just a matter of finding out where...In my situtation my client was getting blocked by his network within the building he lived/worked in.

    You connection string looks good as did mine -- try going to Control Panel -> Windows Firewall -> Exceptions -> Add Port... and add the the ports 1433 and 1434.
    ...
    See more | Go to post

    Leave a comment:


  • C# Application: Remote Connection to SQL Server 2000 issues

    I have created a program in c# .net 2.0 that connects to a remote sql 2000 server. Connection for all our users/clients all over the US is fine, execpt one. Im thinking that it his firewall, but when XP prompts him he clicks "allow access". Here the the error message he gets:


    Code:
     
    System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server
    ...
    See more | Go to post
No activity results to display
Show More
Working...