Post reply

Back to the drawing board.....Importing Excel data into SQL table

  • October 8, 2008 at 6:49 am

    #882223

    Have you verified that both named pipes and TCP/IP are configured to allow connections?

    This can be done via the SQL Configuration Manager not The Surface Area Config tool.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 8, 2008 at 7:57 am

    #882278

    Named Pipes and TCP/IP are both enabled.

  • October 8, 2008 at 8:17 am

    #882311

    Jason (10/8/2008)

    Named Pipes and TCP/IP are both enabled.

    On both the Client Configuration and the Server configuration? (note that there is a separate branch for each in the Configuration Manager).

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • October 8, 2008 at 8:29 am

    #882325

    These are the options in the Configuration Manager:

    * SQL Server 2005 Services

    nothing under this node

    * SQL Server 2005 Network Configuration (32 bit)

    nothing under this node

    * SQL Native Client Configuration (32 bit)

    Client Protocols - Named Pipes and TCP/IP enabled

  • October 8, 2008 at 8:30 am

    #882327

    Yes. for both Network and Client Configuration.

  • October 8, 2008 at 8:31 am

    #882329

    Create a linked server to the excel file and then query it or insert the contents to another table.

  • October 8, 2008 at 8:34 am

    #882334

    How do I create a linked server?

    I've never done that before.

    Thanks.

    Jason

  • October 8, 2008 at 8:36 am

    #882337

    Ummm. This statement:

    Jason (10/8/2008)

    These are the options in the Configuration Manager:

    ...

    * SQL Server 2005 Network Configuration (32 bit)

    nothing under this node

    * SQL Native Client Configuration (32 bit)

    Client Protocols - Named Pipes and TCP/IP enabled

    ... and this statement:

    Jason (10/8/2008)

    Yes. for both Network and Client Configuration.

    ...are contradictory. Which one is correct?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • October 8, 2008 at 8:40 am

    #882341

    Please refer to the below link

    http://support.microsoft.com/kb/321686

  • October 8, 2008 at 8:43 am

    #882343

    I sorry.

    The first statement is correct. Only for Client.

    The server configuration does not have anything under this node.

    Jason

  • October 8, 2008 at 8:47 am

    #882345

    The server configuration does not have anything under this node.

    Are you running this from your machine or the server?

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 8, 2008 at 10:01 am

    #882423

    From the server.

  • October 8, 2008 at 11:32 am

    #882474

    When you open your services console(start|run|services.msc), do you see any of the following?

    SQL Server (MSSQLSERVER)

    SQL Server Active Directory Helper

    SQL Server Agent (MSSQLSERVER)

    SQL Server Browser

    SQL Server FullText Search (MSSQLSERVER)

    SQL Server Integration Services

    SQL Server VSS Writer

    In the above list an instance name may replace (MSSQLSERVER)

    If you don't see things from the above list, it's very possible that you have only installed the client tools, not the database engine itself.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 8, 2008 at 11:37 am

    #882477

    All mentioned services are listed and started.

Viewing 14 posts - 16 through 28 (of 28 total)

You must be logged in to reply to this topic. Login to reply