Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: sql 2005 connection string

    Yes, connection string wrong.

    from VB use something like:

    Dim CusInfo2 As SqlConnection = New SqlConnection("Data Source=servername;Initial Catalog=database;Integrated Security=True")

    Data Source=servername Change servername for the name of the server SQL is installed.

    Initial Catalog=database...

  • RE: How to do this query using sql server

    xID= CLng(Request.Form("lname"))

    try

    pSql= "Select leagueplayer, ltID, approved From leagueplayers where ltID='" & Request.Form("lname") & "'"

    after ...where ItID= is a single then double quote.

    after ....Form("lname") & is a double then single...

Viewing 2 posts - 1 through 2 (of 2 total)