none
Error When Filling TableAdapter from DBF file in C# RRS feed

  • Question

  • Hi,

     

    I'm trying to import data from a DBF file, here's the code:

    string connStr = @"Provider=VFPOLEDB.1;Data Source=C:\NICLOS\";
    OleDbConnection conn = new OleDbConnection(connStr);
    
    conn.Open();
    
    string cmd_string = @"select * from CODE";
    OleDbDataAdapter da = new OleDbDataAdapter( cmd_string, conn);
    da.Fill(dtCodes);
    
    this.inventoryItemTableAdapter.Fill(this.dataSetSS.InventoryItem);
    conn.Close();
    
    

     

    However, I get the following error:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Here:

     

    this.inventoryItemTableAdapter.Fill(this.dataSetSS.InventoryItem);
    

     

    What is wrong?

    I should add, that on my development machine, everything seems to be fine and that the errors only occurs on the clients PC.


    Bashar Lulu MVP - Visual Basic
    Tuesday, February 22, 2011 6:15 PM

All replies