Re: SqlConnection problem

Discussion in 'ASP .Net' started by Rick Spiewak, Aug 27, 2003.

  1. Rick Spiewak

    Rick Spiewak Guest

    Do you need a fully qualified address for your server?
    torightfax.mydomain.com?

    "A.M" <> wrote in message
    news:%23YoM$b%...
    > Hi,
    >
    > I have a SqlDataAdapter based on a SqlConnection.
    > I double checked the select query and follwing connection string precisely
    > with ConnMaker.exe tool which i have downloaded from Microsoft Knowledge
    > Base Article - 328101:
    >
    > "Data Source=TORIGHTFAX;Initial Catalog=LLAnalysis;User
    > ID=report_sa;Password=a*b*c*;Network Library=DBMSRPCN;"
    >
    > The query and connection string worked fine with and also without

    [Network
    > Library=DBMSRPCN;]
    >
    > First time i start the VB.NET IDE and go to SqlDataAdapter->Preview
    > Data->Fill Dataset it says:
    >
    > The data adapter could not return the data from the data source. the
    > connection string is invalid.
    >
    > If i try to click on Fill Dataset again it shows the data preview fine

    but
    > later i have some anomaly in actual web pages (data doesn't appear righ in
    > asp.net data grid)
    >
    > In the actual asp.net page, if I remove [Network Library=DBMSRPCN;] from
    > connection string, the connection fails. It says "SQL Server does not

    exist
    > or access denied. ". As i mentioned, that connection string worked fine

    with
    > ConnMaker.exe tool.
    >
    > The server listens on Named Pipes, TCP/IP and Mutiprotocol with default
    > settings, There is no firewall between web server and Sql Server.

    everything
    > is fine with network.
    >
    > Where the problem comes from ?
    >
    > Any help would be appreciated,
    > Ali
    >
    >
    >
    >
    >
    >
     
    Rick Spiewak, Aug 27, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mark

    Can't open a SqlConnection

    Mark, May 9, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    744
  2. Nick
    Replies:
    0
    Views:
    428
  3. WebDevHokie

    Re: Reflection and SqlConnection

    WebDevHokie, Jul 10, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    445
    WebDevHokie
    Jul 10, 2003
  4. Michael D Murphy

    Help -- SQLConnection Problem

    Michael D Murphy, Sep 3, 2005, in forum: ASP .Net
    Replies:
    19
    Views:
    656
    Daniel Walzenbach
    Sep 6, 2005
  5. Alan T

    SqlConnection problem - MySQL

    Alan T, Jul 19, 2010, in forum: ASP .Net
    Replies:
    5
    Views:
    1,064
    Leon Peon
    Jul 20, 2010
Loading...

Share This Page