Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Jul 2005
    Thanked 0 Times in 0 Posts

    SQL client error!

    Hi, recently i have setup a SQL server and i have occur a few problems.

    1) I have tried connecting to the SQL server on my client using SQL enterprise manager. And no error occurs. But when i tried using ASP.NET connecting to the SQL server on my client, there is an error which shows,
    SQL Server does not exist or access denied.

    2) i wonder if there's any setting i need to set on SQL server? or in my ASP.NET, please help

    below are the codes:-

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    'Put user code to initialize the page here

    Dim cn As New SqlConnection("server=FYPSERVER;uid=sa;pwd=ckpuni123;database=FYPGamePortal")
    Dim cmd As New SqlCommand("Select * from tblNews", cn)
    Dim da As New SqlDataAdapter(cmd)
    Dim ds As New DataSet

    da.Fill(ds, "tblNews")

    DropDownList1.DataTextField = "intNewsID"
    DropDownList1.DataSource = ds.Tables("tblNews")

    End Sub

    please help, thanks alot

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Thanked 40 Times in 40 Posts
    Hi hiryu23,
    We do have a forum specifically for asp.net questions, i'll be moving your thread over. But There could be several causes to your error you specified, check out Potential causes of the "SQL Server does not exist or access denied" error message

  • #3
    New to the CF scene
    Join Date
    May 2005
    Thanked 0 Times in 0 Posts
    I have always used a local ODBC entry to point to the SQL/mySQL server on my computer. I have found it was just easier.


    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts