Results 1 to 3 of 3

Thread: connection to sql server 2008

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Location
    Kolkata, India
    Posts
    290

    connection to sql server 2008

    hi..

    i want to connect to sql server 2008 in vb 2005.
    connection string:

    Code:
                dim SmString as string = "Data Source=192.165.0.153\sqlserver,1433;Network Library=dbmssocn;Initial Catalog=ASM2005;User ID=sa;Password=;"
                If gl_con.State = ConnectionState.Closed Then
                    gl_con = New SqlConnection(SmString)
                    gl_con.Open()
                End If
    it will not connect
    error:

    network related or instance specific error

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: connection to sql server 2008

    Moved To Database Development

  3. #3
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: connection to sql server 2008

    Is the instance name for the SQL Server install really sqlserver?
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

Posting Permissions

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



Click Here to Expand Forum to Full Width