CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6

Threaded View

  1. #1
    Join Date
    Jul 1999
    Location
    Poland
    Posts
    278

    MS SQL 2000, remote connection

    Hello

    I try to play with Microsoft SQL 2000 ( 8.0 ).
    I'm able to connect when I run my application where the MS SQL 2000 is installed.
    Could you please help me to build ConnectionString to make remote connection.

    I do it as folows ( ... but I catch error "{SQL Server does not exist or access denied.} " )

    Code:
    SqlConnection myCon = new SqlConnection();
    myCon.ConnectionString = "Data Source=192.36.66.139,1433;Network Library=DBMSSOCN;Initial Catalog=" + dbname + ";User ID=sa;Password="
    btw, I found some helpful info about conn.str on the web, but it doesn't work for ms sql 2000.
    http://www.connectionstrings.com/?carrier=sqlserver

    here is configuration of my MS SQL Server 2000
    Attached Images Attached Images

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

Featured